SSRS report parameter.label showing parameter.value

ssrs-2008 axapta dynamics-ax-2012
alphaprolix picture alphaprolix · Feb 19, 2013 · Viewed 39k times · Source

I have a SSRS report, in my report I have a dataset which has an ID and NAME field, then I created a parameter and set its value to ID from dataset and Label to NAME of dataset. I can see the label when I preview report and select it, but I am also showing the selected parameter on report for this I am using expression :

=Parameters!P_TargetBrand.Label

But when report runs it is showing parameter VALUE instead of Label.

My SQL version is :

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64) Jun 11 2012 16:41:53 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)

Answer

Gil Peretz picture Gil Peretz · Feb 19, 2013

Case when your parameter is Single Value :

=Parameters!<ParameterName>.Label

Case when your parameter is Multi Values :

=Parameters!<ParameterName>.Label(0)

OR 

=Join(Parameters!<MultivalueParameterName>.Label,", ")

For Additional information try here.

Related questions

How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More
SSRS Query execution failed for dataset

Have just deployed my Project on to my reporting Server. I have multiple datasets which are referencing views which exist on the db on that server. When I try to go into any report part I am getting this message: …

Read More