Create report group headers based on criteria

E

ernpal

I have a report that prints out a statement based on weekly invoices
for 24 customers. However, the 24 customers are not all the same
company. Here's what I want to do:
1) group by company with grand total then
2) group by customer with subtotals

The customer table does not have a "company" field, but the customer
number indicates the company. If the customer number is 1-199, it's
one company; if it is >= 200, it's the other.

Any ideas?

Thanks,
E
 
E

ernpal

Thanks... I though of that after I posted the question, as I re-read
the last sentence. I guess what they say is true... "A problem well
defined is a problem half solved."

And by the way... the suggested solution, worked.
 
E

ernpal

I got the report separating into the two company groups, but I noticed
another problem. Firstly, to try and make things a little clear,
here's the report's structure:

---------------------------------------------------------------------
Page Header:
<blank>
---------------------------------------------------------------------
Company Header:
[CompanyName] [=Sum([SubTotal])]
---------------------------------------------------------------------
CustomerID Header:
[CustomerName]
---------------------------------------------------------------------
Details:
[InvoiceDate] [InvoiceID] [SubTotal]
---------------------------------------------------------------------
CustomerID Footer:
Customer Total: [=Sum([SubTotal])]
---------------------------------------------------------------------
Page Footer:
[="Page " & [Page] & "of " & [Pages]]
---------------------------------------------------------------------

Here's the problem: I want the section grouped on CustomerID to span
two columns, but I do not want the "parent" group's header (Company
Header) to get divided into columns. I want to the Company group
header(s) to cover the width of the page.
 
Top