Search code examples
sqlreporting-servicesssrs-2008

How to use stored proc with null parameters in SSRS?

i have a report that uses a stored procedure that is using optional parameters.I have 4 optional parameter,so in the report's preview tab ,i can 4 textboxes for the parameters.But when i dont write anything in the textboxes,i get an error..What can i do to execute my proc with null parameters is SSRS ?

Solution

  • you can declare parameters to procedure as follows:

    @Your_parameter VARCHAR(50) = NULL

    and use in the where as:

    where (@Your_parameter IS NULL OR columnname = @Your_parameter )