Report detail col heading problems

  • Thread starter Thread starter A Man
  • Start date Start date
A

A Man

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.
 
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.
 
I should add that the 2 tables the query for the report is based on are:
- Customer data (for customer name and address)
- Order data (for product details)

Thank you.
 
Back
Top