Hi, I have a compound PDF report.i have 2 reports in that.both shuld display side by side.both are across reports.1st report i have 6 columns and 2nd report i have 20 columns.i want to display in a single page.I tried with page size legal the second report is overlapping.
Can someone help.
Thanks in advanceThis message has been edited. Last edited by: Kerry,
WebFocus 7.1.4 xp html,excel,pdf
October 04, 2011, 09:27 AM
rfbowley
The only way I know of to get 26 columns on one pdf report is to use "D" size paper. Of course, when the user forgets to change their PDF Print Properties to use a printer that can handle that size, Adobe will resize to 8 1/2 x 11 and the report becomes unreadable.
Do the math. legal is 14 inches across in landscape. Very few printers will allow less than .25" margins. and pdf WILL follow the default printer settings on the PC for the final output.
Then there is the gap between columns. PDF ALWAYS has a gap, but you can reduce it to about .05" with font size 6 and a couple other tricks. 26 columns means 25 gaps, that's another 1.25".
So, 14" minus .5" for margin minus 1.25" for gaps leaves 12.25" printable area. Divide that by 26 and each column must average less that .47".
Now try this, using that calculated value:
TABLE FILE CAR
PRINT
CAR.COMP.CAR
CAR.CARREC.MODEL
BY LOWEST CAR.ORIGIN.COUNTRY
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
PAGESIZE='Legal',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=6,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
$
TYPE=REPORT,
COLUMN=N3,
SQUEEZE=0.471153,
$
ENDSTYLE
END
Even the MODEL field from CAR can't fit in that amount of space.
Sorry to be the bearer of bad tidings, but I have been through this with too many clients.
Robert F. Bowley Jr. Owner TaRa Solutions, LLC
In WebFOCUS since 2001
October 04, 2011, 04:29 PM
Waz
The question is, will this report ever be printed, or just viewed ?
I was also going to suggest a larger page size.
Are you able to give us an example, say from one of the sample files ?
Have you played with the margins and the font.
Changing to use Arial Narrow may help, but probably not.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
October 04, 2011, 04:34 PM
njsden
quote:
Changing to use Arial Narrow may help, but probably not.
Hmmm, a combination of Arial Narrow + very tight left/right gaps + SQUEEZE ON is promising ... but perhaps a bit hard to read:
TABLE FILE CAR
PRINT
CAR.SPECS.LENGTH
CAR.SPECS.WIDTH
CAR.SPECS.FUEL_CAP
BY CAR.CARREC.MODEL
ACROSS LOWEST CAR.COMP.CAR
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=PTS,
PAGESIZE='Legal',
ORIENTATION=LANDSCAPE,
SQUEEZE=ON,
$
TYPE=REPORT,
FONT='ARIAL NARROW',
SIZE=7,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
RIGHTGAP=1,
LEFTGAP=1,
$
TYPE=REPORT,
COLUMN=ROWTOTAL(*),
FONT='ARIAL NARROW',
SIZE=7,
COLOR=RGB(66 70 73),
STYLE=NORMAL,
$
ENDSTYLE
END