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