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 |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2009-11-09 : 18:11:11
|
| Hi there,I am not liking the multi select drop down list at all, very irritating to users also. For one thing it is required and there is no way to default (Select All). So is it possible to have a Report Parameter field wherein user enters partial value and a google like list comes? Is that at at all possible?Thanks a lot! <><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-11-10 : 11:21:24
|
quote:
Originally posted by yosiasz
... and there is no way to default (Select All)...
You can indeed have a default of all. When defining the parameter, select the same query for the default as you did for the creation of the drop down.JohnIt's a small world (but I wouldn't want to paint it) |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-11-10 : 15:36:43
|
| John, you are the awesome! Now why does it startup the report though (as if I clicked View Report) I do not want that to happen.Thanks also to Brett<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-11-10 : 15:50:28
|
| Unfortunately if all parameters are selected by defaults at start up, the report is displayed. The one time that I had user complaints. I created a new parameter that had only one option and I did not create a default selection. Ugly but they liked it.JohnIt's a small world (but I wouldn't want to paint it) |
|
|
|
|
|
|
Google-like search feature