Default Value 'All' for multi select parameter

Hi,

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.

Thanks,

Ajinkya