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 |
|
roy mm
Yak Posting Veteran
62 Posts |
 Posted - 2009-03-30 : 08:40:21
|
| Hello.I have a report with a multiple value parameter.I'm am trying to give him a few values from an asp.net apllication with a report viewer.I'm useing the "serverReport.setParameter" function and I'm giving it an array with the values:p_param Val1p_param Val2p_param Val3I'm getting an error saying "parameter 'p_param ' was specified multiple times".How can I send this parameter with a multiple values?Thanks. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-03-30 : 09:40:40
|
| You can concatenate the values in asp and send them as one comma delimited string and then use a splitter function (do a search in the script library forum, there are plenty in there) to extract the values in your query. |
 |
|
|
roy mm
Yak Posting Veteran
62 Posts |
Posted - 2009-03-31 : 00:10:55
|
| Hi, thanks for the answer but its just doesn't seem like the right solution. I'm sure there is a better way of doing this then start manipulation with the parameter in Rs.Thanks. |
|
|
|
|
|
|
calling a multiple parameter from asp.net