ReportServer Forum

shashankgoyal3

Member

From: India

Registered: 2017-11-07

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

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

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

shashankgoyal3

Member

From: India

Registered: 2017-11-07

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

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

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

Hi Shashank,

yes, this is correct.

Regards,
Eduardo

shashankgoyal3

Member

From: India

Registered: 2017-11-07

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

Thanks. It is working

---

Regards
Shashank