Solved

Sharepoint list Person column type to remove the comma demiliter

Posted on 2014-10-23
1
171 Views
Last Modified: 2015-01-09
I have a ssrs 2008 r2 report that uses sharepoint 2010 list as data source.My issue is that I have a column Assigned to as person type column and it is sharepoint account name first name, last name. I am using this column as parameter in the report. In the report parameter it shows first name,last name and user is getting confused in selecting. Is there anyway that I can get rid of the comma in the account name (first name, last name) so that i can use full name in parameter.
Please find attached the rdl file for your refrence.I have used custom code to remove the duplicate records in parameters.can anyone guide me in removing the comma delimiter. Thank you in advance.
CommaDelimiter.png
HelpCentreStatusReport-Deve-oct23.rdl
0
Comment
Question by:asrithap
[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
1 Comment
 
LVL 8

Accepted Solution

by:
Jayaraja Jayaraman earned 500 total points
ID: 40399785
you can use either internal name or the display name of the user which mean, login user account or the login name for the report. if you wanna exclusively remove comma, use custom text replace of "," to " " and populate
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Suggested Courses

751 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