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:


    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.


    Thursday, July 17, 2008 1:32 PM


All replies