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
