View Single Post
  #1 (permalink)  
Old July 12th, 2007, 03:02 AM
kokila kokila is offline
Registered User
 
Join Date: Jul 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default pass null to the parameter in the stored procedure

Hi there,

     I am using SQL Reporting Services to generate reports. I am calling the stored procedure from the reporting services. The procedure has parameters which take null. I am stuck with passing null to the parameter from the reporting services. I shows the error and the report is not generated. Could you please suggest the way to pass null to the stored procedure parameter from the SQL Reporting Services.

Kindly reply me with the possible solution ASAP.

Thanks in advance