Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Crosstab highlight conditioned on a group AND a summary value
Crosstab highlight conditioned on a group AND a summary value [message #1635071] Wed, 25 February 2015 15:58 Go to next message
Michael Pitre is currently offline Michael PitreFriend
Messages: 1
Registered: February 2015
Junior Member
This is my first post, but I'm a long time lurker. I've finally reached a problem in BIRT I can't solve by passive reading of old posts...

I have a crosstab linked to a data cube with two groups and one summary field. I need to highlight the summary field if the value of the summary field is below a certain threshold, and the value of one of group fields meets a certain condition.

In plain language, my crosstab tracks credit scores. I want to highlight the SCORE value in the crosstab under the following conditions:

REPORT_TYPE == "ChoicePoint" && SCORE < 650
REPORT_TYPE == "D&B" && SCORE < 65

I can't seem to make this work in the condition function of the highlight window. I'm attached some screen shots for clarity. Is there a simply solution I'm missing?

Thanks in advance.
  • Attachment: data cube.JPG
    (Size: 24.17KB, Downloaded 141 times)
  • Attachment: crosstab.JPG
    (Size: 28.11KB, Downloaded 154 times)
  • Attachment: highlight.JPG
    (Size: 99.32KB, Downloaded 148 times)
Re: Crosstab highlight conditioned on a group AND a summary value [message #1650119 is a reply to message #1635071] Wed, 04 March 2015 17:27 Go to previous message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
You can use an if statement in the condition builder to check for report type and then specify the Score value to be used with the Less Than condition.

For Example, put the column binding for Score in the first part of the condition and select Less Than for the condition type.
Then in the second part of the condition you can use code like this:
if(REPORT_TYPE == "ChoicePoint"){
}else if(REPORT_TYPE == "D&B"){
Previous Topic:Birt Scripted Data source Json Output
Next Topic:Issues while printing reports using inbuilt birt report print button
Goto Forum:

Current Time: Sun Jul 21 10:06:02 GMT 2024

Powered by FUDForum. Page generated in 0.04164 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top