Is it possible to add conditional coloring in report builder?
Hello,
We have a business requirement that we have conditional coloring to our reports. We had this functionality through Cognos, but Report Builder doesn't seem to give us this ability. The fields that we would want conditional formatting for would be percent passed of executed along with percent executed of total for either the test plan or iteration. In 6.0.3 I'm able to pull in those values no problem, however I cannot get conditional formatting in a table for these values. I'm guessing this is an enhancement request, but just wondering if someone knows a way that exists already?
The example would be as follows:
>90%: Make the cell green
80-90%: Make the cell yellow
<70%: Make the cell red
Accepted answer
James,
With the cell/row colorization in 6.0.4 the operators are =, !=, >, >=, <, <=, contains, does not contain, and between. It doesn't work exactly like Insight does when defining conditions, but using "> 90", "between 80-90" and "< 80" you should be able to accomplish what you want.
Comments
BTW, if you have an account on jazz.net you should be able to go to https://jazz.net/rs/reports and see the 6.0.5 dev version of Report Builder and try out this and some of the other newer function.
That did work, thanks for the tip on trying it out on jazz.
We just got dev upgraded to 6.0.4 and the > and < are not shown. Only the other options you talk about Jackie. Were those two operators added with 6.0.5?
2 other answers
JRS added use of colors to highlight data in tables with JRS 6.0.4. Take a look at the release notes details: