September 18, 2007, 10:13 AM
KameshAlign PDF format
Hello,
How to reduce the space between Across Data in PDF format?
Ex:
TABLE FILE GGSALES
SUM
DOLLARS
BY REGION
ACROSS PRODUCT
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT,GRID=OFF,FONT='ARIAL',SIZE=9,STYLE=BOLD,SQUEEZE=ON,$
TYPE=TITLE,STYLE=-UNDERLINE+BOLD,BACKCOLOR=BLUE,COLOR=WHITE,$
TYPE=ACROSSVALUE,ACROSS=PRODUCT,BACKCOLOR=SILVER,COLOR=MAROON,$
TYPE=DATA,COLUMN=P1,BACKCOLOR=GREEN,COLOR=WHITE,STYLE=BOLD,$
ENDSTYLE
END
-EXIT
If you run the above code, you can see the space between data. I want to specify the column number for those data as how we do for regular Tables (without ACROSS)? Right now the data exceeds the first page and the report shows in second page also.
Any suggestions,
Thanks
September 18, 2007, 11:12 AM
PrarieThis makes it better...I'm sure there are other ways to help involving Squeeze and Wrap.
TYPE=REPORT,ORIENTATION=LANDSCAPE,GRID=ON,FONT='ARIAL',SIZE=9,STYLE=BOLD, SQUEEZE=ON,$
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
September 18, 2007, 11:22 AM
KameshThanks for your suggestion Prarie. But I dont want the GRID to be ON.
WFConsultant
WF 8105M on Win7/Tomcat
September 18, 2007, 11:46 AM
Francis MarianiI think you want to reduce the gap between the columns with LEFTGAP and RIGHTGAP. In an edited version of your example, changing LEFTGAP and RIGHTGAP doesn't seem to make much difference:
TABLE FILE GGSALES
SUM
DOLLARS/D8/R
BY REGION
ACROSS PRODUCT
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=9, STYLE=BOLD, SQUEEZE=ON, $
TYPE=REPORT, LEFTGAP=0.02, RIGHTGAP=0.02, $
TYPE=TITLE, STYLE=-UNDERLINE+BOLD, BACKCOLOR=BLUE, COLOR=WHITE,$
TYPE=ACROSSVALUE, ACROSS=PRODUCT, BACKCOLOR=SILVER, COLOR=MAROON,$
TYPE=DATA, COLUMN=P1, BACKCOLOR=GREEN, COLOR=WHITE, STYLE=BOLD,$
ENDSTYLE
END
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
September 18, 2007, 11:47 AM
PrarieChanging to Landscape helps anyway.
| In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
September 18, 2007, 11:52 AM
mgrackinKamesh,
For more information on formating PDF reports, take a look at the two articles about this under the Tips & Techniques section of Focal Point.
http://www.informationbuilders.com/support/developers/index.htmlLook for "WebFOCUS HTML and PDF Report Design Part I and Part II"
Thanks!
Mickey
| FOCUS/WebFOCUS 1990 - 2011 |
September 18, 2007, 04:19 PM
KameshThanks MGrackin. After read your document I added WRAP for my ACROSSCOLUMN and it worked great.
Thanks everybody for their valuable suggestions.
WFConsultant
WF 8105M on Win7/Tomcat