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 advance

This message has been edited. Last edited by: Kerry,

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.

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.

quote:

Changing to use Arial Narrow may help, but probably not.

Now, that's encouraging

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

Hence my question, will it ever be printed or just viewed ?

waz it will be printed.
I tried with pagesize B and leftgap&rightgap,squeeze on it worked.

Thanks everyone