Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 800
  • Last Modified:

Is there anyway to change the comma delimiter for multiple selections of a parameter in SSRS

I need to allow the users to select more than one parameter value, for example colors, they can select Red, Yellow and Green or just Green.  I know I have to use a split function when feeding this data back to my stored procedure from SSRS, the problem is my data has commas in the name so won't be split correctly all the times. Is there a way for me to change the delimiter in SSRS?
0
wilcon
Asked:
wilcon
1 Solution
 
vdr1620Commented:
check this link for Replacing Text in a Field at Run Time

http://msdn.microsoft.com/en-us/library/ms157328.aspx
0
 
itcoupleCommented:
Hi

Yes. When you use Join function is SSRS use can specify different delimeter for instance =Join(@Param, "|") I usually use | as it is quite unique. Your split function in database should also delimiter that you can set as "|"

I hope that helps
Regards
Emil

0
 
dqmqCommented:
>I know I have to use a split function when feeding this data back to my stored procedure from SSRS

I confess I don't know what you mean by "feeding data back from SSRS".  However, can't you use the replace function to replace comma's in your data with something else and then reverse the process in the stored procedure?

Would be helpful if you could show us the relevant code.
0
 
wilconAuthor Commented:
Updating.
0
 
mlmccCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now