Total Amount on Each Page

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

  • 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
  • Replied 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
  • Replied 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
  • Replied 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
  • Marked as Answer

    Replied 27 January 2022, 12:33 am EST

    Hi Abdias,

    Thank you so much, that worked perfectly!

    Richard
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels