In Crystal Reports 11 is it possible to use startswith in a Select Case statement?
Please reference the following code:
//Purpose: Get semester 1 grade
IF TRIM(UPPERCASE({semester})
)
startswith "S1"
Then {semester-grade}
ELSE
IF TRIM(UPPERCASE({semester})
)
like "S1"
Then {semester-grade}
ELSE
IF TRIM(UPPERCASE({semester})
)
like "S 1"
Then {semester-grade}
IF TRIM(UPPERCASE({semester})
)
like "SEM 1"
Then {semester-grade}
ELSE
""
I'd like to use something like this:
SELECT TRIM(UPPERCASE({semester})
)
CASE "SEM 1", "S1", "S 1":
{semester-grade}
DEFAULT:
"";
Can I add something like startswith "S1" in the select statement?
Thanks in advance!
Start Free Trial
