How Can I get Summary of a summarize field ???

[dreman]

Using CR 8.5:
OK i have a report that has 2 groups, customers and orders.
I have a formula in detail section to calculate some numbers. I summarize the formula and the result is in group footer#1. so far so good.
Then anohter formula to carry the summarize formula above to add to another integer field in the group footer#1. So far so good.
But when I tried to the total in the group footer#2 it will not allow me. It will not allow me to have a total or running total on a summary field. Is there a way around it.
Please help.
Thank you.
dré

 

[synapsevampire]

Perhaps a Running Total with the same conditions under Evaluate->Use a formula will work.

Hard to say without some specifics.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[kenhamady]

If you are trying to total a total (or a field that uses a total) you will need a running total field using the 3-Formula technique described in faq149-182. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[dreman]

Ken & synapsevampire:
thanks for your help as always.
The original formula placed in the group footer is:
//Begin formula
Local NumberVar Int_qty:= {@sum_of_qty_ship};
if {table.qty_ordered} =>Int_qty and Int_qty <> 0 then
1
Else
0
//end of formula
// {@sum_of_qty_ship} is a summary of qty in detail section
// + table.master_qty_shipped + table.master_qty_picked
I realized the following:
with this formula in the group footer as is I cannot get a summary nor a running total.
HOWEVER if I replace {@sum_of_qty_ship} with an actual value or a table value (integer) it will work.
I seems that Crystal report 8.5 does not like the summation inside the formula.
I will try your suggestions and will let you know.
Thank you.
dré