cant pass url parameters to ssrs report

• Siten0308

  SSCarpal Tunnel

  Points: 4404

  More actions

  May 31, 2012 at 5:07 pm

  #262288

  Hello,

  I have tried looking up MSDN which I have found how

  http://msdn.microsoft.com/en-us/library/ms155391.aspx

  , but it doesnt work when I try and pass customerid = 55309 and auctionid = 44 in the url, which looks like this below:

  http://ir-prodsql03/Reports/Pages/Report.aspx?ItemPath=%2fScore%2fRegistration&rs:Command=Renderrc:&Customerid=55309&auctionid=44

  doesnt work, is there a setting i need to check?

• Siten0308

  SSCarpal Tunnel

  Points: 4404

  More actions

  June 1, 2012 at 9:37 am

  #1495941

  Hello Everyone,

  I figured out the problem, sorry, but for everyone, please make sure you have REPORTSERVER, keyword, add server, example below:

  http://ir-prodsql03/ReportServer/Pages/ReportViewer.aspx?%2fScore%2fRegistration&rs:Command=Render&param1=variable1&param2=variable2

  I was putting:

  http://ir-prodsql03/Reports/Pages/Report.aspx?ItemPath=%2fScore%2fRegistration&rs:Command=Render&param1=variable1&param2=variable2

  also for param1 and param2, make sure you use your parameter names and my co-worker brought up a good point, make sure the data exists in your database, it cant work if there is no data.

  hope this all helps someone 🙂