Jump to content
Changes to the Jaspersoft community edition download ×

Summary fields for group


UlrichB

Recommended Posts

Hallo,
I have used the reports wizard and created a grouped report.
. Now I want to add two summary fields to each group: Average(TTD) and Maximum(TTD). Can anybody tell me how this can be done? Or provide a link where I can read about it?
Kind regards - Ulrich
Post edited by: UlrichB, at: 2006/10/31 13:25

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

You have to create a variable for each one calculation and for each group. If for example you have group1 and group2 you need to create AVERAGE_TTD_GROUP1,AVERAGE_TTD_GROUP2,MAXIMUM_GROUP1, MAXIMUM GROUP2.

 

Configuration of AVERAGE_TTD_GROUP1

 

Variable name: AVERAGE_TTD_GROUP1

type: the same of the field with the value;

Calculation type : choose one of them. If you want for example to calculate the average choose average.

Reset type : choose group

Reset group : choose the group. If you have created 2 groups, you need to create 2 variables.

Variable expression : put the field on which you want to create the variable F{TTD}

 

Then click ok and drug and drop the variable in the group1_footer

 

Then make the same process for the average of group2 in order to create a variable AVERAGAE_TTD_GROUP2

 

For the maximun select in calculation tupe instead of average HIGHEST.

 

Bye

dpinfo

Link to comment
Share on other sites

Hallo dpinfo,

this worked fine - thank you for your support. Now I have some problem quite trivial: I want to label these variables. I choosed "Static Text" from the toolbar und dragged a rectangle. But when I click that rectangle to enter a text it disappears?

Kind regards - Ulrich

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