Calculating accumulate values on group level

[ratjetoes]

hi,

i want to show the accumulate values at group level in the report.

ex. subtotal week 38 100 100
subtotal week 39 25 125

when u drill down on a week u see the orders by day, plus accumulated using a running total. i wanted to use a running total for showing the accumulated subtotals using a formula with evaluate, but i can't get it to work.

formula:

WhilePrintingRecords;
NumberVar Orders;
Orders := Sum ({Command.RunningTotalOrder});

reset is set to never. any idea how to get this working?

ratjetoes.

 

[kenhamady]

If you are adding a running total Field the Evaluate formula needs to be a Boolean, telling CR which records to Evaluate. Something like:

{State} = "CA"

A running total field cannot accumulate subtotals, only detail fields.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[ratjetoes]

got it working useing a formula field.

tnx.