page header on second page of invoice.

[Dennis]

Hi,

I am working on an invoice form in Access via Office XP Pro on Win7.


Database:

tblInvoice - 1 record per invoice
key - InvNo - Access autonumber field
Data CustNo
InvData

tblInvDet - 1 record per invoice transaction
key - InvSeqNo - Access autonumber field
Data - InvNo
TransactionType


Background:

The Invoice report has a:
Group Header (Invoice Header) - Row source is tblInvoice
Detail (sub-report) sections

The main report does NOT have a:
Report Header
Page Header
Group Footer (Invoice Footer)
Page Footer
Report Footer section

The sub-report has a:
Page Header (this does not print at all for some reason)
Detail Section - row source is tblInvoiceDet (linked by InvNo field)
Report Footer sections


It does not have a:
Report Header
Page Footer sections

Everything works fine until I go to a two page invoice.

Here are my questions:
1. Why does the Detail Page Header not print? Is that because when the
first invoice detail is printed, I'm in the middle of the page? Is so, why
does it not print on the top of the second page.

2. How do I get something to print on the top of the second page of the
invoice? I don't want the complete top of invoice information to print, but
maybe "Continuation of invoice # xxx for Customer xxxx" would be nice.


Thanks,

Dennis

 

[Duane Hookom]

There are no page sections in subreports. You can create an InvNo group
header in the subreport and use it in place of a subreport page header
section. Set its Repeat Section property to Yes if you want this to display
at the top of each subreport instance.

 

[Dennis]

Duane,

I'm not sure what you mean by "There are no page sections in a sub-report".
I'm looking at the rptInvoice layout. In the sub-report, there is a section
called Page Header and Page Footer. I can not get anything to print in the
page header section, but I can get totals to appear in the page footer
section.


Your comment: You can create an InvNo group header in the subreport and use
it in place of a subreport page header section. Set its Repeat Section
property to Yes if you want this to display at the top of each subreport
instance.

My Response: I'll give it a try and post the results.

Dennis

 

[Dennis]

Duane

Your comment: There are no page sections in subreports.

My Response: Ah, you are correct. They appear on the report layout screen,
but they do not print. I can see that now.


Your comment: You can create an InvNo group header in the subreport and use
it in place of a subreport page header section. Set its Repeat Section
property to Yes if you want this to display at the top of each subreport
instance.


My Response: I had to play with it to get it just right, but it worked
great. Thank you so much.


Dennis