[Bar Chart Lable Format]

Hi

 

I have a bar chart. that uses the expression

 

New Double( $F{TOTAL02}.doubleValue() / $F{GRANDTOTAL}.doubleValue() * 100.0)

 

to get the values of each column shown as a % of the total. However the value returned is to 3 decimal places where I only want to display to 1.

 

I tried the mask values but with no luck

 

Any ideas how I can go about this?

[frequency Dristibution]

Hi Lilly

 

I had someone write the SQL to do the work for me, it worked out easier in the end. If you need a sample of the SQL let me know.

[frequency Dristibution]

is it posible is it to create a frequency distribution graph from a database with several thousand values and 30 'bins' using ireports. At a high level what would be thebest approach.

 

many thanks