• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1105
  • 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 BurtonDirector, Practice Manager and Computing ConsultantCommented:
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 BurtonDirector, Practice Manager and Computing ConsultantCommented:
Is it a string? if so, it needs to be in quotation marks.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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