Focal Point
[SOLVED] Add Dummy Column in EXL2k

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7231081103

October 01, 2008, 11:24 AM
Tomsweb
[SOLVED] Add Dummy Column in EXL2k
I created a little CAR report to play around with some report layout ideas.

[
TABLE FILE CAR
PRINT CAR
BY COUNTRY
IF COUNTRY EQ 'ENGLAND' OR 'ITALY' OR 'JAPAN';
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN
]
COUNTRY CAR
ENGLAND JAGUAR
JENSEN
TRIUMPH
ITALY ALFA ROMEO
MASERATI
JAPAN DATSUN
TOYOTA

Now, I want to add a blank column to space out the width of the report.

I tried to add a defined field (DUMMY/A15) and it does not work.

[
DEFINE FILE CAR
DUMMY/A15 = ' etc.';
END
-*
TABLE FILE CAR
PRINT
DUMMY
CAR
BY COUNTRY
IF COUNTRY EQ 'ENGLAND' OR 'ITALY' OR 'JAPAN';
ON TABLE PCHOLD FORMAT EXL2K
END
-RUN
]

Any ideas? Cool

This message has been edited. Last edited by: Kerry,


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
October 01, 2008, 11:30 AM
Tomsweb
Problem is RESOLVED....

Sorry!


Tomsweb
WebFOCUS 8.1.05M, 8.2.x
APP Studio, Developer Studio, InfoAssist, Dashboards, charts & reports
Apache Tomcat/8.0.36
October 01, 2008, 11:35 AM
GinnyJakes
Can you put [SOLVED] in the title and tell us what the answer is?


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google