SSRS display parameter label in the expression of text field
Posted on 2014-12-09
I have a parameter that is created by adding available values:
parameter prompt: Expired
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.TextRuns’ returned a data type that is not valid.
Thanks in advance