Skip to Content
avatar image
Former Member

Running Cumulative Balance in Crystal Reports

hi all,

this is the continuation of my previous post located at how-to-get-the-cumulative-value-in-crystal-reports,

since i can now get the Opening balance, now my problem is how to get the cumulative account balance, i have tried to do it but no luck.

please help and thanks in advance.

Fidel

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 17, 2011 at 04:30 AM

    Hi Avelino Fidel.

    Account balance current time, you can use CurrTotal feild in table OACT.

    regards

    H2.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Balakumar Viswanathan

      @ Hoe,

      thanks for the response and effort for helping me.

      @ Julie

      thanks for your response,

      @Balakumar

      i have manage to figure out how to achieve my requirement before checking the forum w/ the ff. formulas.

      //Head

      whileprintingrecords;

      if OnFirstRecord then Shared numbervar OB := {Command.Open Balance}

      //Line

      whileprintingrecords;

      shared numbervar OB;

      OB := OB + {BP_AccountBalance;1.Credit} - {BP_AccountBalance;1.Debit}

      //Footer

      whileprintingrecords;

      Shared numbervar OB

      its more or less almost the same with your solution/formula. many thanks for you.

      best regards,

      Fidel

  • avatar image
    Former Member
    Jan 21, 2011 at 08:35 AM

    Have you tried creating a running total field in your report & adding that to your report?

    Add comment
    10|10000 characters needed characters exceeded