Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Sharepoint list Person column type to remove the comma demiliter

Posted on 2014-10-23
1
Medium Priority
?
178 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 1500 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses

722 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