Running Total(SUM) on a condition formula for each group

[kpiljava]

My Problem Actually is that I am running a total or summary u can say for each group .
Let each group contains hundred records falling under different dates .I want to get totals of periods .So what i am doing is i am running a total of the given field with a break as group and evaluating condition as Date>0 and Date<30 (like this).If there are records falling under the date in condition then total is coming fine but if there are no records then total is not displayed at all..it is coming as a blank.I want it to come as 0 atleast when there are no records.Can Anyone solve this.

 

[dgillz]

Insert, fieldm object, running total field.

You have explained what you want perfectly, and if you follow your own logic, it will be very easy from here to create what you want. Give this a try and post again is you have any issues. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[kenhamady]

(Try to post your follow-ups in one thread. )

Running totals will sometimes print blanks if no records meet the condition. I prefer to do it this way:

Write a formula that is:
If {Date} in <your range>
then <field to sum>
else 0

Then you can subtotal or grand total this formula, and you will get zero instead of blank. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com