-SET &ONorOFF = OFF ; SET DROPBLNKLINE = &ONorOFF -RUN TABLE FILE CAR SUM DCOST BY MODEL ACROSS COUNTRY "SET DROPBLNKLINE = &ONorOFF.EVAL" ON TABLE PCHOLD FORMAT XLSX AS 'DROP_&ONorOFF.EVAL' END
SET DROPBLNKLINE = OFF COUNTRY ENGLAND FRANCE ITALY JAPAN W GERMANY MODEL 100 LS 2 DOOR AUTO . . . . 5,063 2000 4 DOOR BERLINA . . 4,915 . . 2000 GT VELOCE . . 5,660 . . 2000 SPIDER VELOCE . . 5,660 . . 2002 2 DOOR . . . . 5,800 2002 2 DOOR AUTO . . . . 6,000 3.0 SI 4 DOOR . . . . 10,000 3.0 SI 4 DOOR AUTO . . . . 11,000 504 4 DOOR . 4,631 . . . 530I 4 DOOR . . . . 8,300 530I 4 DOOR AUTO . . . . 8,400 B210 2 DOOR AUTO . . . 2,626 . COROLLA 4 DOOR DIX AUTO . . . 2,886 . DORA 2 DOOR . . 25,000 . . INTERCEPTOR III 14,940 . . . . TR7 4,292 . . . . V12XKE AUTO 7,427 . . . . XJ12L AUTO 11,194 . . . .This message has been edited. Last edited by: Doug,
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |
SET ACROSSTITLE = SIDE SET PAGE = NOLEAD -RUN TABLE FILE CAR SUM DCOST BY CAR AS '' BY MODEL AS '' ACROSS COUNTRY AS 'Car, Model / Countries' "This is using: 'SET ACROSSTITLE = SIDE'" -*ON TABLE PCHOLD FORMAT XLSX AS 'DROP_ACROSSTITLE_SIDE' ENDWorks as expected. However, how can we do that with associated Column Titles for my By Fields? I guess it may be a NFR such as DROPBYACROSSBLANKLINE...
SET EMPTYREPORT = ON SET ACROSSTITLE = SIDE SET PAGE = NOLEAD TABLE FILE GGSALES SUM DOLLARS BY LOWEST 2 CITY BY CATEGORY ACROSS HIGHEST 3 DATE AS '' WHERE CITY GE 'New York' WHERE DATE GE 19971001 ON TABLE PCHOLD FORMAT XLSX END
SET ACROSSTITLE = SIDE SET PAGE = NOLEAD TABLE FILE GGSALES SUM DOLLARS AS '' BY LOWEST 2 CITY AS '' BY CATEGORY AS '' ACROSS HIGHEST 3 DATE AS 'CITY / CATEGORY' WHERE CITY GE 'New York' WHERE DATE GE 19971001 ON TABLE PCHOLD FORMAT XLSX END
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |
TABLE FILE GGSALES SUM DOLLARS BY LOWEST 2 CITY NOPRINT BY CATEGORY NOPRINT ACROSS HIGHEST 3 DATE AS '' COMPUTE XCITY1/A70 = CITY ; AS 'CITY 1' COMPUTE XCITY2/A70 = CITY ; AS 'CITY 2' COMPUTE XCATEGORY/A70 = CATEGORY ; AS 'CATEGORY' WHERE CITY GE 'New York' WHERE DATE GE 19971001 ON TABLE PCHOLD FORMAT XLSX ON TABLE SET STYLE * TYPE=REPORT, COLUMN=XCITY1, SEQUENCE=1, $ TYPE=REPORT, COLUMN=XCITY2, SEQUENCE=2, $ TYPE=REPORT, COLUMN=XCATEGORY, SEQUENCE=3, $ ENDSTYLE END
quote:Originally posted by Doug:
Thanks Pku, I've not yet tried that. But I will. I used another one, from Walter Walter Brengel, as a work-around that prompted my NFR.
SET PAGE-NUM = OFF TABLE FILE GGSALES SUM DOLLARS AS '' BY LOWEST 2 CITY NOPRINT BY CATEGORY NOPRINT ACROSS HIGHEST 3 DATE AS '' COMPUTE XCITY1/A70 = CITY ; AS 'City' COMPUTE XCATEGORY/A70 = CATEGORY ; AS 'Category' WHERE CITY GE 'New York' WHERE DATE GE 19971001 ON TABLE PCHOLD FORMAT XLSX ON TABLE SET STYLE * TYPE=REPORT, COLUMN=XCITY1, SEQUENCE=1, $ TYPE=REPORT, COLUMN=XCATEGORY, SEQUENCE=2, $ ENDSTYLE END -RUN
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206 |
DEFINE FILE GGSALES MYDATE/A10=FPRINT(DATE,'I8YYMD','A10'); END TABLE FILE GGSALES SUM DOLLARS AS ' ' BY LOWEST 2 CITY BY CATEGORY ACROSS HIGHEST 3 MYDATE AS '' WHERE CITY GE 'New York' WHERE DATE GE 19971001 ON TABLE HOLD AS HOLDGGS ON TABLE SET ASNAMES ON ON TABLE SET HOLDLIST PRINTONLY END TABLE FILE HOLDGGS PRINT * ON TABLE SET PAGE NOLEAD ON TABLE PCHOLD FORMAT XLSX END