Subreport with headings

H

Hans

Hi,

I creating a series of delivery notes, order confirmation, sales orders for
a client.

I have setup each as report with subreport, within the subreport I have
setup to show column headings

when previewing, page 1 of 2 show correctly with the heading from the
subreport, but on page 2 of 2 the headings from the subreport disappear.

How can I setup up the subreport so that when it forces the main report to
produce a second page, the heading in the subreport remain intacted.
 
M

Marshall Barton

Hans said:
I creating a series of delivery notes, order confirmation, sales orders for
a client.

I have setup each as report with subreport, within the subreport I have
setup to show column headings

when previewing, page 1 of 2 show correctly with the heading from the
subreport, but on page 2 of 2 the headings from the subreport disappear.

How can I setup up the subreport so that when it forces the main report to
produce a second page, the heading in the subreport remain intacted.


Instead of putting the heading in the (sub)report's Report
Header section, create a new top level group header based on
a constant expression (e.g. =1 or ="My page header"). Then
put the heading labels, etc. in this group header and set
the section's RepeatSection property to Yes.
 
H

Hans

Hi Marshall,

The subreport has a group heading - labelled MenuGroup.

Withing this group you have qty delivered, Item to deliver and the last 2
column are tick boxes. first tick box is labelled Driver check, and the
second one customer check.

the problem i am seeing is that when this subreport forces a next page on
the main report, these labels for the group, and the 2 tick boxes don't show.

Also how do you get a group heading to display when items within the group
continue onto the next page.

Regards

Hans
 
M

Marshall Barton

If your existing group header has what you want on it, then
just set its RepeatSection property to Yes.

If that's not what you want, then try to explain what you do
want with more specific details.
 
H

Hans

Hi Marshall,

it worked, got the result I was after.

Thanks for the help.

Hans

Marshall Barton said:
If your existing group header has what you want on it, then
just set its RepeatSection property to Yes.

If that's not what you want, then try to explain what you do
want with more specific details.
--
Marsh
MVP [MS Access]
The subreport has a group heading - labelled MenuGroup.

Withing this group you have qty delivered, Item to deliver and the last 2
column are tick boxes. first tick box is labelled Driver check, and the
second one customer check.

the problem i am seeing is that when this subreport forces a next page on
the main report, these labels for the group, and the 2 tick boxes don't show.

Also how do you get a group heading to display when items within the group
continue onto the next page.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top