Focal Point
accomodating all fields in one page

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

February 28, 2007, 07:19 AM
Aditya
accomodating all fields in one page
Hi,

In my report i have 14 fields to display.As the no. of fields are more my report display's only 10 fields and their data when i see the print-preview.So want to know how to accomodate all the fields in one page so that when printed using printer i get all the fields and their data displayed.Is there a way to reduce the individual cell width of data in the report.I have also set the SQUEEZE variable to ON.

Regards,
Aditya
February 28, 2007, 08:14 AM
Carol Dobson
Are you creating a PDF file?
You can set your orientation=landscape
and paper=legal in the stylesheet

Use a smaller font
print each field in +1

See if that helps any! Good Luck!



WebFOCUS 7.6.6/TomCat/Win2k3
February 28, 2007, 10:02 AM
Francis Mariani
In a PDF report that is too wide, the first thing I change is the default LEFTGAP and RIGHTGAP, which I think are too large (as far as I know, the manual does not state what the default amount is):

TYPE=REPORT, LEFTGAP=0.05, RIGHTGAP=0.05, $

You can also wrap a very wide column:

TYPE=REPORT, COLUMN=CUST_NMX, WRAP=2.0, $



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
February 28, 2007, 12:17 PM
TexasStingray
At one Site we used SUBHEAD with NOSPLIT and put the columns in the subheading. We also turned on the alignment grid to set each columns text and data width. The reports look very nice, using Bold and Background Colors.

Hope this helps




Scott

March 01, 2007, 01:03 AM
Aditya
Hi,

I am generating the reports in HTML.Setting WRAP is not solving the problem.

Regards,
Aditya
March 01, 2007, 01:39 AM
Danny-SRL
Hi Aditya,

Here are 2 possible solutions.
1. By changing some of the titles and using a smaller font you can make the report less wide. If that is not enough, in Print Preview you can setup the page to print LANDSCAPE
TABLE FILE CAR
PRINT BODYTYPE SEATS AS 'S,E,A,T' DEALER_COST AS DC RETAIL_COST AS RC SALES AS SALE
BODYTYPE SEATS AS 'S,E,A,T' DEALER_COST AS DC RETAIL_COST AS RC SALES AS SALE
BY COUNTRY
BY CAR
BY MODEL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, SIZE=9, $
ENDSTYLE
END

2. You can put the sort fields in a SUBHEAD
TABLE FILE CAR
PRINT BODYTYPE SEATS DEALER_COST AS DC RETAIL_COST AS RC SALES AS SALE
BODYTYPE SEATS DEALER_COST AS DC RETAIL_COST AS RC SALES AS SALE
BY COUNTRY NOPRINT
BY CAR NOPRINT
BY MODEL NOPRINT
ON MODEL SUBHEAD
"Country<+0 Car<+0 Model"

"
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBHEAD, HEADALIGN=INTERNAL, $
ENDSTYLE
END

Does this help?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

March 01, 2007, 01:48 AM
Danny-SRL
Aditya,
There seems to be a problem with my note.
After the first line of the SUBHEAD I have
" caret COUNTRY caret CAR caret MODEL "
Apparently " caret finishes the note.
Then I have:
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBHEAD, HEADALIGN=INTERNAL, $
ENDSTYLE
END

Does this help?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

March 01, 2007, 01:57 AM
Aditya
Hi Danny-SRL,

I am trying to reduce the font size and its working.I need to do minor modifications for the headers and trailers.

Thanks for your help.

Regards,
Aditya
March 01, 2007, 10:14 AM
TexasStingray
Another option is to increase the page size. I did this for one of my reports. PDF saw it as 11 X 17 but when I printed it I told the acrobat reader to print on 8.5 X 11 and it automaticlly reduced it for me.

Just an idea




Scott