TABLE FILE CAR PRINT SEATS DEALER_COST RETAIL_COST BY COUNTRY BY CAR BY BODYTYPE END -EXIT
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 |
quote:TABLE FILE CAR
SEATS
DEALER_COST
RETAIL_COST
BY COUNTRY
BY CAR
BY BODYTYPE
END
-EXIT
TABLE FILE CAR PRINT SEATS DEALER_COST RETAIL_COST BY COUNTRY BY CAR BY BODYTYPE ON TABLE HOLD END -RUN DEFINE FILE HOLD NEWCONT/A10 = IF CAR EQ LAST CAR THEN '' ELSE COUNTRY; NEWCAR/A16 = IF CAR EQ LAST CAR THEN '' ELSE CAR; END TABLE FILE HOLD PRINT NEWCONT AS COUNTRY NEWCAR AS CAR BODYTYPE SEATS DEALER_COST RETAIL_COST BY COUNTRY NOPRINT BY CAR NOPRINT BY BODYTYPE NOPRINT END -RUN
TABLE FILE CAR PRINT SEATS DEALER_COST RETAIL_COST BY COUNTRY NOPRINT BY CAR BY COUNTRY BY BODYTYPE ON TABLE SET PAGE-NUM NOLEAD ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * UNITS=IN,PAGESIZE='Letter',LEFTMARGIN=0.250000,RIGHTMARGIN=0.250000,TOPMARGIN=0.250000,BOTTOMMARGIN=0.250000,SQUEEZE=ON,ORIENTATION=LANDSCAPE,$ TYPE=REPORT,FONT='ARIAL',SIZE=8,COLOR='BLACK',STYLE=NORMAL,LEFTGAP=0.05,RIGHTGAP=0.05,BORDER=LIGHT,$ TYPE=REPORT,COLUMN=N3,SEQUENCE=1,$ ENDSTYLE END -RUN
DEFINE FILE CAR COUNTRY_CAR/A26 = COUNTRY || CAR; END TABLE FILE CAR PRINT SEATS DEALER_COST RETAIL_COST BY COUNTRY_CAR NOPRINT BY COUNTRY BY CAR BY BODYTYPE END
quote:but there is a setting to switch them.
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |
TABLE FILE CAR PRINT DEALER_COST BY COUNTRY NOPRINT BY CAR BY COUNTRY ON TABLE SET STYLE * TYPE=REPORT, COLUMN=COUNTRY,SEQUENCE=1, $ TYPE=REPORT, COLUMN=CAR, SEQUENCE=2, $ ENDSTYLE END