Null Value

Hello,

I have SQL 2005 stored procedure to generate parameters in the report.

one of the stored procedure parameters need to be null (one of the @. in the SP)

How can I send null value to the stored procedure ?

Currently I create a new report parameters with default value NULL that it is internal (hide from the user) and I point the parameters in the SP need to be null to this parameters.

This look not a nice solution.

any other solution ?

Have you tried "=Nothing" as the value of the SP parameter?