Summary Report

Hello,

I need to create a report summary that displays data from 8 individual
reports. The control source for each individual report is a distinct
query. I am currently using an unbound report with
selected fields from each individual report to compose the summary
report.
Client totals, such as =sum([client]) are accurate for each individual
section. The problem is with displaying the actual clients on the
summary report. =[client]. On the individual report for instance, 20
client names display but on the report summary, only the first name
shows. I am stumped. How can I get this to work?

Thank you

Re: Summary Report

cgiscri wrote:

> Hello,
>
> I need to create a report summary that displays data from 8 individual
> reports. The control source for each individual report is a distinct
> query. I am currently using an unbound report with
> selected fields from each individual report to compose the summary
> report.
> Client totals, such as =sum([client]) are accurate for each individual
> section. The problem is with displaying the actual clients on the
> summary report. =[client]. On the individual report for instance, 20
> client names display but on the report summary, only the first name
> shows. I am stumped. How can I get this to work?
>
> Thank you

Maybe make the report bound.
Or maybe make a subreport
Or futz around with MoveLayout, NextRecord, PrintSection Properties

Space
http://www.youtube.com/watch?v=N1Hs2AQwDgA