May 31, 2007, 07:56 AM
Pam Krattexl2k shrinking of columns
We had a weird problem appear where the exl2k report displayed fine on the screen but when they went to print or do a print preview, the amount column displayed ##### (for the very large numbers) instead of the amount and the time date stamp field only printed the date (no time). I fixed this by decreasing the font (or at least it appears to be fixed). I'm now trying to shrink (basically fit to size) some of the other fields so that everything will print on a landscape page. If I double click on the line separating the columns in exl2k, it does shrink the column so there is space to be removed. My customer does not want to manually have to click on the lines in exl2k. I've tried changing squeeze=on and playing with the width but nothing seems to shrink the columns in exl2k (the colors are changing so I am selecting the right fields). Any thoughts?
TYPE=REPORT,
COLUMN=TRANTYPE,
WIDTH=.3,
COLOR=RED,
$
TYPE=DATA,
COLUMN=XFROM_CASH_TYPE,
WIDTH=.3,
COLOR=BLUE,
$
Also, was there another way to fix the print preview problem without shrinking the font size? We have a standard to use the same size on all reports, so I'm deviating from that standard to fix the printing problem.
May 31, 2007, 09:27 AM
mgrackinPam,
You were close but your are using the wrong keyword. WIDTH is used for HEADING, SUBHEAD, SUBFOOT and FOOTING contents. To control the width of a column in the report, SQUEEZE or WRAP should be used.
Here's an example using the CAR file.
TABLE FILE CAR
SUM RCOST DCOST SALES
BY COUNTRY
BY CAR
BY MODEL
BY BODYTYPE
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, COLUMN=COUNTRY, WRAP=1.0,$
TYPE=REPORT, COLUMN=CAR, WRAP=1.0,$
TYPE=REPORT, COLUMN=MODEL, WRAP=1.5,$
TYPE=REPORT, COLUMN=BODYTYPE, WRAP=1.5,$
TYPE=REPORT, COLUMN=RCOST, WRAP=1.0,$
TYPE=REPORT, COLUMN=DCOST, WRAP=1.0,$
TYPE=REPORT, COLUMN=SALES, WRAP=1.0,$
ENDSTYLE
END
I explain the usage of WRAP, SQUEEZE and WIDTH in the two articles I wrote about WebFOCUS HTML and PDF Report Design. You can find these articles under Tips and Techniques on Focal Point.
May 31, 2007, 11:06 AM
Pam Krattthanks again Mickey. That worked great. I'm going to write that info down for future use.
May 31, 2007, 11:23 AM
mgrackinYou're welcome. Glad I could help. Again