Solved

Sharepoint list Person column type to remove the comma demiliter

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

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

615 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