Controlling case in an expression
Posted: Mon Jul 12, 2010 4:15 pm
Hi,
I have the following expression that pulls in data based on the entity name being blank or populated.
{IIF(Parcel.[Entity Name] != string.Empty, Parcel.[Entity Name], Parcel.[First Name] + " " + Parcel.[Last Name])}
I'd also like to control the case in the expression, making whatever data it pulls in upper case (ToUpperCase). Apparently nesting the expressions doesn't work. Any suggestions on the best way to control the case in an expression?
Thanks.
I have the following expression that pulls in data based on the entity name being blank or populated.
{IIF(Parcel.[Entity Name] != string.Empty, Parcel.[Entity Name], Parcel.[First Name] + " " + Parcel.[Last Name])}
I'd also like to control the case in the expression, making whatever data it pulls in upper case (ToUpperCase). Apparently nesting the expressions doesn't work. Any suggestions on the best way to control the case in an expression?
Thanks.