TABLE FILE GGSALES PRINT DOLLARS BY REGION BY ST BY STCD BY HIGHEST DOLLARS NOPRINT WHERE DATE FROM 19960101 TO 19961231 ON TABLE SET EXPANDABLE ON ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * ENDSTYLE END -RUN
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
TABLE FILE GGSALES SUM COMPUTE SRT_DOLLARS/D12.2c = DOLLARS; AS DOLLARS BY REGION BY ST BY CITY BY STCD BY HIGHEST TOTAL SRT_DOLLARS NOPRINT BY DATE WHERE DATE FROM 19960101 TO 19961231 ON TABLE SET HOLDLIST PRINTONLY ON TABLE SET ASNAMES ON ON TABLE HOLD AS TEMPHLD1 END -RUN TABLE FILE TEMPHLD1 PRINT DATE DOLLARS BY REGION BY ST BY CITY BY STCD ON TABLE SET EXPANDABLE ON ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * ENDSTYLE END -RUN
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
TABLE FILE HOLD SUM D AS DTOTAL BY A BY B BY C PRINT E F D BY A BY B BY C BY HIGHEST E ON TABLE HOLD AS SWES END -RUN TABLE FILE SWES PRINT E AS '' F AS '' D AS '' BY A AS '' BY B AS '' BY C AS '' ON TABLE SET EXPANDABLE ON ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * ENDSTYLE END -RUN
TABLE FILE HOLD SUM D AS DTOTAL BY A BY B BY C PRINT E F D BY A BY B BY C BY HIGHEST E ON TABLE HOLD AS SWES END -RUN TABLE FILE SWES PRINT E AS '' F AS '' D AS '' BY A AS '' BY HIGHEST DTOTAL NOPRINT BY B AS '' BY C AS '' ON TABLE SET EXPANDABLE ON ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * ENDSTYLE END -RUN
SET ASNAMES = ON SET HOLDLIST = PRINTONLY TABLE FILE GGSALES SUM DOLLARS AS DTOTAL BY REGION AS A BY ST AS B BY DATE AS C SUM BUDDOLLARS AS E UNITS AS F DOLLARS AS D BY REGION AS A BY ST AS B BY DATE AS C BY HIGHEST BUDDOLLARS NOPRINT WHERE DATE FROM 19960101 TO 19960331 ON TABLE SET HOLDLIST PRINTONLY ON TABLE SET ASNAMES ON ON TABLE HOLD AS SWES END -RUN TABLE FILE SWES PRINT E AS '' F AS '' D AS '' BY A AS '' BY HIGHEST DTOTAL NOPRINT BY B AS '' BY C AS '' ON TABLE SET EXPANDABLE ON ON TABLE SET PAGE NOLEAD ON TABLE SET STYLE * ENDSTYLE END -RUN
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |