If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
page header on second page of invoice.
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 |
#2
|
|||
|
|||
page header on second page of invoice.
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. -- Duane Hookom MS Access MVP "Dennis" wrote in message ... 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 |
#3
|
|||
|
|||
page header on second page of invoice.
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 |
#4
|
|||
|
|||
page header on second page of invoice.
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 |
Thread Tools | |
Display Modes | |
|
|