Solved

Sharepoint list Person column type to remove the comma demiliter

Posted on 2014-10-23
1
158 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
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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
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…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

786 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