Script: conditional formating of a lot of cells [message #1819694] |
Tue, 21 January 2020 14:50 |
Christian Kirchmair Messages: 1 Registered: January 2020 Location: Austria |
Junior Member |
|
|
Hello,
my name is Chris and I'm native austrian,
this is my first post/question here.
Beeing quite new to BIRT and reporting in a whole, I hope u might help me.
I have a report that is similar to a Calendar:
1 group row (Person)
1 detail row (labes(month))
12 detail rows (months)
32 detail columns (1 label(month) + 31datacolumns)
My data is mostly 0 and 1
Now i would like to format every cell out of those 31x12 cells.
I managed to format a single cell with:
row["0101"] Equals to 1 -> backgroundColor:Green & Color:green
row["0101"] Equals to 0 -> backgroundColor:inherit from report & Color:inherit (transparent)
but I do not want to do this for 365 Cells in the contextmenu.
So my idea is to get a beforeRenderScript to do the work for me, but I'm not very fluent in js.
It needs to cycle through all the Cells with a '0' or '1' and apply a predefined style accourding to its value.
Do you guys have any idea how to aproach this problem?
I'd like to avoid "trained.monkey.jobs"
any help is highly appreciated
Chris
|
|
|
Powered by
FUDForum. Page generated in 0.03095 seconds