By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,347 Members | 2,091 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,347 IT Pros & Developers. It's quick & easy.

Make group header span columns

P: n/a
I have a report with three columns, accross then down, and two groups.
Currently the group headers are only one column wide and appear in the left
hand column. How can I make the group header be centered accross all columns?

Chuck
....
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
"Chuck" <li*****@schoollink.net> wrote in message
news:6t********************************@4ax.com...
I have a report with three columns, accross then down, and two groups.
Currently the group headers are only one column wide and appear in the left hand column. How can I make the group header be centered accross all

columns?

By default the width of your columns is made the same as the width of the
report sections in design view. You can however go into page setup,
uncheck this default, and then explicitly enter the width and spacing of
your columns. That will allow you to make the section width in design view
wide enough to enter two more sets of column header labels. It will take
some trial and error to get them lined up over your columns.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
Chuck <li*****@schoollink.net> wrote in
news:0p********************************@4ax.com:
On Fri, 3 Sep 2004 08:20:27 -0500, "Rick Brandt"
<ri*********@hotmail.com> wrote:
"Chuck" <li*****@schoollink.net> wrote in message
news:6t********************************@4ax.com. ..
I have a report with three columns, accross then down, and two
groups. Currently the group headers are only one column wide and
appear in the

left
hand column. How can I make the group header be centered accross
all

columns?

By default the width of your columns is made the same as the width of
the report sections in design view. You can however go into page
setup, uncheck this default, and then explicitly enter the width and
spacing of your columns. That will allow you to make the section
width in design view wide enough to enter two more sets of column
header labels. It will take some trial and error to get them lined up
over your columns.


If it makes any difference, the database is Access 97.
I don't understand. In the report design everything is 7.5" wide.
The text boxes in the Report Header, and Page Header span the full
width of the page. The text boxes in the detail section are 2.5" wide,
which leaves a lot of empty space to the right of the text boxes. The
three columns are set in Page Setup. The column width is set to 2.5"
and *Same as Detail* is not checked. Column layout is set to accross
then down. Properties of the Group Header are New Row or Col: Before
& After. A text box in the Group Header, which is between the Page
Header and the Detail section, is set to 7" wide but the text is cut
off at the right edge of the first column. I really don't want to
start a new page for each group, but if that is what it'll take, I'll
do it.

Chuck
...


Unfortunately, in my experience, group headers will be the width of
detail columns, no other option.

I have achieved the effect you seem to want (multiple column detail,
single column group) by putting the detail into a subreport instead.
Nov 13 '05 #3

P: n/a
On 10 Sep 2004 20:22:10 GMT, Ross Presser <rp******@NOSPAM.imtek.com.invalid>
wrote:
Chuck <li*****@schoollink.net> wrote in
news:0p********************************@4ax.com :
On Fri, 3 Sep 2004 08:20:27 -0500, "Rick Brandt"
<ri*********@hotmail.com> wrote:
"Chuck" <li*****@schoollink.net> wrote in message
news:6t********************************@4ax.com ...
I have a report with three columns, accross then down, and two
groups. Currently the group headers are only one column wide and
appear in the
left
hand column. How can I make the group header be centered accross
all
columns?

By default the width of your columns is made the same as the width of
the report sections in design view. You can however go into page
setup, uncheck this default, and then explicitly enter the width and
spacing of your columns. That will allow you to make the section
width in design view wide enough to enter two more sets of column
header labels. It will take some trial and error to get them lined up
over your columns.


If it makes any difference, the database is Access 97.
I don't understand. In the report design everything is 7.5" wide.
The text boxes in the Report Header, and Page Header span the full
width of the page. The text boxes in the detail section are 2.5" wide,
which leaves a lot of empty space to the right of the text boxes. The
three columns are set in Page Setup. The column width is set to 2.5"
and *Same as Detail* is not checked. Column layout is set to accross
then down. Properties of the Group Header are New Row or Col: Before
& After. A text box in the Group Header, which is between the Page
Header and the Detail section, is set to 7" wide but the text is cut
off at the right edge of the first column. I really don't want to
start a new page for each group, but if that is what it'll take, I'll
do it.

Chuck
...


Unfortunately, in my experience, group headers will be the width of
detail columns, no other option.

I have achieved the effect you seem to want (multiple column detail,
single column group) by putting the detail into a subreport instead.


I've come to the same conclusion, and the more I think about it, the more sence
it makes. Details in subreport, beautiful. Thank you very much.

Chuck
....

Nov 13 '05 #4

P: n/a
In message <t2********************************@4ax.com>, Chuck
<li*****@schoollink.net> writes


Unfortunately, in my experience, group headers will be the width of
detail columns, no other option.

I have achieved the effect you seem to want (multiple column detail,
single column group) by putting the detail into a subreport instead.


I've come to the same conclusion, and the more I think about it, the more sence
it makes. Details in subreport, beautiful. Thank you very much.


It's a neat workaround for a glaring mistake in the design of Access. It
shouldn't really be necessary.

--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.

Nov 13 '05 #5

P: n/a
Chuck wrote:
I have a report with three columns, accross then down, and two groups.
Currently the group headers are only one column wide and appear in the left
hand column. How can I make the group header be centered accross all columns?

Chuck
...

I knew this looked familiar. It really is possible. I asked this
question a few years ago and was pointed to the following article:

http://support.microsoft.com/default...NoWebContent=1
Rebecca

Nov 13 '05 #6

P: n/a
On Sun, 12 Sep 2004 04:43:12 GMT, Rebecca <Re*****@JaxonFamily.net> wrote:
Chuck wrote:
I have a report with three columns, accross then down, and two groups.
Currently the group headers are only one column wide and appear in the left
hand column. How can I make the group header be centered accross all columns?

Chuck
...

I knew this looked familiar. It really is possible. I asked this
question a few years ago and was pointed to the following article:

http://support.microsoft.com/default...NoWebContent=1
Rebecca

Thanks for the suggestion. It doesn't really address my particular problem.
However, the site also has a database with many examples of reports. The
example for printing odd or even page numbers is a cleaner solution than what
I've been using.

Chuck
....
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.