Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

count formula

count formula

count formula

I'm starting to learn the formula's of Crystal Reports. I have version 8 and I can't figure out how to make a specific formula. I have a report grouped by region. Imagine there are 5 organisations in a region. Behind every organisation stands the sales amount of last year. I want to make an field behind that amount that shows the amount of that organisation added to the previous amounts in that group. Example:

Region A

organisation       amount       (this must be my formula)

organisation A     $ 1500       $ 1500     
organisation B     $ 1000       $ 2500
organisation C     $ 2000       $ 4500

Region B


Can you please help me by creating me this formula. I can't figure it out. Thank you,

Robbert van Spronsen.

RE: count formula

I'm not too sure about the crystal syntax, but I think you can do it like this (maybe someone else can verify this...):

numberVar My_variable
My_variable := My_variable + {DB.Field Name}

Hope this helps,

RE: count formula

numberVar My_variable ;
My_variable := My_variable + {DB.Field Name}

Just make sure that you end each line with a semi colon.  You could also use a running total - right click on the field name, and select running total from the popup menu.

Malcolm Wynden
I'm for sale at http://wynden.net

RE: count formula

Thank you all. It worked great, exactly how I wanted it.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close