• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2267
  • Last Modified:

SSRS display parameter label in the expression of text field


I have a parameter that is created by adding available values:

parameter prompt: Expired

label    value
Yes       0
No        1

I am trying to display on the report: EXpired: Yes (if yes is selected from dropdown box)

here is the expression I wrote:   ="Expired: " + Parameters!ExpiredName.Label
I have tried CSTR(Parameters!ExpiredName.Label),... but does not work.

but I keep getting #Error displayed instead.

the warning is:  Warning               1              [rsInvalidExpressionDataType] The Value expression used in textrun ‘Textbox28.Paragraphs[0].TextRuns[0]’ returned a data type that is not valid.                

Thanks in advance
1 Solution
ValentinoVBI ConsultantCommented:
Are you sure you've got the name of the parameter right?  Try:


If Expired is the name of the parameter then this should run fine.  Once that works, add the additional string part.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now