Solved

Sharepoint list Person column type to remove the comma demiliter

Posted on 2014-10-23
1
142 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
Comment Utility
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now