Pass Session to Report

[Max]

Hi Telerik Team,

    Is it possible to pass login session (credentials/values) from an asp page to a table datasource in telerik report? if yes, then how do I do it?
    I am using Q1 version. I followed some samples/examples to connect datasource programatically from telerik website but that doesn't produce the results. It causes error message " ExecuteReader: Commandtext property is not initialized for table 1".
    I have login session information in  .aspx page containing reportviewer and one .cs report which is attached to reportviewer.
Would you please reply to [e-mail]?

Thanks,
Dhara

[Peter]

Hi Max,

In order to follow Telerik Reporting the best practices, we highly recommend the new SqlDataSource component approach. The datasource components have full design time support. Additionally when our datasource components are used, handling of datasource parameters don't require any code and you can pass the credentials directly to a report parameter. You may find useful the following help resources:

• SqlDataSource Wizard help article;
• SqlDataSource videos at tv.telerik.com;
• Using Parameters with the SqlDataSource component help article;
• Using Report Parameters programmatically help article.

Up to the error you have experienced make sure you have copied the connectionString from the application settings to the web.config file of your application. This is required in order to get the connectionString at run time. 

Kind regards,
Peter
the Telerik team