Need Assistance Using Crystal 9

[WinterDragon]

I have a report that brings in the Item data for a date range, Sorted by Company name and ID, Summarizes the items and gives me a total number of each unit. Then it takes that number and multiples by the unit cost for a Line total for that item.. Where I am getting hung up is now I need a Grand Total at the end of that section for the total for that company.

Formulas are as follows:
RTotal4 - Thats the summary Number of the Items
@Amount - Thats the RTotal4 times the unit cost
GrandTotal - this would be the Total for that compamny (IF I could get it to work)

I tried Summarizing @Amount and Crystal Says NO WAY..

Please help...
Winterdragon

 

[RealityCheque]

Try setting up a running total of @Amount, if you have multiple companies you are reporting on don't forget to reset the total after each one!

Simon

"I do not have to forgive my enemies. I have had them all shot."
- Ramon Maria Narvaez

 

[WinterDragon]

When I try to do a running total on @Amount, Crystal kicks back and says that it cant summarize that field

 

[WinterDragon]

If I try creating a New Running Total, the @amount isnt listed in the available fields. When I browse the data, the field shows as empty.

 

[lbass]

I'm assuming you have a group on company and on unit, and that you are calculating {@amount} at the GF#2 (Unit) level. Then create three formulas:

//{@reset} to be placed in the GH#1 (company) header:
whileprintingrecords;
numbervar sumamt := 0;

//{@accum} to be placed in the GF#2 (unit) footer:
whileprintingrecords;
numbervar sumamt := sumamt + {@amount};

//{@display} to be placed in the GF#1 (company) footer:
whileprintingrecords;
numbervar sumamt;

-LB

 

[WinterDragon]

Yes!! that works... Thank You so Much. Ive been pulling my hair out for 2 days now. Now Is there a way to hide that running total and the reset on the side (The @Accum and the @Reset fields)? Would Prefer to have Just the total at the bottom of the section.

 

[lbass]

Right click on each formula->format field->common->check "Suppress".

-LB

 

[WinterDragon]

MANY, MANY, MANY Thanks to you and your knowledge. With your help I am now able to send this report up to the accountant and get them off my Back...


Thank You for you help,
Winterdragon