SharePoint 2010 Integrated Mode with SQL Server 2008 R2 : Report having issue with PeoplePicker Field
The setup consists of SharePoint 2010 with SQL Server 2008 R2. I am generating a Report by connecting the list as data source. The list is having a peoplepicker field. The field can accept multiple values as well. The report previewed on server shows one row while deployed report viewed from sharepoint site is having separate rows for each value in the peoplepicker field. Any help will be appreciated. Thanks, Bhadr :) Mark as Answer if it solves your problem. Vote As Helpful if the post is helpful for you.
October 12th, 2012 4:18am

Hi Bhadr, This is a known issue when using SharePoint List data source in Reporting Services. To eliminate the duplicate values of the SharePoint list, we could use custom code. For the detailed information, please see JinChun's answer in the following thread: How to get distinct values of sharepoint column using SSRS You can also refer to the "How do I get distinct values of SharePoint column using SQL Server Reporting Services?" artilce in the "Part III Reporting Services" section of the SQL Server Community FAQs eBook. Regards, Mike YinMike Yin TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
October 18th, 2012 6:31am

Hi Mike, First of all, Thanks a lot for the answer. Let me explain the issue in more detail. There is a list with 10 columns. One of the columns is of type People or Group. Here, I have set the column to accept mutliple values for the People Field. So end users can enter mutliple values in the fields. For Example, they can enter two users: "User1;User2;" I use this list as data source to generate SSRS report. I am able to design the report and while previewing the report it shows correctly. It will show "User1;User2;" in same column for one record in preview. When I deploy it to SharePoint library and generate the report, it shows the two records separately for User1 and User2. For both the records, the other columns will be the same while only People Field have one value per record. I have a real scenario where it shows as many different records as the no of entries in people field after deploying to sharepiont which works fine when previewed from BIDS on Server. I hope that I have explained the problem correctly this time. Thanks, Bhadr :) Mark as Answer if it solves your problem. Vote As Helpful if the post is helpful for you.
October 18th, 2012 6:54am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics