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.
| Author |
Topic |
|
ntswakisto
Starting Member
33 Posts |
 Posted - 2010-04-08 : 02:16:48
|
| HiI need help.I have created a report with two parameter and created drop down list for user to select value.I have published the reports to report manager.In report manager I have to make the report run unattended so i need to enter parameters for user and save them as default.In the list a user has to (select all) ..how can i make select all a default value? |
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2010-04-09 : 01:22:13
|
| Create a stored procedure that returns all avaliable values for the parameter. Under report data in BIDS select parameters and expand. Right click on the parameter and select parameter properties. Under General tab select Allow Multiple values, Under available values select Get values from a query radio button then select the dataset as your stored procedure then select the value field and label field, Under default values select get values from a query radio button then select the dataset as your stored procedure then select the value field. |
 |
|
|
|
|
|
Select all as default value