how to set SSRS Report parameters to be optional i.e Non-Mandatory field in SSRS 2005

Question

Please help me to set the SSRS Report parameters to be optional i.e Non-Mandatory field in SSRS 2005.

Answer 1

As Hiten suggested there is nothing exactly we can call as optional parameters but if you want users to see this parameter as optional, use formula or case statements.

Parameterized stored procedures with some defaults or null value can be used to achieve the same goal.