Columns in subreport in main report footer

[Kathy Webster]

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

 

[Marshall Barton]

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.

 

[Kathy Webster]

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

 

[Marshall Barton]

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.