Custom expressions in Jazz Report Builder
Three quick questions:
1. Can I build conditional custom expressions in Report Builder? Something like a case statement...
CASE
WHEN (T7.LITERAL_NAME IS NULL) THEN 'ERROR'
ELSE 'OK'
END TEST_RESULT_VALIDITY
2. Can I use multiple arguments in custom expressions in Report Builder?
3. Can I use colors with the result of a custom coded SQL column? I added a case statement which considers multiple arguments in the Advanced bit, but when I try to add color I just get errors. Am I doing something wrong?
One answer
To answer bits of this:
1. YES. An example which works:
CASE
WHEN ($Requirement:Necessary (Custom)$ = 'Yes') THEN 5WHEN ($Requirement:Necessary (Custom)$ = 'Acceptable') THEN 2.5WHEN ($Requirement:Necessary (Custom)$ = 'No, rework') THEN 1
ELSE 0
2. NO. I havn't been able to find a way to do this other than manual editing of the SQL query using the Advanced tab.END
3. NO. This does however work for columns which are computed by the custom expression builder, but not for ones computed using expressions entered manually in the Advanced tab.
Unless somebody has additional input?