Columns in the detail section

  • Thread starter Thread starter Chad Landry
  • Start date Start date
C

Chad Landry

I have a report with the following headers:
Report
Page
Number (This is a custom header to group records)
Detail

I want the report Detail section to be 2 columns.
However, when I change the page setup to give me two
columns, the number header is forced into 2 columns.(The
Report and Page headers are unaffected.) Does anyone know
how to fix this?

Any suggestions would be appreciated.
 
Chad said:
I have a report with the following headers:
Report
Page
Number (This is a custom header to group records)
Detail

I want the report Detail section to be 2 columns.
However, when I change the page setup to give me two
columns, the number header is forced into 2 columns.(The
Report and Page headers are unaffected.) Does anyone know
how to fix this?
Click to expand...


Change the report's record source to only return Distinct
number field values (i.e. no getail data fields. Then
create a subreport that includes the detail data along with
the number field. Set the subreport control's Link
Master/Child properties to the number field. With all that
in place, you can set the sub report to use multiple
columns.

Unfortunately there are several things that you can not do
in subreports. One is that, with out a lot of fooling
around, the column snaking needs to be across then down.
Another is that the Page header/footerand the Page event are
not used.
 
Back
Top