Jump to content
Changes to the Jaspersoft community edition download ×

Jasper creating several identical pages


Recommended Posts

I have a simple table containing user poll statistics, i.e user age, gender and category. From this I am producing several reports as charts.


The problem is that the report generates xx pages with identical (correct) values. There should be only one page. It seems the number of pages returned is equivalent with the number of rows returned by the query.


For the gender report the query looks like this:

select v.label as gender, count(*) as genderCount from userpoll u, lookupvalue v

where v.category = 'userpollgender' and v.value =

group by u.userPollGender


The pie chart has

key expression = $F{gender}

value expressione = $F{genderCount}

and value expresion = $F{gender}


What am I doing wrong here? I tried using a report group instead of my group by plus a report variable, and got correct charts this time too, but now instead 18 identical pages. There are 18 rows in my userpoll table.


The same problem goes for the other reports as well, mosts are pie charts but one is a line diagram. Showing usage statistics per category ofer months. Same problem. Identical graphs on xx pages.


Any help much appreciated!



Post edited by: barsk, at: 2007/12/05 12:30

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic



Yes indeed! That solved it!

Thank you very very much! I've spent several hours on this issue as a newbie to Jaspereports. Could not believe such a great tool was so flawed. And it wasn't!






Link to comment
Share on other sites

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...