cascaded Filtering data to show in report studio
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
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
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.
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.