Aha - it could be that simple. I'll let you know, Doug David
"David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261" -----Original Message----- From: Doug Hamilton [mailto:[email protected]] Sent: Tuesday, December 1, 2009 07:09 PM To: 'RBASE-L Mailing List' Subject: [RBASE-L] - Re: Report prints extra page; PDF file generated is huge David - I'm not sure if you've resolved the extra page issue yet. I fixed a similar problem recently by removing the report footer. Myblank page printed occasionally, not every page like yours, but maybethe 4 columns in your report has something to do with it. I would trygoing to Reports in the menu bar and uncheck any section that is notexplicitly used in your report. Doug David Blocker wrote:Thanksto all on the list who assisted me in working through issues on thecolumnarreport I?ve been creating the last few days! Thereare now 2 remaining issues with the report, one minor, one a possibledealbreaker.The report is a membership listfor a musician?s union. 1.The reportALWAYS prints an extra blank page at the end, whether I print forthe fulldata set of about 1700 rows or just a portion.The report breaks first on a variable set to the first letterof the fullname, then on the name itself in order to keep each listing togetherwithoutwrapping to the next column. The first break has nothing checked off re keep break together, reprintbreakheader etc.The second has Keep breaktogether checked off. The page footer has a Before Generate Custom EEP which prints the firstletterof the group on that page.The EEP movesthe 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 linesthe clientwants for borders Ideas? 2.The client wantsthis report in a PDF format so they can distribute the list to membersby emailonce a month. However the PDF file created is 39,308,445 bytes in size: zippingit doesnot significantly reduce the size.Thedatabase itself is SMALLER, only 30,284,160 for all 4 files.It would obviously NOT be possible to emailthis file. The workaround I?ve found for now is to print to an RTF file and thenuse Wordto create a password needed to edit the file, so members can view itwithoutworrying about editing it. The RTF file for the same report is5,941,248 insize, a workable number. Any ideas about why the PDF file is so huge and how to reduce its size? DavidBlocker "David Blocker [email protected] Office: 781-344-1920 Cell: 339-206-0261"
