Although, your sig says you are on 7.1.7, so, you'll have to figure something out, if, that is the actual version you are on.
This also works in 8:
TABLE FILE IBISAMP/CAR
SUM
RETAIL_COST
DEALER_COST
BY COUNTRY
BY CAR
ON TABLE HOLD AS BASEAPP/test_car FORMAT XLSX OPEN
END
-RUN
TABLE FILE IBISAMP/CAR
SUM
RETAIL_COST
DEALER_COST
BY COUNTRY
BY CAR
BY MODEL
ON TABLE HOLD AS baseapp/test_car FORMAT XLSX CLOSE
END
-RUN
EX EDAGET XLSX,baseapp/test_car,b
-EXIT
I'm not sure exactly when it occurred in Version 8 (from the beginning?), but EXL2K and XLSX are now synonyms. Styling commands etc. sometimes work differently there though versus EXL07, so keep your eyes open.
WebFOCUS 7.7.05 (Someday 8) Windows 7, All Outputs In Focus since 1983.
December 21, 2015, 11:03 AM
Kevin W
And of course I got this exactly backwards. EXL07 and XLSX are now synonyms. EXL2K is older (2000)and acts differently.
WebFOCUS 7.7.05 (Someday 8) Windows 7, All Outputs In Focus since 1983.