SqlDataSource set programmatically asp MVC

[KAMIL]

Hey,

I'm trying to find way how to set up datasource connection string programmatically. I have report .trdx created (works for hardcoded connection string) and I have few of mysql databases with the same structure. I need ability to set connection string each time before run report. Is there any way to do this for web application? Im trying with deserialization of report and set connection but i can't see any way to pass Report object into report view.

[Stef]

Hi Kamil,

Please test using the approach suggested in the Changing the connection string dynamically according to runtime data KB article. Notice that Telerik.Reporting.Report objects are passed to viewers/ReportProcessor via an InstanceReportSource. For more details, please refer to the Report Sources article.


I hope the above information is helpful.

Regards,
Stef
Telerik

 

 

[Aseman]

Hi

in this sample we have got sqlDataSource by filling connection string ,....

     How Can I Fill sqlDataSource by Datatable and without connection string??

since my start up project has connection string in its config File and I can not use the connection string again in another project because of this Error

"an error has occurred while processing table 'crosstab 1' .....  format of the initialization string does not conform to specification starting at index 0"

I have My Datatable which I need. 

MyReport report = new MyReport();
string selectCommand = @"SELECT * FROM Sales.Store";
string connectionString = "Data Source=(local)\\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=True";
Telerik.Reporting.SqlDataSource sqlDataSource = new Telerik.Reporting.SqlDataSource(connectionString, selectCommand);
report.DataSource = sqlDataSource;

[Aseman]

please help ,10 days passed,anybody knows?

[Nasko]

Hello Aseman,

Check this stackoverflow thread with information on the error message.

Regards,
Nasko
Progress Telerik