This is a migrated thread and some comments may be shown as answers.

SubReports Vs Tables

1 Answer 146 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Mike
Top achievements
Rank 1
Mike asked on 31 May 2012, 09:48 AM
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


1 Answer, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 02 Jun 2012, 02:17 PM
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

BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >

Tags
General Discussions
Asked by
Mike
Top achievements
Rank 1
Answers by
Steve
Telerik team
Share this question
or