A Filtered Summary Report

[wal50]

A report displays information on each sales guy (multiple records for each)
and summarizes this information for the Branch and Region. Works fine.

The user now wants to enter a sales guy's name to select that level of
information (no problem there) but also show the summary Branch and Regional
information. When I create a query query to allow him to select the sales
guy, the "other" information is not part of the result, so there is no
summary information to put in the report.

He wants to select for detail and also get the summary data. Any general
ideas on how to accomplish this?
Thanks
wal50

 

[Allen Browne]

Use a subreport to show the summary for the whole Branch/Region.

Set up the subreport's LinkMasterFields/LinkChildFields properties on the
Branch/Region, but not on the salesman. The subreport will then show the
entire total for the branch/region, even if the main report is filtered to
just one salesman.

 

[wal50]

Thanks Allen. Sounds like that will work. I appreciate the response.
wal50