Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
What is the syntax to reference cell value in Expression Builder for Highlights
stinky
A have a Cross Tab that is displaying a list of aggregated values within a detail area.
My desire is to have each cell detail area colored (Highlighted background) depending on the aggregated value that is displayed within the cell of the report.
I have created and assigned a new style for the cell.
The issue is, I cannot figure out the syntax required within the Expression Builder (for the Highlights' definition) to access the cell's value for the condition.
The Expression Builder for the style only provides the following categories:
Report Parameters
Native JavaScript Functions
BIRT Functions
Operators
There does not appear to be any DataSet or similar category to access the cell value of the Cross Tab.
As an example, if the Data Set value is MYNUMBER.
The Cell within the Detail Area of the Cross Tab is listed as Data(MYNUMBER).
I have tried using Data(MYNUMBER) within the Condition, but it is not recognized.
Ie. Condition of "DATA(MYNUMBER) Greater Than 5000" then configure the background color to red.
Have also tried...
MYNUMBER
row.MYNUMBER
new Number(MYNUMBER)
dataSetRow["MYNUMBER"]
This.valueOf()
valueOf()
Is there some other type of binding, and/or syntax that I need to do to accomplish the highlighting of the detailed cell of the report?
The BIRT documentation is quite good and extensive, but I have been unable to find where it goes to this level of detail on the Expression Builder.
Find more posts tagged with
Comments
stinky
Actuate support researched and provided a response.
When you open your report in my BIRT 10SP1 (or later) you can see 'Available Column Bindings' in the Highlights expression builder.
When you choose your column, you would get something like...
data["SAMPLE_KPI_Group/Element_Group"]
My BIRT was not at 10SP1, so even though the "Available Column Bindings" was not listed as an option, I was able to manually enter the syntax which was recognized and processed as expected by the iServer.
A thank you and shoutout to Trevor Huston with Actuate support for the assistance.
Greatly appreciated.
micahel