Jump to content
Changes to the Jaspersoft community edition download ×

Pie Chart


mark84

Recommended Posts

I m trying to make a pie chart of phone brands. I have

a sql phone table with say col brand and models. Now i want to show the no phones that each brand has. I have done everything correctly and the chart shows fine but it shows repeadedly in 29 PAGES!!

I just want it to be shown for 1 once on 1 page.
How can i corrent this ?

 

To tell you the details,
Sql query: SELECT brand FROM phone
1 group variable created:
Name: brandgrpValue Expr: $F{brand}

1 varaible created:
Name: total
Class type: java.lang.Integer
Calc Type: Count
Reset Type: brandgrp
Value Expr: $F{brand}

In chart:
Key Expr: $F{brand}
Value Expr: $V{total}

 

Please help.

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...