Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 How to select all by default

Author  Topic 

roy mm
Yak Posting Veteran

62 Posts

Posted - 2007-03-29 : 02:24:24
Hello.

I have a parameter with multi values taken from a query.

When I open the report the first option in the parameter option list is "select all".

I want the "select all" to be selected by default when I open the report.

I Tried to use the same query in the default value of the parameter in the hope that this will check all the values but it didn't work.

Any ideas?

Thanks!
   

- Advertisement -