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 |
|
danisimo
Starting Member
2 Posts |
 Posted - 2008-07-28 : 11:51:39
|
| I need your advice on how to implement this. I need to be able to select 5 customers and 10 part numbers and send them as parameters to a stored procedure. I have heard of something like using a string with multiple parameters but I was told to use a check box. I would like to know how to implement this in the report designer in visual studio and what's your advice on handling them in the database levelthank you so much |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-28 : 12:59:06
|
| You can use multiselect parameter for both customers and partnumbers. On selecting more than 1 value they will send as a comma seperated list to database. then in your query/sp you can use a UDF to parse them and filter result set on the values or even use string comparison using LIKE to get your result. |
 |
|
|
danisimo
Starting Member
2 Posts |
Posted - 2008-07-28 : 13:57:18
|
quote:
Originally posted by visakh16
You can use multiselect parameter for both customers and partnumbers. On selecting more than 1 value they will send as a comma seperated list to database. then in your query/sp you can use a UDF to parse them and filter result set on the values or even use string comparison using LIKE to get your result.
Thanks for your advice. As far as I know, the multiselect parameter feature is not built into sql server 2000 is that right? it is only found in 2005 and up. If I am wrong correct me please |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-29 : 04:27:08
|
quote:
Originally posted by danisimo
quote:
Originally posted by visakh16
You can use multiselect parameter for both customers and partnumbers. On selecting more than 1 value they will send as a comma seperated list to database. then in your query/sp you can use a UDF to parse them and filter result set on the values or even use string comparison using LIKE to get your result.
Thanks for your advice. As far as I know, the multiselect parameter feature is not built into sql server 2000 is that right? it is only found in 2005 and up. If I am wrong correct me please
sorry didnt realise i was in 2000 forum. you're right. multivalue params are available only in sql 2005 reports and above. |
|
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2008-07-31 : 11:18:16
|
| If you know you have 5/10 parameters then just write the SP to take that many parameters. It's only hard when you don't have an upper limit. |
|
|
|
|
|
|
multiple parameters advice