Make group header span columns

[Chuck]

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
....

[Rick Brandt]

Re: Make group header span columns

"Chuck" <libbeyc@school link.net> wrote in message
news:6tlgj0p1d0 1ea446e79it9qe8 0mv5rt5si@4ax.c om...[color=blue]
> 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[/color]
left[color=blue]
> hand column. How can I make the group header be centered accross all[/color]
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

[Ross Presser]

Re: Make group header span columns

Chuck <libbeyc@school link.net> wrote in
news:0prhj0ll7n sa04jb0d43mkc23 51l07ge2r@4ax.c om:
[color=blue]
> On Fri, 3 Sep 2004 08:20:27 -0500, "Rick Brandt"
> <rickbrandt2@ho tmail.com> wrote:
>[color=green]
>>"Chuck" <libbeyc@school link.net> wrote in message
>>news:6tlgj0p1 d01ea446e79it9q e80mv5rt5si@4ax .com...[color=darkred]
>>> 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[/color]
>>left[color=darkred]
>>> hand column. How can I make the group header be centered accross
>>> all[/color]
>>columns?
>>[/color]
>[color=green]
>>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.
>>[/color]
>
> 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
> ...
>[/color]

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.

[Chuck]

Re: Make group header span columns

On 10 Sep 2004 20:22:10 GMT, Ross Presser <rpresser@NOSPA M.imtek.com.inv alid>
wrote:
[color=blue]
>Chuck <libbeyc@school link.net> wrote in
>news:0prhj0ll7 nsa04jb0d43mkc2 351l07ge2r@4ax. com:
>[color=green]
>> On Fri, 3 Sep 2004 08:20:27 -0500, "Rick Brandt"
>> <rickbrandt2@ho tmail.com> wrote:
>>[color=darkred]
>>>"Chuck" <libbeyc@school link.net> wrote in message
>>>news:6tlgj0p 1d01ea446e79it9 qe80mv5rt5si@4a x.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?
>>>[/color]
>>[color=darkred]
>>>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.
>>>[/color]
>>
>> 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
>> ...
>>[/color]
>
>Unfortunatel y, 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.[/color]

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
....

[Bernard Peek]

Re: Make group header span columns

In message <t216k0dlnj8tff jgefog66brhrg2i tpk09@4ax.com>, Chuck
<libbeyc@school link.net> writes

[color=blue][color=green]
>>
>>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.[/color]
>
>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.[/color]

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.

[Rebecca]

Re: Make group header span columns

Chuck wrote:[color=blue]
> 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
> ...[/color]


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.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q90/8/70.asp&NoWebContent=1

Rebecca

[Chuck]

Re: Make group header span columns

On Sun, 12 Sep 2004 04:43:12 GMT, Rebecca <Rebecca@JaxonF amily.net> wrote:
[color=blue]
>Chuck wrote:[color=green]
>> 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
>> ...[/color]
>
>
>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
>[/color]
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
....