#1 2018-05-11 09:17:28

shashankgoyal3
Member
From: India
Registered: 2017-11-07
Posts: 14

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

Offline

#2 2018-05-14 10:39:54

eduardo
Administrator
Registered: 2016-11-01
Posts: 583

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

Offline

Board footer

Powered by FluxBB