It's all about the answers!

Ask a question

Custom expressions in Jazz Report Builder

Steve Dennehy (4125) | asked Aug 21 '17, 6:20 p.m.

 Three quick questions:

1. Can I build conditional custom expressions in Report Builder? Something like a case statement...
      ELSE 'OK'

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

permanent link
Steve Dennehy (4125) | answered Aug 22 '17, 9:07 p.m.

 To answer bits of this:

1. YES. An example which works:
WHEN ($Requirement:Necessary (Custom)$  = 'Yes') THEN 5
WHEN ($Requirement:Necessary (Custom)$  = 'Acceptable') THEN 2.5
WHEN ($Requirement:Necessary (Custom)$  = 'No, rework') THEN 1
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.
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?

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.