Ronald McDonald Ronald McDonald - 11 days ago 7
ASP.NET (C#) Question

Open SSRS report from asp.net and pass in CustID parameter

I need to link to a server side SSRS report from ASP.NET and pass in a CustID parameter.

Here is the link to the report

http://svr-ssrs/Reports/Pages/Report.aspx?ItemPath=%2fCOMPANY%2fMedical+Professional+Portfolio+Status+Report


I have tried adding &CustID=12345 to the end of the link, but that doesn't work. How can I get the link to work and pass in the parameter?

We are using asp.net 3.5 and sql server 2005

Answer

Your URL is wrong for direct access to the report with parameters. It should be http://exampleWebServerName/reportserver?/foldercontainingreports/reportname

If you append parameters onto this, it should work.

Taken from the same MSDN link as George posted.