Jeff: This is what you get when one of your objects is outside of the page size, -or- as Claudine said...you page size in incorrect.
Jim ----- Original Message ---- From: Jeffrey M. Watson <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, February 4, 2008 10:39:14 AM 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 ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
