Total Amount on Each Page

Total Amount on Each Page

Posted by: rwatts on 20 January 2022, 1:45 am EST

• 

  rwatts

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 January 2022, 1:45 am EST

  Hello,

  I have an existing rdlx page report where I need to add a total on each page. The report has a column with money amounts, and at the end of each page I need to put how much of that money column is on the current page. So for example, if you are on page 5 of the report, and you have two amounts with $5.00 each on that page, I would need to print $10 at the end of page 5. Is this possible to do with a page report? I have tried a few different things but haven’t had any luck. I’m using grouping in a table for the report but can switch to something else if it helps accomplish this.

  Thank you!
  
  Richard

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 21 January 2022, 4:01 am EST

  Hi Richard,

  To achieve this behavior please follow the following steps:

  1. Set the Table.RepeatToFill property to true.
  2. Extend the Overflow Place Holder of the table till the bottom of the page.
  3. To show the sum total at the bottom of the page add the Sum() aggregate function in the table footer.

  I have also attached a sample report for your reference.

  To learn more about ActiveReports common functions please refer to the following page of our documentation -
  
  https://www.grapecity.com/activereportsnet/docs/v15/online/common-functions.html

  Invoice_Report_Sample.zip

• 

  rwatts

  • Post Options:
  • Link
    Copy

  Posted 24 January 2022, 6:02 am EST

  Hi Abdias

  Thanks for your help! I tried this but it is giving me a grand total sum of the column from the entire report. I need for it to only give me the amount that is on the current page. So say my table spans 2 pages. At the bottom of each page, I need it to give me the total amount that is for that page only. So if the dollar amount on page 1 totals up to $50, at the bottom of page one it prints $50. Then on page 2, if the dollar amount is $200 for just page 2, it needs to be print $200. Right now it’s printing $250 at the bottom of both page 1 and page 2.

  Thanks!
  
  Richard

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 26 January 2022, 9:50 pm EST

  Hi Richard,

  Sorry for the confusion. If you want to show the sum of the values on the current page only, you would have to get the value from the TextBox.Value and not the fields in a dataset. Please refer the attached sample report on how to do so.
  
  Total_per_Page.zip

• 

  rwatts

  • Post Options:
  • Link
    Copy

  Posted 27 January 2022, 12:33 am EST

  Hi Abdias,

  Thank you so much, that worked perfectly!

  Richard