Just one word of caution - if you use TABLEF for your request, EMPTYREPORT = does not work!=20 But, it's a great command!! Carol Dobson -----Original Message----- =46rom: focus-l-bounce@xxxxxxxxxxxxx [mailto:focus-l-bounce@xxxxxxxxxxxxx]On Behalf Of Winfred Gunter Sent: Wednesday, May 19, 2004 7:51 AM To: focus-l@xxxxxxxxxxxxx Subject: [focus-l] Re: Indicate "NO OUTPUT" then 0 records are found in report Sandy, We use EMPTYREPORT=3DON and check for &RECORDS or &LINES. If &RECORDS or &LINES EQ 0 we also: OFFLINE CLOSE and re-FILEDEF OFFLINE with APPEND to add a custom message that says ***** NO DATA *****. So, you get the report columns, as normal, then in the body of the report you get ***** NO DATA *****. I say "we", I've been unemployed since Feb 27th!!!! Hope this helps, WG ----- Original Message -----=20 =46rom: <sll@xxxxxxxxxxxxxxxxx> To: <focus-l@xxxxxxxxxxxxx> Cc: <sll@xxxxxxxxxxxxxxxxx> Sent: Tuesday, May 18, 2004 2:16 PM Subject: [focus-l] Indicate "NO OUTPUT" then 0 records are found in report > Hey, > > I am on a VAX machine. We have not established standards for when NO RECORDS > are found. What is an effective manner of displaying this status in a =46OCUS > report=3F=3F=3F=3F I do have access to a manual. Cannot quit figure this = one. > > Any assistance would be appreciated. > > Sandy > > ------------------------------------------------- > This mail sent through IMP: http://horde.org/imp/ > --------------------------------------------------------- This e-mail transmission may contain information that is proprietary, = privileged and/or confidential and is intended exclusively for the person(s) = to whom it is addressed. Any use, copying, retention or disclosure by any = person other than the intended recipient or the intended recipient's designee= s= is strictly prohibited. If you are not the intended recipient or their = designee, please notify the sender immediately by return e-mail and delete al= l= copies.=20 ---------------------------------------------------------