Eclipse Community Forums: BIRT » Crosstab highlight conditioned on a group AND a summary value

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 10:58

Eclipse User

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 162 times)
Attachment: crosstab.JPG
(Size: 28.11KB, Downloaded 171 times)
Attachment: highlight.JPG
(Size: 99.32KB, Downloaded 163 times)

Re: Crosstab highlight conditioned on a group AND a summary value [message #1650119 is a reply to message #1635071]

Wed, 04 March 2015 12:27

Eclipse User

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"){
650;
}else if(REPORT_TYPE == "D&B"){
65;
}

Previous Topic:	Birt Scripted Data source Json Output
Next Topic:	Issues while printing reports using inbuilt birt report print button

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Mar 23 07:07:20 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter