locked
Passing Parameter In URL QueryString Not Working RRS feed

  • Question

  •  

    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

    Thursday, July 17, 2008 1:32 PM

Answers

All replies