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 |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2010-02-17 : 07:48:56
|
| Hi there,Is it possible to have a muti-valued parameter that we can type in and it adds to a list instead of having a drop down and ticking the records we want? The problem I have is that even when I filter one of my parameters it still shows 100s of records which makes it less convienent to scroll through. Better if users could just type each record (i.e. project number) and add it to a list.Would I need to do this through a web portal perhaps?Any help would be greatThanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-17 : 09:37:56
|
| nope. this is not possible inside multi valued parameter dropdown. you could make it dependent on other parameter so that once you select a value in other, the multi valued dropdown contains only values related to it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
cidr
Posting Yak Master
207 Posts |
Posted - 2010-02-17 : 11:14:23
|
| Hi, Well, I'll probably need to add this to the web portal functionality and allow a list to be built up and the values sent to a table which the report param query will use.Cheers |
|
|
|
|
|
|
Type in multivalued parameters?