How to pass Enviorment Variables to SSRS Report
Hello, I am looking for a solution where I can pass my ASP.NET app's enviorment variables to a SSRS report in SSRS 2008 when I pass a call to the repot in Report Viewer. I do not know How to achive this? Please assist someone for this issue. Regards, Nilkanth Desai
February 26th, 2011 9:06pm

You can create a parameter and then set the value for the parameter. Check this video out and let me know if it solves your problem http://www.youtube.com/watch?v=sXJmRHgSAS8. Russel Loski, MCT
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 9:25pm

Hi Nilkanth, As posted, we can add a parameter to the report and set value for the parameter through the ReportViewer control. · If you are using the ReportViewer to display report on the Report Server, we can use the ServerReport.SetParameters method, please refer to: http://msdn.microsoft.com/en-us/library/ms252178.aspx · If the ReportViewer is configured to display a local report, we can use the LocalReport.SetParameters method, please refer to: http://msdn.microsoft.com/en-us/library/ms252146.aspx For more information about Adding Parameters to a Report, please refer to: http://msdn.microsoft.com/en-us/library/aa337432.aspx Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
March 1st, 2011 7:22pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics