Focal Point
Need to get the value from a file of the highest and lowest value of a filed.

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7101017142

August 13, 2007, 11:51 AM
HCall
Need to get the value from a file of the highest and lowest value of a filed.
I want to use it for a parameter in another report. How can report on the table and get the highest and lowest values in the field?


WF 7.1.6 Platform Windows; Databases Informix, msSQL2000, msSQL2005, Unisys DMSII
Output HTML, EXCEL, PDF
August 13, 2007, 12:03 PM
TexasStingray
Example:

  
TABLE FILE CAR
SUM
MAX.COUNTRY MIN.COUNTRY
ON TABLE SAVE AS SAVE1 FORMAT ALPHA
END
-RUN
-READ SAVE1 &MAXCNTRY.A10. &MINCNTRY.A10.
-TYPE &MAXCNTRY &MINCNTRY
-RUN

TABLE FILE CAR
PRINT COUNTRY CAR MODEL
WHERE COUNTRY EQ '&MAXCNTRY' OR '&MINCNTRY';
END


Hope this helps Cool




Scott