Columns in a main report and subreport

[Sarah]

I have a report which shows 2 columns in the main report. Then I have a
subreport that I show in a grouping footer that is a 1 column subreport, but
becuase it's in this main report, the preview shows the subreport as 2
columns. How can I change this when it gets to the grouping footer back to 1
column?

Thanks,

Sarah

 

[Marshall Barton]

I have a report which shows 2 columns in the main report. Then I have a
subreport that I show in a grouping footer that is a 1 column subreport, but
becuase it's in this main report, the preview shows the subreport as 2
columns. How can I change this when it gets to the grouping footer back to 1
column?

If the subreport is a single column report, then that's how
it will be displayed, regardless of how the main report is
organized.

If the main report is in two columns, the one column
subreport may appear many times in both of the main report's
columns, but this is not the same as the subreport having
two columns.

 

[Chuck]

If the subreport is a single column report, then that's how
it will be displayed, regardless of how the main report is
organized.

If the main report is in two columns, the one column
subreport may appear many times in both of the main report's
columns, but this is not the same as the subreport having
two columns.

Don't put the sub report in the detail section. Put it in the page footer or
report footer.

Chuck
--

 

[Sarah]

OK I put the subrpt in the report footer and it shows it as 1 column, but I
also have another subrpt in the report footer which shows up after the 1st
subrpt. The problem is I need a page break after the 1st subrpt. I've tried
everything as far as forcing a new page in the subrpt's before and after
properties. The only thig that works is when I force anew page after the 1st
subrpt in the detail section, but I don't want that because it has a report
footer which needs to be displayed. How do I force a pagebreak between
subrpt 1 and subrpt 2 in the report footer of the main report?

Thanks,

Sarah

 

[Marshall Barton]

Place a PageBreak control in the main report between the
subreports.

 

[Sarah]

That worked great. Thanks!

Place a PageBreak control in the main report between the
subreports.
--
Marsh
MVP [MS Access]

OK I put the subrpt in the report footer and it shows it as 1 column, but I
also have another subrpt in the report footer which shows up after the 1st
subrpt. The problem is I need a page break after the 1st subrpt. I've tried
everything as far as forcing a new page in the subrpt's before and after
properties. The only thig that works is when I force anew page after the 1st
subrpt in the detail section, but I don't want that because it has a report
footer which needs to be displayed. How do I force a pagebreak between
subrpt 1 and subrpt 2 in the report footer of the main report?