SubReports Vs Tables

[Mike]

I have a report that binds to a data source of invoices using the following query:
SELECT * FROM Invoices

Within the detail section of the report I wish to add several tables. The first displays a list of all the invoice items:
SELECT * FROM InvoiceItems WHERE InvoiceId=@InvoiceId

The second displays a list of the invoice transactions:
SELECT * FROM Transactions WHERE InvoiceId=@InvoiceId

I then set the report parameter @InvoiceId to "=fields.InvoiceId" hoping that when the detail section is generated, the tables datasource would take the current invoice id and refresh its datasource. This isn't happening.
I know I could use sub reports to achieve the desired effect but wanted to keep everything within the one report if I can. Can I do this?

Thanks in advance

Mike

[Steve]

Hello Mike,

I have attached our Invoice demo report modified so that it uses Table item instead of SubReport. Please review it and let us know if you need further help.

Regards,
Steve
the Telerik team