REport group across page of multi-column report

  • Thread starter Thread starter Stephen
  • Start date Start date
S

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?
 
Stephen said:
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.
Click to expand...

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.
 
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!
 
Back
Top