Subreport select certail data from report

[rosdancer]

Hi,

I'm using a subreport in the group header. I want it to only display the records associated with that group. How can I do that? Right now it displays all of the records each time for each group.

Thanks in advance.

Roslyn

 

[rogar]

Right click on the subreport block in the main report and select "Change Subreport Links" Select the field that defines the group into "Fields to link to". At he bottom, check "Select data in subreport based on field" and select the subreport data field that matches the group field. Click OK. That's all there is to it.

Your subreport should be in a group header section by itself for best appearance.

 

[rosdancer]

Thanks for the help.

roslyn