Max

version 3

Max (series) Number

Max returns the maximum value in series. If series is an indexed field, the index is used to find the maximum value.

If the series selection is empty, Max returns -1E50.

The following example is an object method for the variable vMax placed in the break 0 portion of the form. The variable is printed at the end of the report. The object method assigns the maximum value of the field to the variable, which is then printed in the last break of the report.

    vMax:= Max ([Employees] Salary)

The following method is called to print the records in the selection and to activate break processing:

   ALL RECORDS ([Employees]) 
   ORDER BY ([Employees];[Employees]LastNm;>) 
   BREAK LEVEL (1) 
   ACCUMULATE ([Employees]Salary) 
   OUTPUT FORM ([Employees];"PrintForm") 
   PRINT SELECTION ([Employees])

Note: The parameter to the BREAK LEVEL command should be equal to the number of breaks in your report. For more information about break processing, refer to the printing commands.

Min.