Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  How to get Session variable as parameter to report

Author  Topic  Sadhu Starting Member 14 Posts Posted - 2014-05-07 : 00:51:41 Hi, I am new to SSRS reporting. The requirement is that in our report we need some parameters to generate the report. To get those parameters we are using drop downs in the report itself by creating a DataSet and calling a stored procedure. Now, the concern is that, the drop downs must be populated based on the user ID that comes as a session from ASP.net application. So, how to populate the drop downs based on the value coming as Session from ASP.Net? Please let me know in case you need any further details.