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

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

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

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


Regards
Shashank

Offline

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

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

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

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

Offline

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

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

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

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


Regards
Shashank

Offline

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

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

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

Hi Shashank,

yes, this is correct.

Regards,
Eduardo

Offline

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

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

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

Thanks. It is working smile


Regards
Shashank

Offline

Board footer

Powered by FluxBB