12-28-2017 12:44 PM
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;
12-28-2017 12:53 PM
It's conceivable that you don't really need 30 characters to print the budget values. Try cutting back from:
to this instead:
12-28-2017 01:45 PM
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.