August 13, 2007, 11:51 AM
HCallNeed 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?
August 13, 2007, 12:03 PM
TexasStingrayExample:
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