ReportServer Forum

shashankgoyal3

Member

From: India

Registered: 2017-11-07

How to use distinct values from CSV datasource

Hi,

I have a CSV datasource from which I am displaying Names to user in BIRT report. Now, there is a requirement of passing multiple id's with same name to my BIRT report.

i.e
Id;Name
1001;xyz
1002;xyz
1003;xyz
1004;abc
1005;abc

I just want to show xyz & abc to use rather than xyz,xyz,xyz,abc,abc in drop down list.. Is there any way by which I can select distinct names and pass all id's to my report??

---

Regards
Shashank

eduardo

Administrator

Registered: 2016-11-01

Website

Re: How to use distinct values from CSV datasource

Hi Shashank,

you can use a script datasource for this: https://reportserver.net/en/guides/scri … tasources/
The script would read your CSV file and create the strings as you need them (in this case "xyz & abc").

Regards,
Eduardo