Subreports

rbuser

I have 3 tables, all related.

Table 1 contains customer information.
Table 2 contains Sales Options information. (one customer with one to many
sales options)
Table 3 contacts Details for each sales option (each option can contain one
to many details).

I can get the Customer and Sales options fine.
As soon as I add another subreport to hold the Details, I only get one
option, even though there are 3 options for this customer.

The Datasources are linked as:
Each Option has a CustomerID which is linked to the CustomerID for the
Customer.
Each Detail has an OptionID which is linked to the OptionID for the
Option.

As soon as I link the subreport for the details, I only get one option.
When I remove the subreport for the details, I get all 3 options.

Anyone have an idea as to what I am missing???

Thanks in advance.

nicocizik

Hi Dan,

Take a look at the Master-Detail-Detail demos (dm0071.pas - dm0073.pas)
located in the \RBuilder\Demos\1. Reports\... directory for examples on how
to set up a report like the one you describe below.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com