TABLE FILE WHATEVER PRINT DEPT VAL RANKED BY VAL ON TABLE HOLD END TABLE FILE HOLD PRINT DEPT VAL RANK BY RANK NOPRINT BY DEPT NOPRINT END
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
TABLE FILE Fn PRINT DEPT RANKED BY VAL ON TABLE SET STYLE * TYPE=REPORT,COLUMN=N2,SEQUENCE=1,$ TYPE=REPORT,COLUMN=N3,SEQUENCE=2,$ TYPE=REPORT,COLUMN=N1,SEQUENCE=3,$ ENDSTYLE END
TABLE FILE CAR PRINT CAR RETAIL_COST AND COMPUTE ROWNUM/I9 = LAST ROWNUM + 1; BY HIGHEST RETAIL_COST NOPRINT ON TABLE HOLD END -RUN TABLE FILE HOLD PRINT CAR RETAIL_COST AND COMPUTE MYRANK/I9 = IF RETAIL_COST EQ LAST RETAIL_COST THEN LAST MYRANK ELSE ROWNUM; AS 'RANK' END
quote:ON TABLE SET STYLE * TYPE=REPORT,COLUMN=N2,SEQUENCE=1,$ TYPE=REPORT,COLUMN=N3,SEQUENCE=2,$ TYPE=REPORT,COLUMN=N1,SEQUENCE=3,$ ENDSTYLE
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
Frank | |
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7 |
TABLE FILE TNAME PRINT COMPUTE RANKNUM/I6 = RANKNUM + 1; NOPRINT DEPT VAL COMPUTE RANK/I6 = IF VAL EQ LAST VAL THEN LAST RANK ELSE RANKNUM; BY HIGHEST VAL NOPRINT ENDThis message has been edited. Last edited by: Leo L,