Handle multiple datasource from code

[Franko Govanni]

Hi:

I need to use different a Subreport datasource as the information comes from different tables in my database, but I want to do this using code and not through the wizard.

How can I do to accomplish this, or another option I suggest a package?

Thank you.

[Steve]

Hello Franko,

Delivering data for a child subreport can be accomplished in three ways:

• Using report parameters and filters (done through the report designer)
• Using the NeedDataSource event of the SubReport item
• Using the NeedDataSource event of the Child report.

From your scarce explanation, it would seem that you aim for #2. This method is appropriate in the case child report is shared between more than one master reports and thus show different data depending on the context. The child report DataSource should be null, thus signaling the reporting engine to raise NeedDataSource event. The event handler usually resides in the Master report definition class. The handler normally looks as the next code snippet:

Telerik.Reporting.Processing.SubReport subReportItem = sender as Telerik.Reporting.Processing.SubReport;
subReportItem.InnerReport.DataSource = <your_datatable>;

Best wishes,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.