Focal Point
Cell width (resolved)

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

July 23, 2010, 10:30 AM
Ted Michalski
Cell width (resolved)
It seems like the "SIZE" parameter of a report only affects the font size of the data. I want to squeeze the individual cells (they are too wide). How do I do this?

This message has been edited. Last edited by: Ted Michalski,


7.7.02
Windows
EXCEL, PDF, CSV, TEXT
July 23, 2010, 10:44 AM
Tom Flynn
Did you SEARCH on SQUEEZE?

 
-SET &ECHO=ALL;
APP PREPENDPATH IBISAMP
-RUN
SET BYDISPLAY=ON
TABLE FILE SHORT
PRINT PROJECTED_RETURN
BY CONTINENT
BY REGION
BY COUNTRY
BY HOLDER
BY TYPE
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, SQUEEZE=ON,GRID=OFF,FONT='ARIAL',SIZE=9,STYLE=NORMAL,$
-*****************************************
-* Play around with the SQUEEZE value
-*****************************************
TYPE=REPORT, COLUMN=PROJECTED_RETURN, SQUEEZE=.50,$
ENDSTYLE
END
-EXIT



Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
July 25, 2010, 06:14 PM
Waz
Also if you don't want your data truncated, if its larger then the space, then check out WRAP.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

July 26, 2010, 03:36 AM
Tony A
and don't forget WIDTH.

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10