ReportServer Forum

aditi.raiter

Member

Registered: 2018-05-01

Option to display name in the parameter but pass a key to a DL query

Hi There

Is there an option to display name in the parameter dropdown values but pass a key to a DL query.

I found a workaround using another select clause in the DL that gets the value of the name passes and sends this to the main query.

But this slows down the performance.

Is there a way I can use post-processing for this requirement?

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Option to display name in the parameter but pass a key to a DL query

Dear aditi.raiter,

we assume that you refer to datasource parameters: https://reportserver.net/en/guides/admi … atasource/
There, you can see: value and display options.

What exactly do you mean by "display name" if not the value displayed ?

"The specified values will be provided by a datasource, giving it its name. ReportServer expects a table with one or two columns to be returned from the datasource. Here, if there is one column the values will be taken as display value and parameter value. If two columns are returned, by default the first column is regarded as parameter value and the second one as display value."

Regards,
Eduardo

aditi.raiter

Member

Registered: 2018-05-01

Re: Option to display name in the parameter but pass a key to a DL query

Thank You! I missed this detail. I used to select just one column from the table earlier for a Datasource parameter.