Parent groups not reflected in sub report
Hi, I have a sub report that displays a count. When the parent report(matrix) is run the subreport appears in the detail field.
However there is a (parent)group called result which has 2 values rad and lab when the report runs the subreport displays the same data in the detail for each group.
I need the subreport to display the correct count for each group.
August 15th, 2012 3:59pm
Hi Ghw123,
Please refer to the steps below to achieve it:
Add a parameter to your main report and subreport.Right-click subreport in the main report and select Subreport PropertiesSelect Parameters in the left pane of Subreport Properties, and click Add button.In the name text-box type in the parameter name and select parent group in the Value drop-down list.Right-click dataset in the subreport and select DataSet Properties.Select Filters in the left pane of DataSet Properties, and click Add button to add a filter like below:
Expression: [parentgroupname]
Operator: In
Value: [@parametername]
The screenshot below are for your reference:
If you have any questions, please feel free to ask.
Regards,
Charlie Liao
Free Windows Admin Tool Kit Click here and download it now
August 16th, 2012 6:02am