group header and columns report question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brian - 04 Jan 2006 20:57 GMT

I need the gourp headings in my report to go accros the hole page where the
other record are show in columns. The group headder wants to cut off at the
end of the first column. Can some one pleae help? Thanks

Here is an Examnple:

Group Heading

Data Data Data
Data Data Data

Reply to this Message

Marshall Barton - 04 Jan 2006 23:27 GMT

>I need the gourp headings in my report to go accros the hole page where the
>other record are show in columns. The group headder wants to cut off at the
[quoted text clipped - 6 lines]
>Data Data Data
>Data Data Data

Either put the heading information in the Page Header
section or use a subreport for the data.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Brian - 05 Jan 2006 16:45 GMT

Ok, how do I create the subreport. I have a query that gives me the group
headdings and the data but i can't get it to link together.

> >I need the gourp headings in my report to go accros the hole page where the
> >other record are show in columns. The group headder wants to cut off at the
[quoted text clipped - 9 lines]
> Either put the heading information in the Page Header
> section or use a subreport for the data.

Reply to this Message

Marshall Barton - 05 Jan 2006 21:40 GMT

Wirhout seeing you table structure, it's hard to say, but
the general idea is for the main report's record source
query to only include the group data and the subreport's
record source query to include only the detail data. Both
queries must include the field(s) that connect the details
to their group. The linking field(s) are are then specified
in the subreport **control's** Link Master/Child Fields
properties.

Signature

Marsh
MVP [MS Access]

>Ok, how do I create the subreport. I have a query that gives me the group
>headdings and the data but i can't get it to link together.
[quoted text clipped - 12 lines]
>> Either put the heading information in the Page Header
>> section or use a subreport for the data.

Reply to this Message