Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Page Header on sub report

3 views
Skip to first unread message

Robin Chapple

unread,
Sep 24, 2004, 5:52:46 PM9/24/04
to
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

Melissa

unread,
Sep 24, 2004, 7:51:50 PM9/24/04
to
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
reso...@pcdatasheet.com
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.


"Robin Chapple" <robi...@melbpc.org.au > wrote in message
news:rg59l0tc0q2fvteru...@4ax.com...

Robin Chapple

unread,
Sep 26, 2004, 8:09:53 PM9/26/04
to
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,


A Follow these steps:

Duane Hookom

unread,
Sep 26, 2004, 8:50:10 PM9/26/04
to
The expression in the Field/Expression should be
=True
or any other constant value. I use
=1


--
Duane Hookom
MS Access MVP


"Robin Chapple" <robi...@melbpc.org.au > wrote in message

news:e3mel01mnpggnca0v...@4ax.com...

0 new messages