Simple Groovy expressions not working

[dolm]

I'm trying to build simple charts and I cant seem to get these expressions to work. My data has a field DISPATCH_VALIDITY that has a value of either Valid or Invalid. I need a bar chart that has each center name, with two series (total count) for "Valid" and "Invalid".

My first series is ---

Series expression:

$F{AGENT_CENTER}

Category expression:

$F{AGENT_CENTER}

Value expression:

$F{DISPATCH_VALIDITY} == "Valid"

 

 

This fails with the error:

Error filling print... Error evaluating expression : 
    Source text : $F{DISPATCH_VALIDITY} == "Valid"

 

 

What am I doing wrong? Is there a tutorial somewhere to help with learning Groovy expressions?

 

[dolm]

I figured out part of my problem, I changed Category to $F{DISPATCH_VALIDITY} == "Valid"

And the value expression to $V{REPORT_COUNT} but this gives me two categories with multiple series of True / False

Post Edited by dolm at 05/30/2011 14:00

[dolm]

I figured out my issue but now i need to figure out how to change the color of the bars..anyone know?

 

[dolm]

This is still messed up. My bar chart is showing all centers, with 2 bars for each, showing valid and invalid, but it looks like all lines are scaled to the max value. For example, one center that only has a total of 4 rows in my query result is scaled showing 36 and 6 on the bars values. What gives?