Set CrossTab DataSource in code-behind

[Marcello]

Hi,

I develop my reports with a standard sql connection.
Contrariwise, when I consume the reports in my application I set datasource programmatically (report.DataSource=<DataTable>).
All work good if the report is a simple report.
If it contains a CrossTab the ReportViewer fails and show a message as "An error has occurred while processing Table 'crosstab1': Unable to establesh a connection to the database..."

Thanks,
marc.

[Marcello]

No suggestions...?
marc.

[Stef]

Hi Marc,

The Crosstab item is a data item, having its own DataSource property. to set its DataSource at run-time you can access the item from the report's Items collection as follows:

var report=new MyReport();
var crosstab= report.Items.Find("crosstab1",true)[0] as Telerik.Reporting.Crosstab;

report.DataSource=GetReportData();
crosstab.DataSource=GetCrosstabData();

reportViewer1.ReportSource = new InstanceReportSource { ReportDocument = report};

I hope the above information is helpful.

Regards,
Stef
Telerik

 

 

[Aseman]

your solution has more than 1 connection string