Can't create Running Total..formula not visible.

[jpstrzoch]

I have created a report which captures the cost of Orders, Lines, and Units, grouped first by Client, then by Order Type. I have successfully created separate formulas that identify the unique Orders, Lines, and Units multiplier. The multiplier is unique to each Client.

I am using running totals to capture the total Orders, total Lines, and total Units, each is a separate running total. I incorporate each of those running totals in a separate formula multiplying them by the Orders, Lines and Units multiplier. This is working and allows me to see total costs at the Type group level.

{#Total Orders for Order Type Summary}*{@Orders Multiplier}

{#Total Lines of Order Type Summary}*{@Lines Multiplier}

{#Total Units for Order Type Summary}*{@Units Multiplier}

I am unable calculate a Running Total at either the Client group level, totaling the individual results at the Type group level, or in the report footer for all Clients. This is because the formulas are not visible in the list when trying to create a Running Total for each.

I have labored over this for so long can you help me?

 

[HowardHammerman]

You will probably have to create a "manual running total". Check the FAQs for some steps to do this.

Howard Hammerman,
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[lbass]

To make it easy for you...create these formulas:

//{@reset} to be placed in the (client) group #1 header adn suppressed:
whileprintingrecords;
numbervar clientorders := 0;
numbervar clientlines := 0;
numbervar clientunits := 0;

//{@accum} to be placed in the group #2 footer and suppressed:
whileprintingrecords;
numbervar clientorders := clientorders + {@Orders};
numbervar clientlines := clientlines + {@Lines};
numbervar clientunits := clientunits + {@Units};

//where {@Orders},{@Lines}, and {@Units} are the names of your formulas above.

Then create three separate display formulas to be placed in the Client Group #1 footer:

whileprintingrecords;
numbervar clientorders;

whileprintingrecords;
numbervar clientlines;

whileprintingrecords;
numbervar clientunits;

-LB