Ignore Parameter if Null

[robbclaxton]

I am trying to use a parameter to exclude data from the select, but optionally. If no value is stored in the parameter I want it to show all data. Is this possible?

 

[IanWaterman]

You can set a default eg All or 0.

Then in select

//string
(If {?Param} <> 'All' then {field} = {?Param} else true)
//number
(If {?Param} <> 0 then {field} = {?Param} else true)

Wrapped in () so it can be used with other clauses.

Ian

 

[robbclaxton]

Thanks Ian, It had to be simple else I would've remembered lol!