Jeff, I don't know if it's related but I had a couple of reports last week where somehow the page settings were 14 x 11 instead of 8.50 x 11 and I also got some blank pages as a result...
Claudine :) -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey M. Watson Sent: Monday, February 04, 2008 12:39 PM To: RBASE-L Mailing List Subject: [RBASE-L] - strange I have a report that is printing with '0' pages but it still shows up on the screen as just a blank page. when I change print to browse on the table the report is based upon with the same where clause, I get the following R>browse all from custbranch WHERE custbid NOT IN (SELECT branch# FROM crosstable WHERE ordercustomer# IS NOT NULL) AND custbid IN (SELECT custbid FROM orderheader WHERE millnumber IS NOT NULL) <WARNING> No rows exist or satisfy the specified clause. (2059) gives me the expected result for this query.. the print command is as follows: R>PRINT customerswb WHERE custbid NOT IN (SELECT branch# FROM crosstable WHERE ordercustomer# IS NOT NULL) AND custbid IN (SELECT custbid FROM orderheader WHERE millnumber IS NOT NULL) I've never seen it print the "blank 0 page" before. this is on the newest available 01/02/2008 v8 build. Any ideas? I use it to print a bunch of reports in a row, like this set error message 2059 off print x print y print z set error message 2059 on and if the reports criteria are not met it just skips it without any fuss. So now the blank report shows up. it's a simple click away to close it I just wanted to make sure it was functioning as expected. Didn't really want to do a count select for all my reports and double up the database hits for the action. Any ideas? Thanks-(in advance!) Jeff Watson [EMAIL PROTECTED] Tube Methods, Inc. 610-279-7700
