Javier See my original post: the command included "EMBED_USED_FONTS OFF"
David "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----Original Message----- From: Javier Valencia [mailto:[email protected]] Sent: Friday, December 4, 2009 04:03 PM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - RE: Solutions Found to Columnar Membershipp Report Printed to PDF File: Use Acrobat 9.0 David,>>> Tom Frederick suggested specifically dropping the embed_used_fontsoption (OPTION PDF|EMBED_USED_FONTS OFF) this did not significantly reducethe size ? it actually very slightly increased it.<<<I was running a report using the PDF option and it was regularly generatingfiles app. 600Kb. After I set:|EMBED_USED_FONTS OFFThe 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 wonderif dropping the line reverts to the default "ON." I am curious why you didnot get the reduction. Did you drop the option or simply turn it off? I amnot 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 OFFHope it helps.Javier,Javier Valencia, PE913-915-3137________________________________________From: [email protected] [mailto:[email protected]] On Behalf Of DavidBlockerSent: Friday, December 04, 2009 11:54 AMTo: RBASE-L Mailing ListSubject: [RBASE-L] - Solutions Found to Columnar Membershipp Report Printedto PDF File: Use Acrobat 9.0I wanted to report back to you on the results of your helpful suggestions remy 4 column report of a membership directory that had to suppress manypossible blank lines. The client wanted a PDF file that could bedistributed by email to the membership list. Printing to a PDF file inR:Base (using PRINT? OPTION PDF) had 2 problems in the latest build ofR:Base 7.6: Blank extra page at the endPDF file printing about 1700 names was 39 megabytes (larger than thedatabase itself) Here?s what I found out: Blank extra page at the endDoug Hamilton solved this one: I didn?t realize R:Base was defaulting toassigning the report a Report Footer and Header (in the Report Designer: menu Reports / Report Footer is check off). I thought I had to specificallylocate objects in a section to activate it. Just unchecking the ReportFooter item solved the problem.The PDF file was 39 megabytes (larger than the database itself). This tookmore trials, and some ideas I did not test, since I found a solutionagreeable to the client.Jim Bentley suggested dropping the page style: I tried this and it onlydropped 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 thesize ? it actually very slightly increased it.Several suggestions actually pointed me in the right direction: Jim Bentleysuggested getting a Word add-on to save a file as a PDF, then printing thereport to an RTF and converting in Word to compare. Jim also suggestedgetting 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 asnewer versions. ? He suggested trying Adobe Acrobat 9.0All of the above led me to try this, since I had Adobe Acrobat 6.0 on my PCand 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 PRINTERUsing Acrobat 6.0, the file size decreased from 39 megabytes to about 6megabytes.Taking this one step further, I upgraded Acrobat from 6.0 to 9.0 (warning toall who try this: their web site and download directions are very confusingwith multiple windows opening up all over the place; I ended up accidentallyinstalling not just English but English French and Dutch and it took a VERYlong 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,064bytes ? a reduction of over 100 times smaller. Larry Lustig suggested that I could get the same results by using a storedprocedure to format the text and memo fields on the report. Larry, sincethe 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"
