Columns in the detail section of a report but not the group header
Douglas Buchanan
1.) Report header full width
2.) Group header full width
3.) Detail section in two columns.
My Report has the following settings
In the Page setup, In the Columns page
Grid settings...
Number of columns = 2
Row spacing = 0
Column spacing =0
Column size...
Width = 3.75
Height = 1.125
Column Layout...
Across, then down
Selected general Report Properties
Width = 7.5
GrpKeepTogether = PerColumn
Selected Report Header Properties
NewRowOrColumn = None
Selected Group Header Properties
NewRowOrColumn = None
Selected Group Detail Properties
NewRowOrColumn = None
My layout of the report
In the Report Header is a title that spans the full width
of the page,
In the Group Header section is label controls and bound
text box controls that span the full width of the page
In the Detail section is a number of labels and two subreports.
All are crowded to the left hand side of the detail section to
allow for "columning".
My result are as follows:
1.) A full page width Report Header
2.) A left column with only the left half of the Group Header.
(The right half is covered over by the detail section.)
3.) A right column showing the detail information.
(The top of this column is the same as the top of the
group header and in fact overlaps the group header. This
is the reason that only the left portion of the group header
is seen)
Why do I get these results? (MS certainly makes getting
desired results confusing.)
Thank you,
Doug
Rick Brandt
applied to all levels below "Page". You can have Report header/footers
and/or Page header/footers that are full width while all levels below that
will follow the multi-column settings in Page Setup.
The easy work-around is to make a main report that is full width and then
insert a sub-report that uses multiple columns into the appropriate section
of the report.
Douglas Buchanan wrote in message ...
fredg
If your report width is 7.5", In the Detail section just have 1 column
of controls (at the left side of the report). Make them narrower than
3.5". If you are including 2 subreports, then set the width of each
subreport to the same <3.5" as the controls and place them beneath
the controls, one under the other at the left.
The Page, Group, and Report headers can be as wide as the report.
Then go to Main Report's File + Page Setup + Margins. Make sure (if
you're using an
8 1/2" wide sheet of paper) that the combined margins are less than
1".
Next go to Columns. Set the Columns to 2. Set the Column space to
whatever (>0 but < 0.5") is needed. (You'll have two 3.5" columns + 1"
combined margins + .5" between columns = 8 1/2")
Uncheck the Same as Detail box. and enter 3.5 in the Column Size width
box.
Make sure each subreport's Page Setup is for just 1 column, however.
Save and run the report. All headers will span the full width of the
page but you'll have 2 columns in the Detail Section
I just made a label report with a subreport using the above method and
it printed full page and Group headers and footers with 2 columns of
data and the subreport also printed in each column.
If you are still having difficulty, Microsoft has an example (without
using the subreport) in their
Sample Reports download available from their Download Center.
Fred
Douglas Buchanan <dark...@tir.com> wrote in message
news:qp9f5.41828$DH3.1...@news-east.usenetserver.com...
Becky Jaxon
section to be columns THEN drag the headers and footers out to the full
width of the report. If I set the headers and footers first, they got
shrunk when I went to create the columns. When you drag out the headers
and footers, it will appear as though you are also dragging out the
detail section but it will remain in columns while your other sections
become the width of the page.
Becky Jaxon
Douglas Buchanan
What do youb mean "THEN drag the headers and footers out to the
full width"? Are you suggesting that Access, in design view, knows
what you do first and second?
Are you saying that since I may have done one thing before another
in not quite the right sequence that I must start over????
Doug
Becky Jaxon <ja...@soltec.net> wrote in message
news:397E690E...@soltec.net...
Douglas Buchanan
> If you are still having difficulty, Microsoft has an example (without
> using the subreport) in their
> Sample Reports download available from their Download Center.
I looked again at the sample within the file "RptSmp97.mdb" as I have
several times before for other circumstances.
It does not match my needs in many ways;
1.) The instructions are for Access 2.0
2.) It does not use subreports.
3.) It does not have group headers span the full page.
I carefully followed your instruction =without= success.
The group header will not span the full page!
One area of confusion for me was an area that you made no comment on...
(It may not have a bearing on the problem but it looked like it
might have a lot to do with it so with no other ideas I pursued it.
You did not tell me how to set the NewRowOrCol properties
for the group header or the detail header. So I tediously tried
all the combinations. I got various different results. Below some
of them are illustrated.
The =NewRowOrCol= properties
1.) None
2.) Before Section
3.) After Section
4.) Before & After
"Sketches" below represent various results of the combinations
above.
Legend to show how to read the "sketches"
= page header
+ group header
-- detail
... page break
Fig.1 - Grp=None Det=None
===========
+++++
-------
-------
-------
+++++
-------
-------
-------
.........................
Fig.2 - Grp=Before Det=None
===========
+++++ +++++
------- -------
------- -------
------- -------
........................
Fig.3 - Grp=After Det=None
===========
+++++ -------
-------
-------
........................
+++++ -------
-------
-------
Fig.4 - Grp=Before Det=After
===========
+++++
-------
-------
-------
.......................
+++++
-------
-------
-------
My Columns and margins and spacing:
column width = 3.7076 (two columns)
3.7076 x 2 = 7.4152
column space = 0.08
7.4152 + 0.08 = 7.4952
left and right margins 0.5 and 0.466
7.4952 + 0.5 + 0.466 = 8.4612
paper width = 8.5
see between snippets
> If your report width is 7.5", In the Detail section just have 1 column
> of controls (at the left side of the report).
Done.
>Make them narrower than 3.5". If you are including 2 subreports, then set
the width of each
> subreport to the same <3.5" as the controls
Done. (narrower than 3.7076)
> and place them beneath the controls, one under the other at the left.
Done.
> The Page, Group, and Report headers can be as wide as the report.
Done.
> Then go to Main Report's File + Page Setup + Margins. Make sure (if
> you're using an
> 8 1/2" wide sheet of paper) that the combined margins are less than
> 1".
Done. (0.5 and 0.466)
> Next go to Columns. Set the Columns to 2. Set the Column space to
> whatever (>0 but < 0.5") is needed. (You'll have two 3.5" columns + 1"
> combined margins + .5" between columns = 8 1/2")
Done. (column spacing 0.08)
3.7076 x 2 = 7.4152
7.4152 + 0.08 = 7.4952
7.4952 + 0.5 + 0.466 =
8.4612
8.4612 < 8.5
> Uncheck the Same as Detail box. and enter 3.5 in the Column Size width
> box.
Done.
> Make sure each subreport's Page Setup is for just 1 column, however.
Done.
> Save and run the report. All headers will span the full width of the
> page but you'll have 2 columns in the Detail Section
It doesn't.
You will note above that in =every= example the the group header is
cut short. I believe that several of these options would suit my needs
if the group header would span the page.
How do I get the group header to span the page???
Thank you,
Doug
Rick Brandt
97). This is the first two paragraphs when looking at the "How to Make a
Multiple Column Report" Help topic.
*****************************
When a multiple-column report is printed, the REPORT header and footer and
PAGE header and footer span the full width of the report, so you can place
controls anywhere in these sections in Design view.
When printed, the GROUP header and footer and DETAIL section of a
multiple-column report span the width of one column. For example, if you
want to print the data in two three-inch columns, place the controls within
the width of one column; in other words, place the controls in the first
three inches of these sections in Design view.
******************************
In other words you cannot do what you want without using a sub-report.
Douglas Buchanan wrote in message
<62vf5.51978$DH3.1...@news-east.usenetserver.com>...
Becky Jaxon
and report headers, not to group headers. I'm sorry, I just went and
tried it out on group headers and it won't work. Sorry.
Becky Jaxon
Douglas Buchanan
See below
Rick Brandt <RBr...@Hunter.Com> wrote in message
news:OaolNTw9$GA.269@cpmsnbbsa08...
> I answered from memory before and now I have checked the Help file (Access
> 97). This is the first two paragraphs when looking at the "How to Make a
> Multiple Column Report" Help topic.
>
> *****************************
> When a multiple-column report is printed, the REPORT header and footer and
> PAGE header and footer span the full width of the report, so you can place
> controls anywhere in these sections in Design view.
>
> When printed, the GROUP header and footer and DETAIL section of a
> multiple-column report span the width of one column. For example, if you
> want to print the data in two three-inch columns, place the controls
within
> the width of one column; in other words, place the controls in the first
> three inches of these sections in Design view.
>
> ******************************
>
> In other words you cannot do what you want without using a sub-report.
I am using a sub-report and it is not working...
...unless what you mean to say is that the subreport does the
column thing
and it is just displayed in the main form with no "columning".
I'll give this a try right now.
Thanks,
Doug
Douglas Buchanan
> I am using a sub-report and it is not working...
> ...unless what you mean to say is that the subreport does
the
> column thing
> and it is just displayed in the main form with no "columning".
>
> I'll give this a try right now.
I got it to work. I have full width Report, Page and Group headers
with only the detail section in columns.
I set up the sub reports to display with two columns independantly of the
main report. I set up the main report to print just one column.
The detail section has the text boxes for my column headers (titles for the
columns) then below that are the subreport controls spanning the entrire
width.
At first the group header was cut to the width of the column, blank on the
right side even though there were no settings in the main report requesting
columns. I made several attempts to remedy this. Finally I created a
new report, brounght all controls in from the old one, set up the source
objects, grouping and page setup and it works. I don't have a clue to
why the old one didn't work.
Thank all of you for your assistance,
Doug