Link to home
Start Free TrialLog in
Avatar of mburk1968
mburk1968Flag for United States of America

asked on

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.
Avatar of Phillip Burton
Phillip Burton

I've not seen the term 1- before - should that read 1 or "1-" or -1?

That's probably where the error is.
Avatar of mburk1968

ASKER

the 1- is the incoming parameter value. 1- = PA, 4- = MD
ASKER CERTIFIED SOLUTION
Avatar of Phillip Burton
Phillip Burton

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial