Using nulls/blank values in SP through URL Query String

• Nolan St. Martin

  SSC Rookie

  Points: 49

  More actions

  September 20, 2004 at 8:56 am

  #109245

  I'm running into a very annoying problem that I haven't been able to find a workaround for. Basically, I have a stored procedure that requires 5 parameters. My stored proc creates a dynamic query, filtering for results based on the parameters. When I pass blank values to the stored proc in Query Analyzer, everything works fine (and I'll get the complete set of results). However, when I pass in blank parameters to the URL for Reporting Services, I get the following message:

  Reporting Services Error

  ---

  • Default value or value provided for the report parameter 'DocNo' is not a valid value. (rsInvalidReportParameter) Get Online Help

  ---

  Microsoft Reporting Services

  With 'DocNo' being the first parameter I pass in. Here's an example of my URL string I'm using:

  arameters=false&DocNo=&Title=&Owner=&RevisionNo=&ReleasedDate">http://reportServer/rptMasterList&rs:Command=Render&rcarameters=false&DocNo=&Title=&Owner=&RevisionNo=&ReleasedDate=

  Any help with this would be greatly appreciated.

• Carol Hawes

  Newbie

  Points: 2

  More actions

  February 23, 2005 at 3:47 pm

  #543796

  I'm having the same problem! 

• philcart

  SSC-Forever

  Points: 47797

  More actions

  February 23, 2005 at 4:11 pm

  #543798

  Are your parameters setup to allow nulls?

   

  --------------------
  Colt 45 - the original point and click interface

• John Doe-231437

  Newbie

  Points: 1

  More actions

  May 9, 2005 at 8:20 am

  #557617

  value:isnull.

  http://www.aaronweiker.com/PermaLink,guid,d557e840-a905-461f-802c-6c334f94823f.aspx

  Better late than never...