Solved

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

Posted on 2010-08-25
6
760 Views
Last Modified: 2012-05-10
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
Comment
Question by:wilcon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 16

Expert Comment

by:vdr1620
ID: 33522737
check this link for Replacing Text in a Field at Run Time

http://msdn.microsoft.com/en-us/library/ms157328.aspx
0
 
LVL 10

Accepted Solution

by:
itcouple earned 500 total points
ID: 33522771
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
 
LVL 42

Expert Comment

by:dqmq
ID: 33522831
>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
 

Author Comment

by:wilcon
ID: 33827918
Updating.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 34533080
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question