ods - how to fit tables into a single page

[riya275]

I have created a pdf with ods procedure and my report has 7 columns. i want all seven columns on the same page. 

for one first page of the table  i am getting them on the same page  . however When the table continues on the next page there are only 6 columns and the seventh column has shifted to a separate page.  How to fix this? 

ods pdf file ='/folders/myfolders/sales.pdf' ;
options nodate;
/*Olympic Pipeline (LONDON) - by Probability As of 17th November 2012*/
proc report data = c1.a;
column probability____ Account_name Opportunity_Owner Last_Modified_Date 
Total_Media_Value Digital_Budget Deal_Comments;
define probability____/ order  descending 'Probability';
break after probability____/dol summarize style=[backgroundcolor=grgy ]  ;
define Account_name/  'Client';
define Opportunity_Owner /'Champ';
define Last_Modified_Date/ display 'Modified';
define Digital_Budget / SUM 'Digital Budgett' format= dollar30. ;
define Total_Media_Value / SUM 'Total Budget' format= dollar30.;
define Deal_Comments/ 'Comments';
rbreak after/ ol summarize style=[backgroundcolor= grrp color=aliceblue ];
title 'Olympic Pipeline (LONDON) - by Probability As of 17th November 2012'  ;
run;
ods pdf close;

[WarrenKuhfeld]

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000531077.htm

Try increasing the paper size.

[riya275]

But how come only the first page of the table fits and the other  two pages  dont?

[Astounding]

It's conceivable that you don't really need 30 characters to print the budget values.  Try cutting back from:

format=dollar30.

to this instead:

format=dollar20.

[riya275]

Its not working

[Astounding]

Sometimes, the report is just too wide to fit.  (See @WarrenKuhfeld's comment ! )

You could also experiment with the Comments field.  Take a look at the WRAP option and whether that might save some space by enabling you to use a narrower width.

[PGStats]

You can restrict the width of certain columns with something like:

define Deal_Comments/ 'Comments' style(column)=[width=15%];

[Ksharp]

options papersize=(100in 100in);