Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1048
  • Last Modified:

Report Builder Expression

I have the following Expression that is causing an error.
=IIF(Parameters!gbloptstate.Value = 1-, "(formerly PAHPIX)", IIF(Parameters!gbloptstate.Value = 5-, "(formerly PAHPIX)", IIF(Parameters!gbloptstate.Value = 4-, "(formerly MDHPIX)", IIF(Parameters!gbloptstate.Value = 3-, "(formerly NJHPIX)", "(formerly PAHPIX)"))))

Error: The Value expression for the textrun ‘FormerStateLabel.Paragraphs[0].TextRuns[0]’ contains an error: [BC30201] Expression expected.
0
mburk1968
Asked:
mburk1968
  • 2
1 Solution
 
Phillip BurtonCommented:
I've not seen the term 1- before - should that read 1 or "1-" or -1?

That's probably where the error is.
0
 
mburk1968Author Commented:
the 1- is the incoming parameter value. 1- = PA, 4- = MD
0
 
Phillip BurtonCommented:
Is it a string? if so, it needs to be in quotation marks.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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