set value of variable and use it in same SSRS expression

reporting-services ssrs-2008 ssrs-expression
Yash picture Yash · Feb 17, 2018 · Viewed 8.2k times · Source

In SQL server reporting services(SSRS) tablix cell, i want to write an expression as follows:-

set the value of variable and use that variable in "if" condition. i have written following expression and its working fine, only issue is i want only "if" condition to be evaluate. currently output is : "TrueVariable text is NA"

=Variables!myVar.SetValue("NA")
&IIf(Variables!myVar.Value="NA","Variable text is NA","Variable text is not NA")

Answer

Jayvee picture Jayvee · Feb 19, 2018

The result you get is because you are concatenating both expressions, the assignment and the conditional. The assignment returns "True" and the conditional "Variable text is NA" therefore the result is "TrueVariable text is NA"

if you want just the result of the conditional you can for example wrap the assignment inside an IIF, and as it always will be true, then you can do something like this

=IIF(Variables!myVar.SetValue("NA"), 
 (IIf(Variables!myVar.Value="NA","Variable text is NA","Variable text is not NA"), "should never get here"
 )

Related questions

SSRS Expression: The value expression for textbox has scope parameter that is invalid for aggregate

i'm recieving the following error: Error 1 [rsInvalidAggregateScope] The Value expression for the text box ‘Textbox2’ has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal …

Read More
How to display yesterdays date in SSRS expression

In one of the column name, I need to display yesterday's date like - September 4,2014 I used DateAdd("d",-1,Today()) function to display,but it is displaying like - 9/4/2014 12:00:00 AM. How can i get the above format like - …

Read More
Show or Hide SSRS column based on specific parameter value

I am having trouble showing/hiding a column based on parameter value chosen. How my report is set up: Parameter: ImportStatus --ImportStatus parameter has three values you can choose from: M, V, E If I choose ImportStatus value = 'M', then …

Read More