David, >>> Tom Frederick suggested specifically dropping the embed_used_fonts option (OPTION PDF|EMBED_USED_FONTS OFF) this did not significantly reduce the size ? it actually very slightly increased it. <<<
I was running a report using the PDF option and it was regularly generating files app. 600Kb. After I set: |EMBED_USED_FONTS OFF The size if the files went to app. 40 Kb, a considerable reduction. Please not that I did not drop the option; I simply set it to OFF. I wonder if dropping the line reverts to the default "ON." I am curious why you did not get the reduction. Did you drop the option or simply turn it off? I am not sure if it makes a difference but I am still chugging along in 7.5. FWIW, below is the command I use: PRINT FWOInvoice WHERE FWinvNo = .vFWInvNo + OPTION PDF + |FILENAME .vInvPDFFile + |SHOW_CANCEL_DIALOG ON + |BACKGROUND_FILE NONE + |BACKGROUND_TYPE CENTER + |BACKGROUND_COLOR WHITE + |INCLUDE_LINES ON + |INCLUDE_SHAPES ON + |INCLUDE_RICHTEXT ON + |RICHTEXT_ENCODING_TYPE PLAINTEXT + |INCLUDE_IMAGES ON + |IMAGE_FORMAT JPG + |PIXELFORMAT 32 + |JPEG_QUALITY 100 + |IMAGE_DPI -1 + |INCLUDE_HYPERLINKS ON + |GENERATE_TOC ON + |TITLE Invoice + |SUBJECT Detail Invoice + |AUTHOR H&S Gravel Pit + |KEYWORDS Invoice Gravel Pit + |USE_COMPRESSION ON + |COMPRESSION_METHOD MAXCOMPRESS + |FONT_ENCODING WIN_ANSI + |EMBED_USED_FONTS OFF + |ENCRYPT_FILE ON + |ENCRYPTION_LEVEL 128BIT + |ENABLE_PRINTING ON + |ENABLE_COPYING ON + |ENABLE_MODIFYING OFF + |HIDE_TOOLBAR OFF + |HIDE_MENUBAR OFF + |HIDE_WINDOW_UI OFF + |FIT_WINDOW OFF + |CENTER_WINDOW OFF + |PAGE_LAYOUT SINGLE_PAGE + |PAGE_MODE NONE + |NON_FULL_SCREEN_PAGE_MODE NONE + |PRESENTATION_MODE NONE + |DURATION 0 + |OPEN OFF Hope it helps. Javier, Javier Valencia, PE 913-915-3137 ________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of David Blocker Sent: Friday, December 04, 2009 11:54 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Solutions Found to Columnar Membershipp Report Printed to PDF File: Use Acrobat 9.0 I wanted to report back to you on the results of your helpful suggestions re my 4 column report of a membership directory that had to suppress many possible blank lines. The client wanted a PDF file that could be distributed by email to the membership list. Printing to a PDF file in R:Base (using PRINT? OPTION PDF) had 2 problems in the latest build of R:Base 7.6: Blank extra page at the end PDF file printing about 1700 names was 39 megabytes (larger than the database itself) Here?s what I found out: Blank extra page at the end Doug Hamilton solved this one: I didn?t realize R:Base was defaulting to assigning the report a Report Footer and Header (in the Report Designer: menu Reports / Report Footer is check off). I thought I had to specifically locate objects in a section to activate it. Just unchecking the Report Footer item solved the problem. The PDF file was 39 megabytes (larger than the database itself). This took more trials, and some ideas I did not test, since I found a solution agreeable to the client. Jim Bentley suggested dropping the page style: I tried this and it only dropped the file size by a small amount, not significant. Tom Frederick suggested specifically dropping the ?embed_used_fonts? option (OPTION PDF|EMBED_USED_FONTS OFF) ? this did not significantly reduce the size ? it actually very slightly increased it. Several suggestions actually pointed me in the right direction: Jim Bentley suggested getting a Word add-on to save a file as a PDF, then printing the report to an RTF and converting in Word to compare. Jim also suggested getting PDF creator to compare. Larry thought the issue was that R:Base, with the Rich Text Fields I was using with regions to suppress blank lines, was creating graphics objects instead of text. Tom Hawley observed that ?PDFs created by third party software (something other than Adobe Acrobat) often use older versions of the PDF spec which do not compress as well as newer versions. ? He suggested trying Adobe Acrobat 9.0 All of the above led me to try this, since I had Adobe Acrobat 6.0 on my PC and frequently use it to print to a PDF with good results: In R:Base, use these commands: PRNSETUP ?Adobe PDF? PRINT reportname WHERE? ORDER BY?. OPTION PRINTER Using Acrobat 6.0, the file size decreased from 39 megabytes to about 6 megabytes. Taking this one step further, I upgraded Acrobat from 6.0 to 9.0 (warning to all who try this: their web site and download directions are very confusing with multiple windows opening up all over the place; I ended up accidentally installing not just English but English French and Dutch and it took a VERY long time to download and install) I then used the same commands as above. Result: Using Acrobat 9.0, the file size decreased from 39 megabytes to 356,064 bytes ? a reduction of over 100 times smaller. Larry Lustig suggested that I could get the same results by using a stored procedure to format the text and memo fields on the report. Larry, since the client wants this report ASAP and since he was willing to pay the $299.00 to get Adobe 9.0 Standard, we?re going with the above solution. Someday I?ll try your solution as well! Many thanks to all who helped! David Blocker "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261"
