It's all about the answers!

Ask a question

cascaded Filtering data to show in report studio


Suyash adsul (91218) | asked Oct 14 '14, 12:05 p.m.
Hi,

We have created report in Rational Insight. in which we have to display Work item details for particular iteration(i.e. Work item details which fall under that iteration).

for this we have added two cascaded parameters which will allow us to select project area and iterations present in that project area.
But when we select required values from both the parameters, report is not showing expected details.
report is showing all the details without filtering data.

Please guide us how to filter data by using cascaded parameters.

Thanks and regards,
Suyash

One answer



permanent link
Steve Mulligan (1761321) | answered Oct 14 '14, 12:31 p.m.
edited Oct 14 '14, 2:16 p.m.
If the report has not filtering data, then there must not be a filter in the details query used to display your data.
You need a filter something like [PROJECT_ID]=?Project_ID?  where [PROJECT_ID] is the Project ID in your details query and ?Project_ID? is the Parameter name for your Project prompt.  You need a similar filter for Iteration.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.