David, I would look at the Page Style as the likely culprit. How did you create the page style perhaps as an image rather than say an RTF. When creating a PDF each page you print will need to include a copy of the "page style" print code(s).
What version of Word are you using? If it is the latest one where file are saved as .DOCX have you explored the possibility of getting the add in that allows you to "save" word doc as a pdf. You could then see what size file is created via this method. Here is a link to the addin to do this. http://www.microsoft.com/downloads/details.aspx?FamilyId=4D951911-3E7E-4AE6-B059-A2E79ED87041&displaylang=en I do this all the time withthe papers I am writing for school. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 ________________________________ From: David Blocker <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, December 1, 2009 6:56:59 AM 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 on the columnar report I?ve been creating the last few days! There are now 2 remaining issues with the report, one minor, one a possible deal breaker. The report is a membership list for a musician?s union. 1. The report ALWAYS prints an extra blank page at the end, whether I print for the full data set of about 1700 rows or just a portion. The report 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 wrapping to the next column. The first break has nothing checked off re keep break together, reprint break header etc. The second has Keep break together checked off. The page footer has a Before Generate Custom EEP which prints the first letter of the group on that page. The EEP moves the letter from side to side of the 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 client wants for borders Ideas? 2. The client wants this report in a PDF format so they can distribute the list to members 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 is SMALLER, only 30,284,160 for all 4 files. It would obviously NOT be possible to email this file. The workaround I?ve found for now is to print to an RTF file and then use Word to create a password needed to edit the file, so members can view it without worrying about editing it. The RTF file for the same report is 5,941,248 in size, a workable number. Any ideas about why the PDF file is so huge and how to reduce its size? David Blocker "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261"
