SQL Server Performance

Sending a Null parameter value

Discussion in 'SQL Server 2005 Reporting Services' started by EMoscosoCam, Jul 18, 2008.

  1. EMoscosoCam Member

    In the SSRS interface for parameter input, how can I send Null for a parameter value?
    Thanks a lot.
  2. satya Moderator

  3. Adriaan New Member

    Note that when you supply NULL as the parameter, and your sproc has a default value for that parameter, then the default value will not be used. Defaults for parameters only kick in when the parameter is not mentioned when the sproc is called.

Share This Page