Columns in subreport in main report footer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kathy Webster - 28 Nov 2005 19:56 GMT

I have subreports in the Report Footer of the main report. I would like
these subreports to display in 2 columns. I have tried setting the page
setup properties to 2 columns in the main report, the subreports, but I'm
having no luck. If I open the subreports by themselves, they format in
columns, but I can't get them to display in columns when I open the main
report.

TIA,
Kathy

Reply to this Message

Marshall Barton - 28 Nov 2005 21:20 GMT

>I have subreports in the Report Footer of the main report. I would like
>these subreports to display in 2 columns. I have tried setting the page
>setup properties to 2 columns in the main report, the subreports, but I'm
>having no luck. If I open the subreports by themselves, they format in
>columns, but I can't get them to display in columns when I open the main
>report.

The subreport's Page Setup must specify Across then Down.

Since subreport are not in control of page related
properties and event. The Down then Across option will just
run on looking for a page boundary that ir will never see.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Kathy Webster - 29 Nov 2005 21:32 GMT

Thank you. Unfortunately, the subreports have groupings, so there seems to
be a page break after each grouping if I follow your directions. The
properties are:

Group Header: Yes
Group Footer: No
Group On: Prefix Characters
Group Interval: 1
Keep Together: With First Detail

>>I have subreports in the Report Footer of the main report. I would like
>>these subreports to display in 2 columns. I have tried setting the page
[quoted text clipped - 8 lines]
> properties and event. The Down then Across option will just
> run on looking for a page boundary that ir will never see.

Reply to this Message

Marshall Barton - 30 Nov 2005 22:49 GMT

I don't think you can get your subreport columns to come out
the way you want. Using Across then Down will be a mess
with a group header involved and Down then Across just
doesn't work in a meaningful way in a can grow subreport.

The page break effect can be caused by several settings.
Check the size of each group to see if the KeepTogether
property is causing it. Other possibilities are the
ForceNewPage and NewRowOrCol properties.

There are some very tricky approaches that can simulate the
desired effect in some(?) cases, but rather than getting
tied up going down that convoluted road, I suggest that you
spend some effort trying to come up with a different
approach to presenting the data.

Signature

Marsh
MVP [MS Access]

>Thank you. Unfortunately, the subreports have groupings, so there seems to
>be a page break after each grouping if I follow your directions. The
[quoted text clipped - 18 lines]
>> properties and event. The Down then Across option will just
>> run on looking for a page boundary that ir will never see.

Reply to this Message