Is there a way to nest datasets so you do not need sub-reports?

I am trying to create a master detail/report using Data Regions rather than
Sub-reports. At the master level I was to display customer data. At the
detail level I want to display sales transactions for each customer (for
various reasons it is not convenient to extract all data in one SQL query)

I can set up the data regions easily enough, but cannot seem to define the
sales dataset to be nested into the customer dataset (i.e.: only extract data
for the current customer). It is not clear whether datasets support
hiararchy or dynamic execution (I know sub-reports do)

Is this doable without a sub-report. If so, how is this done?

Thanks in advance,
Alex

On Jun 5, 10:09 am, Alex wrote:
> I am trying to create a master detail/report using Data Regions rather than
> Sub-reports. At the master level I was to display customer data. At the
> detail level I want to display sales transactions for each customer (for
> various reasons it is not convenient to extract all data in one SQL query)
>
> I can set up the data regions easily enough, but cannot seem to define the
> sales dataset to be nested into the customer dataset (i.e.: only extract data
> for the current customer). It is not clear whether datasets support
> hiararchy or dynamic execution (I know sub-reports do)
>
> Is this doable without a sub-report. If so, how is this done?
>
> Thanks in advance,
> Alex

You might try embedding a table control inside another table control
and try to link the embedded dataset to the main dataset via a cell
value. Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant

Is there a way to nest datasets so you do not need sub-reports?

Is there a way to nest datasets so you do not need sub-reports?

Re: Is there a way to nest datasets so you do not need sub-reports?