Jump to content
We've recently updated our Privacy Statement, available here ×

How to create subtotal of a column in the Table per page


ball_stone

Recommended Posts

Dear forum members,

I have a problem with table resulting subtotal of a column per page. I want to get a subtotal of, for example, a column of SALARY at the end of each page. I put the subtotal on the column footer in Table and the Table is in Detail band. I am using iReport Designer 5.1.0

I created a variable called "SumSalaryPerPage" and its properties are as follows 1. Calculation: Sum,  2. Reset type: Page,  3. Variable Expression: $F{SALARY},  4. Variable Class: java.lang.Double,  5. Increament Type: None. I put this variable on the column footer in the Table.

After that, I tried to do Preview but it shows a problem saying that "Variable SumSalaryPerPage of dataset Table Dataset 1 cannot have Column or Page reset type" 

Is there any solution to solve this problem? Any suggestions will be great. Have a nice day!!! 

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

  • 10 months later...

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