Printing heading in subreports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subreport in which the contents often carry over onto the next page
of the master report. I want the column headings to carry over, too..but I
can't seem to figure out how to accomplish this. If I put the column headings
in the subreport's Report Header, they print as expected at the beginning of
the subreport, but they don't print at the beginning of the data that is on
the next page. If I put them in the subreport's Page Header, they don't
print at all. I hope I'm making myself clear about this. Thanks in advance!
 
Not sure if this will work...
Add a new primary sorting and grouping level and set its Field/Expression to
a constant such as
=1
Then set it to display a group header section. Set the Repeat Section
property of the =1 Group Header to Yes.

--
Duane Hookom
MS Access MVP


Susan said:
I have a subreport in which the contents often carry over onto the next page
of the master report. I want the column headings to carry over, too..but I
can't seem to figure out how to accomplish this. If I put the column headings
in the subreport's Report Header, they print as expected at the beginning of
the subreport, but they don't print at the beginning of the data that is on
the next page. If I put them in the subreport's Page Header, they don't
print at all. I hope I'm making myself clear about this. Thanks in
Click to expand...
advance!
 
Yes, that will work. I did exactly the same thing after Marsh suggested it
in this very forum some months ago. I think that the detail section (if that
is where the subreport is located) will need its Force New Page format set to
After Section for this to work. When I made my report I grouped the main
report and put the main report information into the group header, and the
subreport information into the detail section. I don't remember why I did it
that way, but it seems to work.
 
Thank you, thank you, thank you both! I've been going 'round and 'round on
this. I know you had to set the Repeat Section of the group header, but I
didn't need a group header, so I was stuck! Putting in a "bogus" group
header did the trick. You are awesome!
 
Back
Top