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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics