Crystal Report 11 - Keeping a value in a report

[nbay001]

Hi all,

I have a report that lists multiple machines. The machines contain a single value (lineal feet output).

Out of the multiple machines in my report I want to capture "Lineal Feet" output of just one and save it to the bottom of the report to do calculations.

I am assuming I will need a variable for this? In this case, the Machine = "35" and the value is 19500 lineal feet.

Thanks so much in advance.

P.Park

 

[kenhamady]

Write a formula called {@Feet35} that says:

If Machine = "35"
then {YourField.forLinealFeet}
else 0

Then you can refer to this value in any other formula by saying:

Maximum ({@Feet35})

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/