Can I have two page headers?

[jonnysnow]

I want to print a "main" page header on every page of my report. I also want to print a subreport header below the "main" header on each new page.

I've seen a number of posts that refer to the "Repeat Section" property. It looks like I can set this property and I'll get the repeated headers I'm looking for.

BUT... I'm using Access 2.0 (honest truth, don't make fun of me). Does this property not exist in 2.0? I haven't been able to find it. Is there any way to get the same results?

Some things I've tried: [ul][li]making the subreport heading I want a report header[/li][li]making the subreport heading I want a page header[/li]
[li]creating a dummy group (=1) with the header I want[/li]
[li]all combinations of the above[/li]
[/ul]Any ideas??



------- Example below: -------------------

The "main" header is in [red]red[/red] and should appear on every page. The subreport header is in [blue]blue[/blue] and should appear below the "main" header on every new page:

Page 1:

[red]Patient: 1234
Clinic:  Columbus Hospital
Enroll date: 03/14/2001
[/red][blue]
EVENTS
Date        Source    Description[/blue]
04/03/01    CM        MI/CABG/PTCA
                      Lewis Institute

05/02/01    DCI       441.4 - Aneurysm repair

Page 2:

[red]Patient: 1234
Clinic:  Columbus Hospital
Enroll date: 03/14/2001
[/red][blue]
EVENTS
Date        Source    Description[/blue]
09/16/01    HS        CEA/CVA

09/16/01    DCI       38.11 - Endarterectomy

 

[GingerR]

Why not just put the blue stuff in the Page header with the red stuff?

Also, I'm not making fun of you, but Access 2.0 is not Y2K compliant. There is no other fix than to upgrade to at least Access 97 SR-2.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jonnysnow]

I can't just put the blue stuff in the main page header because there are three or four subreports that print in sequence. I want the header of whichever subreport is CURRENT to print on the new page.

(Point well-noted about Y2K...)

 

[GingerR]

Oh. Your example shows the exact same text in the headings for both pages.

So is what you are saying is that a subreport is very long, taking many pages, and on the pages after the first for each subreport there are no headings?

Subreport headings won't repeat on the main report. I think it doesn't know when the subreport is being broken up onto multiple main report pages. If you run a subreport on it's own (like it's a report, not a subreport) the headings will be ok. but not when it's a subreport. I've run into this issue before, and end up with just not having and headings on the subsequent pages.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jonnysnow]

Yes. That's exactly the problem. Each subreport can take multiple pages, and after the first page, the header doesn't print.

Is there really no way around this in Access? It doesn't seem like an unusual thing to want to do...

 

[jonnysnow]

Yes, that's exactly right. Each subreport can span several pages, and the subreport header doesn't show up on any later pages.

Is there really no way around this in Access? It seems like a pretty common thing to want to do...

 

[GingerR]

i've never been able to get it to work. I just weeded thru some other posts asking the same thing and there's no answer. I think it just runs the subreport, and when it's working with the subreport, it doesn't 'understand' or acknowledge in any way anything about the main report.

a workaround, only if each subreport always takes up the same amount of room, is to set an unbound text box or label at the top of each page in it's own header to whatever you want it to be, in the OnFormat property of the header.



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jonnysnow]

Thanks very much for your help!! I'll think about ways I could maybe restructure my report to force things.

 

[GingerR]

That's the ticket!! If you figure out something inventive, post it back here to help out the rest of us!

g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244