Hi All, I'm tasked with working on a Crystal report for the first time. I've gotten pretty far but am stumped now.

I have a report with a query that returns a bunch of rows, basically it is a report that shows a contract, stores and products.

One contract contains stores and products so I would like the report to show this:

Customers:(header)
Cust1
Cust2
Cust3

Products:(header)
Product1
Product2
Product3

Right now the report is setup in such a way where I can only get the following result:

Customers:(header)
Cust1

Products:(header)
Product1
Product2
Product3

Customers:(header)
Cust2


Products:(header)
Product1
Product2
Product3

Customers:(header)
Cust3

Products:(header)
Product1
Product2
Product3

The products have a "detail" section within the header but I can't seem to include another detail section within the Customers header.

Sorry for the lack of correct terminology/knowledge. As you can, I'm very new at this.

Correct, the SQL is pulling the data that I need.

I want to do what you describe, the products are not tied to customers, instead they are tied to a contract.

The beginning of the report should show contract info, then customers tied to that contract and finally products tied to that contract.

Thanks Sharona, your suggested has made the report show the two headers, then the details.

This approach can be OK, if I get the details to show under each header, might be able to get away with sticking the headers in the actual details... if that made sense hehe