Hi,
I'm a bit going crazy about a certain report.
I have a report that shows certain fields of some DB records. That records have also some related records in other DB tables.
I have to show, almost all of the related records in the same report too. So I'm trying to design sub-reports or table items to show the related records in the same report.
The problem is, I have to supply the ID of the current record to each sub-report or table; but I was not lucky in finding similar examples or any documentation about it.
To further illustrate my problem, I attached a screenshot. In the screen shot I triled to give hints; about what I'm doing.
So basically, I need to populate related datas in the same report, by giving the current record ID to other datasource's which pull the related data's.
PS : I found some examples about cascading report parameters, and I'm somewhat familiar with report lifecycle. But I'm still not able to populate the cascading report parameters properly. I always get null values for cascading parameters. So there must be something wrong about what I'm doing.
I'm a bit going crazy about a certain report.
I have a report that shows certain fields of some DB records. That records have also some related records in other DB tables.
I have to show, almost all of the related records in the same report too. So I'm trying to design sub-reports or table items to show the related records in the same report.
The problem is, I have to supply the ID of the current record to each sub-report or table; but I was not lucky in finding similar examples or any documentation about it.
To further illustrate my problem, I attached a screenshot. In the screen shot I triled to give hints; about what I'm doing.
So basically, I need to populate related datas in the same report, by giving the current record ID to other datasource's which pull the related data's.
PS : I found some examples about cascading report parameters, and I'm somewhat familiar with report lifecycle. But I'm still not able to populate the cascading report parameters properly. I always get null values for cascading parameters. So there must be something wrong about what I'm doing.
1 Answer, 1 is accepted
0
Hello Faruk,
Your scenario resembles the Invoice demo report from our examples. In it SalesOrderID field from the master report is passed to the detail sub-report and then used in a filter to show only the related detail records. Please, take a look at its implementation in our sample solution which is installed with the product and let us know if you have any additional questions. You can also take a look at the
How-To: Creating Master-Detail Reports Using SubReports help topic for more information.
Hope this helps.
All the best,
Chavdar
the Telerik team
Your scenario resembles the Invoice demo report from our examples. In it SalesOrderID field from the master report is passed to the detail sub-report and then used in a filter to show only the related detail records. Please, take a look at its implementation in our sample solution which is installed with the product and let us know if you have any additional questions. You can also take a look at the
How-To: Creating Master-Detail Reports Using SubReports help topic for more information.
Hope this helps.
All the best,
Chavdar
the Telerik team
Q3’11 of Telerik Reporting is available for download. Register for the What's New in Data Tools webinar to see what's new and get a chance to WIN A FREE LICENSE!