Passing Parameter In URL QueryString Not Working

• cjspsx

  SSC Veteran

  Points: 276

  More actions

  July 16, 2008 at 4:01 pm

  #188196

  I am trying to pass a parameter into a SSRS report via a URL querystring. The page for the report comes up with the textbox where a user can enter the parameter but does not render the report. The report renders if I manually enter the parameter but that defeats the purpose. I do not want the

  My querystring is as follows:

  http://dev/Reports/Pages/Report.aspx?ItemPath=/CSJ%20Test/City%20Dept&OccID=4084

  OccID is the parameter name.

  In the underlying query the parameter is called as "WHERE (b.Occ_ID = @OccID)"

  I've also tried using rs:Command=Render but that does not help.

  What could I be doing wrong? fyi: I am using SQL Server 2005.

  Thanks,

  cj

• cjspsx

  SSC Veteran

  Points: 276

  More actions

  July 17, 2008 at 9:29 am

  #844488

  Ok, after almost two days ( :sick: ) here is the solution I have found in case anyone else has this issue:

  There appear to be multiple URL paths that can be used to render the report

  What does not work is this way :

  http://dev/Reports/Pages/Report.aspx?ItemsPath= ......

  What does work is:

  http://dev/reportserver .....

  So that my final querystring with parameter that works is:

  http://expressdev/reportserver?%2fCSJ+Test%2fCity+Dept&rs:Command=Render&OccID=4084