Getting a Grand Total on fields that don't exist in detail section. 1

[Ruairi]

I have a formula in a report (CR 8.5) that uses other formulas 'FACTOR' and 'LVAL' Which are derived in the group footer #1 section. Here is the formula:

{@LVAL} + ({invoice.miscellaneous_charges} + {invoice.sales_tax} + {invoice.freight}) * {@factor}

The report comes from a join on 2 main tables (invoice and boldtl. An invoice can have many related boldtl rows) which are linked to each other via a third table. The only fields in this linking table are an identity column, a foreign key to invoice, and a foreign key to boldtl. The Group 1 section changes on {invoice.rec}, so it changes for each invoice. The detail section contains the boldtl fields and some formulas to make volume, value, etc.. calculations from the boldtl data. The {@LVAL} formula used in the above formula is also in the Group #1 footer, it is either the sum of the value calculations from the boldtl records(detail section, never displayed in the report) or a value from the invoice record, if a field in the invoice record is set to a given value. The {@factor} formula used in the above formula is a factor derived from dividing the calculated total volume from the bodltl records in the detail section by a value in the invoice record. Sorry about the long post. If anyone has any ideas of a way i could get a simple total of the posted formula over the whole report i would appreciate it. Crystal won't allow me to create a summary field on this formula (all the menu options are greyed out), it won't let me create a running total on it (not in the available tables/fields list). If i try to create a formula in the report footer using Sum(,) on the formula with {invoice.rec} as the condfield i get a message box saying 'The running total can't be created'. Thanks,

Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontro

 

[MalcolmW]

I think this is what you want - replace your formula with
WhilePrintingRecords ;
NumberVar ReportTotal ;
NumberVar SubTotal ;
SubTotal := {@LVAL} + ({invoice.miscellaneous_charges} + {invoice.sales_tax} + {invoice.freight}) * {@factor}
ReportTotal := ReportTotal + SubTotal ;
SubTotal ;

And create another formula for the Report Footer to show the result...
WhilePrintingRecords ;
NumberVar ReportTotal Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[Ruairi]

Thanks Malcom, that was exactly what i needed. You just saved me many more hours of pulling my hair out. Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontro