Default Value 'All' for multi select parameter

How can I set the default value = ALL for a multi select query parameter?

I have a collectionparamter in my IREPORT...

samhast's picture
Joined: Nov 4 2011 - 6:41am
Last seen: 6 years 6 months ago

1 Answer:


Write your sql query in such way so that if user provides value to input control then it will be use in report query filter, if you not provide any value then filter part removed from query.

This requirement you can achieve using dynamic where condition in $P!{ } parameter place your where condition in parameter with if else condition based on parameter null or not null.

Hope this helps you.



ajinkya_c's picture
Joined: Aug 29 2012 - 6:13am
Last seen: 6 years 2 months ago