REport group across page of multi-column report

[Stephen]

I have a report with a multi-column (2) detail section. I want the group
header to span teh width of the report. The problem I have is:

1. If I put the section summary information in the group header, the header
gets cut in half because the report is multi-column
2. If I put the section summary information in the page header, the summary
is not synchronized with the group/detail sections.

How do I create a multi-column report with a header (with a field value, not
just a label) that span the report width?
Do I need to createa subreport of the detail? If so, I have been able to
createa subreport that spans multiple pages.

Help?

 

[Marshall Barton]

I have a report with a multi-column (2) detail section. I want the group
header to span teh width of the report. The problem I have is:

1. If I put the section summary information in the group header, the header
gets cut in half because the report is multi-column
2. If I put the section summary information in the page header, the summary
is not synchronized with the group/detail sections.

How do I create a multi-column report with a header (with a field value, not
just a label) that span the report width?
Do I need to createa subreport of the detail? If so, I have been able to
createa subreport that spans multiple pages.

Yes, you should leave the main report as a single column and
use a multicolumn subreport for the detail data.

The main report will then be based on a Totals type query
and the subreport would be based on the just the detail
table. They are then linked using the Link Master/Child
property.

One issue with this approach is that you must set the
subreport columns to Across then Down.

 

[Guest]

THANK YOU THANK YOU THANK YOU
THa last line about running the data across the page, not down tha page was
the answer!
I spent hours trying to find answers on multiple column sub reports & got NO
WHERE! Nothing even talked about that in MsOffice Help?!?!
You are wonderful!