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
|
|||
|
|||
Report detail col heading problems
I have Access 2000 on Win XP.
I have a report which is based on a query. The query contains multiple customers and each customer has many product details. I want the report to print a header page for each customer. This header page contains a logo (same image for everyone), the customer name and address, then a column header for product details. The details could span multiple pages. My report currently has these grouped fields: - [Page header] contains nothing - [cus_no header] contains logo and customer name and address and first column headers. - [item_desc header] contains nothing - [detail] contains nothing - [item_desc footer] prints one line of details for each item (I have to sum a qty field at this point) My problem is the detail column headers appear once on the first page, but not on subsequent pages. I cannot put the col headers in the [Page header] area because they would appear right above the logo and customer name and address, which is incorrect. What I want is to skip printing the col hdrs when the cus_no first changes. Anyone understand how to do this? Report should end up like this: [logo] Customer name Cust. address Col header1 Col hdr 2 ... Product1 Product2 Product3 .... [new page same customer] Col header1 Col hdr 2 ... Productn Productn+1 .... Thank you. |
#2
|
|||
|
|||
Report detail col heading problems
I would try create a second cus_no header section under the first one. Move
the column headings to this new header section. Set this section's Repeat Section property to Yes. -- Duane Hookom Microsoft Access MVP If I have helped you, please help me by donating to UCP http://www.access.hookom.net/UCP/Default.htm "A Man" wrote: I have Access 2000 on Win XP. I have a report which is based on a query. The query contains multiple customers and each customer has many product details. I want the report to print a header page for each customer. This header page contains a logo (same image for everyone), the customer name and address, then a column header for product details. The details could span multiple pages. My report currently has these grouped fields: - [Page header] contains nothing - [cus_no header] contains logo and customer name and address and first column headers. - [item_desc header] contains nothing - [detail] contains nothing - [item_desc footer] prints one line of details for each item (I have to sum a qty field at this point) My problem is the detail column headers appear once on the first page, but not on subsequent pages. I cannot put the col headers in the [Page header] area because they would appear right above the logo and customer name and address, which is incorrect. What I want is to skip printing the col hdrs when the cus_no first changes. Anyone understand how to do this? Report should end up like this: [logo] Customer name Cust. address Col header1 Col hdr 2 ... Product1 Product2 Product3 .... [new page same customer] Col header1 Col hdr 2 ... Productn Productn+1 .... Thank you. |
#3
|
|||
|
|||
Report detail col heading problems
I should add that the 2 tables the query for the report is based on a
- Customer data (for customer name and address) - Order data (for product details) Thank you. |
Thread Tools | |
Display Modes | |
|
|