Tom,Larry and Jim Iappreciate your quick feedback. I?ll test all of these and let you know what Ifind out.
BTW ? I tried to create an RTF file from R:Base and then convert it to PDF ?along the lines of what several were implying in your answers ? using Adobe 5.0Write. I?m using Word 2003 and it didn?t work ? just hung totally every time Itried it, even on a small sample. David "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----Original Message----- From: Tom Frederick [mailto:[email protected]] Sent: Tuesday, December 1, 2009 09:00 AM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - RE: Report prints extra page; PDF file generated is huge David, I went through a similar PDF size issueabout a year ago, but not at your level. Simple 5-15k reports in Word were 875kin PDF when printed through RBase V8. As a check, I used Primo to build PDFs withthe Word file versions which resulted in 52K files. My print button used the PDFprint menu examples in Help. When the V8 PDF size would not shrink severalpeople suggested I drop various options and see what happens. When I dropped ?EMBED_USED_FONTS?, the files shrunk to 54K. Close enough for a final product. Seemsseveral of the PDF print option items really add a lot of weight. In your caseit is massive weight, but Razzak explained that Embed basically adds all thefonts on your system whether the file actually uses them or not. I foundthat borders also added a lot of overhead so I simply dropped them. Tom Frederick ElmCityCenter 1314 W Walnut Jacksonville, IL62650 O ?217-245-9504 F-217-245-2350 Email ? [email protected] ------------------------------------------------------------ From: [email protected] [mailto:[email protected]] On Behalf Of David Blocker Sent: Tuesday, December 01, 20096:57 AM To:RBASE-LMailing List Subject: [RBASE-L]- Report prints extra page; PDF file generated is huge Thanks to all on the list who assisted me in working through issues onthe columnar report I?ve been creating the last few days! There are now 2 remaining issues with the report, one minor, one apossible deal breaker. The report is a membership list for a musician?sunion. Thereport ALWAYS prints an extra blank page at the end, whetherI print for the full data set of about 1700 rows or just a portion. Thereport breaks first on a variable set to the first letter of the full name,then on the name itself in order to keep each listing together without wrappingto the next column. The first break has nothing checked off re keep break together, reprint breakheader etc. The second has Keep break together checked off. The page footer has a Before Generate Custom EEP which prints the first letterof the group on that page. The EEP moves the letter from side to side ofthe page for odd and even pages: IF vCounter2 = 1 THEN SET VAR vCounter2 = 0 PROPERTY LetterGroupODD VISIBLE "TRUE" PROPERTY LetterGroupEven VISIBLE "FALSE" ELSE SET VAR vCounter2 = 1 PROPERTY LetterGroupODD VISIBLE "FALSE" PROPERTY LetterGroupEven VISIBLE "TRUE" ENDIF RETURN The report has Page Style to print the horizontal and vertical lines the clientwants for borders Ideas? Theclient wants this report in a PDF format so they can distribute the list tomembers by email once a month. However the PDF file created is 39,308,445 bytes in size:zipping it does not significantly reduce the size. The database itself isSMALLER, only 30,284,160 for all 4 files. It would obviously NOT bepossible to email this file. The workaround I?ve found for now is to print to an RTF file and then use Wordto create a password needed to edit the file, so members can view it withoutworrying about editing it. The RTF file for the same report is 5,941,248 insize, a workable number. Any ideas about why the PDF file is so huge and how to reduce its size? David Blocker "DavidBlocker [email protected] Office: 781-344-1920 Cell: 339-206-0261"
