Page Header on sub report

R

Robin Chapple

I have a report with a page header which is used as a sub report. In
preview the report by itself it appears to be normal.

When I add it to the main report the page header does not show on the
main report.

What have I missed/

Robin Chapple
 
M

Melissa

Hi Robin,

That's the natural way for Access!

Here's something from my files ---
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

Get The Titles In The Page Header Of A Subreport To Print Out


Q How do I get the titles in the Page Header of a subreport to display in
Print Preview and to print out?


A Follow these steps:

1.. Open the subreport in design view
2.. Click on the Sorting and Grouping icon in the toolbar at the top of
the screen
3.. Under Field/Expression type in = True and set Sort Order to
Ascending
4.. Under Group Properties, set Group Header to Yes
5.. Create the titles to be printed out in the = True Header
Set the Repeat Section property (Format tab) to Yes to repeat the titles on
each page.
 
R

Robin Chapple

Thanks Melissa,

That works but brings up a parameter query asking for avalue of "True"
but if left blank the report is OK.

Can I get around that?

Robin


=============
Hi Robin,

That's the natural way for Access!

Here's something from my files ---
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com

Get The Titles In The Page Header Of A Subreport To Print Out


Q How do I get the titles in the Page Header of a subreport to display
in
Print Preview and to print out?


A Follow these steps:

1.. Open the subreport in design view
2.. Click on the Sorting and Grouping icon in the toolbar at the
top of
the screen
3.. Under Field/Expression type in = True and set Sort Order to
Ascending
4.. Under Group Properties, set Group Header to Yes
5.. Create the titles to be printed out in the = True Header
Set the Repeat Section property (Format tab) to Yes to repeat the
titles on
each page.
 
D

Duane Hookom

The expression in the Field/Expression should be
=True
or any other constant value. I use
=1
 
Top