Conditional border formatting in cross-tab?

I would like to dynamically set cell border properties in cross-tab, based on cell content.

For example: if cell value is negative - set border colour to red, or if cell value exceeds a limit - set cell border lines to thick yellow, or if cell value is null - remove border lines. A bit similar to conditional formatting in Excel... I saw highlighting function in BIRT, but there is no option to control frames.

This should be possible in BIRT with Java Script, but I could not find any working example

. I guess the code could be executed from conditional expression attached to cell.

Is this something feasible or I am trying to re-invent the wheel?

Find more posts tagged with

Comments

mwilliams

Sorry this question got missed. Did you ever find a solution?

mlb

Not really in the way I need. One can play with colours via standard conditional formatting, but you cannot remove the frame completely. I tried to hide values from a cell - still, a frame surrounding the cell is visible...

mwilliams

There is a standard style applied for crosstabs. You can remove this by going to the style section of the outline and deleting the crosstab cell style. The only styling done is the border. Now, when you include no conditional style, it will have no border. Hope this helps. Let me know if you need a sample.

maymay

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="108649" data-time="1345479519" data-date="20 August 2012 - 09:18 AM"><p>
There is a standard style applied for crosstabs. You can remove this by going to the style section of the outline and deleting the crosstab cell style. The only styling done is the border. Now, when you include no conditional style, it will have no border. Hope this helps. Let me know if you need a sample.<br /></p></blockquote>
<br />
Hi, I am facing the same problem. Can you provide a sample?

mwilliams

What is your BIRT version?