Binding to different data sources in report and table

[Eli]

I have a report which binds to a dataSourceObject1. In that same report, I have a table at the bottom of the report (for something else I need to print along with the report) which binds to dataSourceObject2. However, when I try to print it, the report prints fine until it gets to the table, in which it says,

"An error has occurred while processing Table 'table1': An error has occurred while resolving 'objectDataSource2' data source: Object reference not set to an instance of an object."

Here is what is in my C# code for the data source that the report prints from:

Telerik.Reporting.ObjectDataSource objectDataSource1 = new Telerik.Reporting.ObjectDataSource();

objectDataSource1.DataMember = "PaymentReportResult";
objectDataSource1.DataSource = TransformReport(_paymentData);
objectDataSource1.Parameters.Add(new Telerik.Reporting.ObjectDataSourceParameter("search", typeof(ReportSearch), search));

 

I thought I could do the same with another datasource, adding it in the same way, however this does not work. Additionally, if I switch the dataSource of the table to the same as the report, it also fails. I figured that means I am missing something when it comes to specifically binding it to the table.

[Momchil]

Hello Eli,

The code you shared looks correct and I do not think that you are missing anything when it comes to binding the table to the second data source. Assuming that you have a valid ObjectDataSource object, binding it to the table should be a matter of assigning it to the table's DataSource property (see the Binding ObjectDataSource to a BusinessObject article).

For example:

table1.DataSource = objectDataSource2;

That said, it is still difficult for me to pinpoint the source of the issue with the available information.

If you do not mind sharing your report, I would be glad to take a closer look at it.  

Kind Regards,
Momchil
Progress Telerik