Focal Point
COLUMN SPACING

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

November 14, 2007, 05:38 PM
Carlf
COLUMN SPACING
How do you set the amount of blank space between columns? Can you vary it, having some column blanks bigger than others?

thanks,
carl


Carl

FOCUS 7.1.6 on Windows XP
Output: Excel, HTML, PDF
November 14, 2007, 06:00 PM
GinnyJakes
Please look up the SET SPACES setting. However, this does not give you variable spacing. For that you could create dummy fields and make their column titles null.

PRINT FLD1 DUMMY1 AS '' FLD2
.
.
ON TABLE SET SPACES 4
END


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
November 14, 2007, 06:28 PM
Carlf
THANKS


Carl

FOCUS 7.1.6 on Windows XP
Output: Excel, HTML, PDF
November 15, 2007, 08:46 AM
jgelona
Default spacing is 2 spaces. Instead of using dummy fields you can use the following:

TABLE FILE CAR
PRINT CAR
      MODEL IN +1
      BODYTYPE IN +4
   BY COUNTRY
END

This will give 2 spaces between COUNTRY and CAR, 1 space between CAR and MODEL and 4 spaces between MODEL and BODYTYPE.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
November 15, 2007, 09:19 AM
mgrackin
quote:
Originally posted by Carlf:
How do you set the amount of blank space between columns? Can you vary it, having some column blanks bigger than others?


Carl,

What is your output format? HTML or PDF? Is this WebFOCUS or plain old FOCUS output?

When dealing with HTML and PDF output formats, SET SPACES really does not apply anymore. An article I wrote for FocalPoint explains some of this.

http://www.informationbuilders.com/support/developers/htmlpdf.html


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011