title: Jasper iReport Variables Expression condition for char
body: <p>I have a column in my database, which is the ColorCode column (Field name $F{COLORCODE} )  that has values like 'B' and 'R' and 'G', I want to count the amount of them respectively to their color.</p>
  
  <p>So I have variables called countBlue, the variables expression is $F{COLORCODE}=='B' and put it in the Column Footer but the report counted everything including the R and G in that column, did I do the comparison statement wrongly?</p>
  
  <p>also I have set up my countBlue variable class to java.lang.Integer, calculation as Count and reset type as Report</p>
  
  <p>p/s sorry for bad english</p>