Karen, I haven't done thousands but we have done hundreds. I have a routine on a monthly basis that runs on the server and generates the statements and emails them. I chose to do this on the server because I have noticed some weirdness when I try this routine on a workstation. I have always chalked it up to network activity at the time so the server option at 2AM seemed like a good idea.
Jan -----Original Message----- From: [email protected] To: [email protected] (RBASE-L Mailing List) Date: Tue, 24 Mar 2009 11:06:37 EDT Subject: [RBASE-L] - Re: Printing a whole buncha reports Emmitt: I would have guessed that printing that many individual PDFs would present a problem, even if they aren't opened... Not sure I would even attempt that for the number I need to generate. Since I have to do a conversion again because of report/code changes since I attempted the first conversion, I'm not looking forward to investing free time and just hoping that this all works. So I was hoping to hear from someone who routinely prints thousands of individual jobs successfully -- haven't heard that from anyone yet. So now we're onto printing perhaps one huge PDF file, or maybe split into 4 of them, probably by CustID. Recent posts have talked about huge PDF sizes, so I'm wondering what's the largest PDF file anyone has ever generated and what is the size? Does anyone have a relatively simple one-page-per-row, no-graphic report that they can get to print for thousands of rows as a test? I can't have my 6.5 report do that because there's alot of variables and calculations done in code, and is meant to print just the one row at a time. Would take some work on the code to get it all into one big temp table with all the data in there.... Karen Karen, When printing invoices directly to PDF with the OPEN ON option, I found that somewhere after 15 PDFs Adobe would stop accepting additional PDFs to open. So I put some code in place to pause after 15, instruct the operator to print those, then click OK to print the next batch. I’m sure that if I wasn’t using OPEN ON, R:BASE would have no problem printing the entire batch directly to individual PDFs. That creates a challenge, though, for the operator to actually get them all printed. And for invoices we must have individual files. Where all this is leading is your 2000-page PDF might be the best approach. The operator can experiment with printing page 1-300, 301-600, etc. and see what the optimal block of pages to print at one time might be. Emmitt Dove
