Conditional Statements In Report Designer

Hey all,

Can someone explain to me what I’m doing wrong with the following conditional statement in the report designer? I swear it worked for 5 minutes and now I can’t get it to work at all and I’m not sure why.




Here is the code in case it’s too hard to see in the picture:

@Priority=="0"?"Low":Priority=="1"?"Medium":Priority=="2"?"High":Priority=="3"?"Critical"@

And yes, the priority key is a string and not an integer.

1 Like

I copied and pasted your code in my report designer and tried it out and it worked. Maybe your row is somehow not getting the expression because the expression works.

Thanks Nick, I did figure out what was wrong I just forgot to post the follow up.

I had it set up with a table row version key to change to different style rows based on basically the same expression. I didn’t know I had to have that expression on that column for every row version.

Once I figured that out I simplified it greatly by just hard coding my values into that column on each row version. Thanks for the help!

Cool, thanks for the follow up.