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 |
|
cvipin
Yak Posting Veteran
51 Posts |
 Posted - 2009-09-01 : 12:29:40
|
| Hi,I have a report with a parameter set to accept multi values. The values selected will be sent as comma separated to SQL. The problem is, I have some string values that contains comma which is causing the query not return proper data. Is there a way to send these values as different delimeter instead of comma? or any other workaround?The data I have is like:LoanOfficerMackay, DonnieCaropreso, MarkThanksVipin |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-09-02 : 06:25:41
|
| i think wht you need to do is to escape the , values appearing in data before sending to db. you can write a custom function in reporting services for that |
 |
|
|
cvipin
Yak Posting Veteran
51 Posts |
Posted - 2009-09-02 : 10:55:09
|
quote:
Originally posted by visakh16
i think wht you need to do is to escape the , values appearing in data before sending to db. you can write a custom function in reporting services for that
Hi Visakh,I am new to reporting services. Can you share how can I perform this?Vipin |
|
|
|
Vadivu
Starting Member
31 Posts |
Posted - 2009-09-07 : 02:13:50
|
| i understand that u need the parameter value as 'LoanOfficer';'Mackay, Donnie';'Caropreso, Mark'in that case use this expression to get the delimiter as ; =Join(Parameters!parametername.VALUE,"';'") |
|
|
|
|
|
|
Multi value parameters