How make group go across the page instead of down?

[mscertified]

I have a grouping in my report that causes the report to page. The users said
can I get two columns on each line to reduce the chance that it will page.
How easy would this be to do? e.g.
Now it prints:
A
B
C
D
E
I need it to print:
A B
C D
E
Each A B C D E is in a separate row in my data source.

 

[Marshall Barton]

I have a grouping in my report that causes the report to page. The users said
can I get two columns on each line to reduce the chance that it will page.
How easy would this be to do? e.g.
Now it prints:
A
B
C
D
E
I need it to print:
A B
C D
E
Each A B C D E is in a separate row in my data source.

Use the File - Page Setup menu item to set the number of
columns to 2. If you are using the Report Header/Foother
and/or Page Header/Footer sections, be sure to uncheck the
Same as Detail check box and manuall set the column width.

Note that you will probably want to set the group header
section's Force New page property to Before Section and that
the group header section can only be one column wide.

 

[krissco]

I have a grouping in my report that causes the report to page. The users said
can I get two columns on each line to reduce the chance that it will page.
How easy would this be to do? e.g.
Now it prints:
A
B
C
D
E
I need it to print:
A B
C D
E
Each A B C D E is in a separate row in my data source.

When designing the report, click File/Page Setup. The last tab has
column information. Specify 2 columns and set the desired width/
spacing.

-Kris

 

[mscertified]

Thanks for your response.
I tried what you suggested however I keep getting a message 'not enough
horizontal room' - even though there is plenty of room for 2 columns.
The Page setup dialog is very confusing because it says 'column width 7.66"'
even though I specified 2 columns. 7.66" is the total width of my report. If
I reduce this to 3.8", only half my report prints, the other half is
completely blank.
What am I doing wrong?

 

[mscertified]

Thanks for your response.
I tried what you suggested however I keep getting a message 'not enough
horizontal room' - even though there is plenty of room for 2 columns.
The Page setup dialog is very confusing because it says 'column width 7.66"'
even though I specified 2 columns. 7.66" is the total width of my report. If
I reduce this to 3.8", only half my report prints (ALL of the report), the
other half is
completely blank.
I only need the DETAIL section to be 2 columns not the rest of the report
(there are headers and footers).

 

[Rick Brandt]

Thanks for your response.
I tried what you suggested however I keep getting a message 'not
enough horizontal room' - even though there is plenty of room for 2
columns.
The Page setup dialog is very confusing because it says 'column width
7.66"' even though I specified 2 columns. 7.66" is the total width of
my report. If I reduce this to 3.8", only half my report prints (ALL
of the report), the other half is
completely blank.
I only need the DETAIL section to be 2 columns not the rest of the
report (there are headers and footers).

The only sections that WON'T be in columns when you set up multiple columns
is the Page Header/Footer and Report Header/Footer. All other sections will
be displayed as columns. If that won't work for you then you might need to
use a subreport that has multiple columns inside a parent report that does
not.

 

[Marshall Barton]

Half blank? Hmmm, did you forget to take the column spacing
into account when specifying the column width?

Or, maybe you do not have any groups that use the second
column??

Be sure to read Rick's comment about using a subreport if
you want the group header to use the full page width. If
you go this route, be sure to modify the main report's
record source so it only has one record for each group.