How to Show First Name and Pass Id on Report Server in BIRt reports

shashankgoyal3 · 2018-03-20 13:34:57

Hi,

I am having difficulty in making BIRT reports work in case when we show First names as display value in parameters and pass corresponding Id's in SQL.
Can someone show me an example of achieving this?

Regards
Shashank

eduardo · 2018-03-21 07:59:03

Hi Shashank,

what difficulty are you having?
You can use datasource parameters for this: https://reportserver.net/en/guides/admi … atasource/
In the first table, 1, 2, 3, 4 are the IDs, A,B,C,D the values displayed, in this case, the first names.

Regards,
Eduardo

shashankgoyal3 · 2018-03-21 09:49:17

Hi Eduardo,

I was confused about the ordering of the column values as there is not option to map the column which you want to display & which you want to pass to query.

So If I understand it correctly. If we have 2 columns in our data source parameter query 1st column represents the values (Id's in our case) which will be passed to main table query and 2nd column represents the values (First Name in our case) which will be shown to users.

Regards
Shashank

eduardo · 2018-03-21 10:07:03

Hi Shashank,

yes, this is correct.

Regards,
Eduardo

shashankgoyal3 · 2018-03-21 15:44:06

Thanks. It is working

ReportServer Forum

#1 2018-03-20 13:34:57

How to Show First Name and Pass Id on Report Server in BIRt reports

#2 2018-03-21 07:59:03

Re: How to Show First Name and Pass Id on Report Server in BIRt reports

#3 2018-03-21 09:49:17

Re: How to Show First Name and Pass Id on Report Server in BIRt reports

#4 2018-03-21 10:07:03

Re: How to Show First Name and Pass Id on Report Server in BIRt reports

#5 2018-03-21 15:44:06

Re: How to Show First Name and Pass Id on Report Server in BIRt reports

Board footer