none
Balance Forward RRS feed

  • Question

  • Hi All

    Hopefully this a quicky. I have a customer statement report where I populate a table, within a list box, of charges and payments. This works fine but we need it to carry the balance over to the additional page. i,e

    Date          Charge          Payment          Balance
    1.jan.09     4999.00         250.50             4744.50
    1.feb.09                         250.50             4494.50
    ............ down the page

    2nd page

    BALANCE CARRIED FORWARD                 3241.5
    Date          Charge          Payment          Balance
    1.Aug.09                        250.50             2991.00

    Is this possible?

    Regards

    Chris Connor


    Monday, November 16, 2009 11:02 AM

All replies

  • It might not be a good way, but try this:
    * add one more column: BalanceCarriedForward
    * hide  (BalanceCarriedForward) column in the report
    * use  =ReportItems!BalanceForwardCell.Text to display balance carried forward amount on each page

    BALANCE CARRIED FORWARD                 0
    Date          Charge          Payment          Balance   (Balance Forward)
    1.jan.09     4999.00         250.50             4744.50     0

    ...

    page 2:

    BALANCE CARRIED FORWARD                 3241.5

    Date          Charge          Payment          Balance   (Balance Forward)
    1.Aug.09                        250.50             2991.00     3241.5


    Hope that helps,
    Long
    Monday, December 7, 2009 9:48 PM