Skip to Content

If statement with multiple then not working

I have an IF statement in Crystal syntax that currently works:

I want to add a second THEN to one of the conditional actions.

If this

then that

and that <--add this part

Following the Help documentation in the designer I changed the code to add the second action, but I get an error message:

This makes no sense, but I humor it anyway and get another error:

I'm at a loss. Any help would be appreciated.

Leslie Bryant

Programmer/Analyst

Umpqua Community College

pic3.png (42.2 kB)
pic2.png (39.5 kB)
pic1.png (9.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 21, 2016 at 11:25 PM

    Thanks, Brian. Did I misunderstand the help material?

    Seems like it should work based on this but obviously it won't. I thought maybe I just missed something.

    Leslie

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 21, 2016 at 10:57 PM

    Hi Leslie,

    You're trying to format the result to red if the it returns Over? Don't do it in the formula. Instead, right-click the formula in the report designer and go to Format Object and change the font colour to Red if the formula = "Over".

    Basically, you're using the crRed function incorrectly.

    Good luck,

    Brian

    Add comment
    10|10000 characters needed characters exceeded