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

sql-server reporting-services ssrs-2008 reportingservices-2005
Dhana picture Dhana · Mar 11, 2013 · Viewed 56.5k times · Source

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

Answer

djangojazz picture djangojazz · Mar 11, 2013

Set the parameter to 'Allow null value' under General section. Null according to SSRS means it does not have to be set, thus making it optional.

Then post something like this in the predicate of your SQL syntax:

Where column = isnull(@Variable, column)

This lets the dataset know that if the variable is set then use it, else have an operator to have the value equal itself. I am certain this works in SSRS 2008 and 2012, not sure of 2005 but I would assume it may be there.

Related questions

How do I pass parameter TO SSRS report FROM ASP.NET page which has the reportviewer for the report

I have an ASP.NET page which has report viewer control to access reports from report manager. I need to pass report parameter from this ASP.NET page to the report server. I want to pass region number based on …

Read More
SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More
SSRS the definition of the report is invalid

How can I resolve the below error message that I receive when I try to deploy my report to our our Reporting Server using BIDS? Message: Error : The definition of the report '/OrderAnalysis' is invalid. Report Element: <Report …

Read More