Re: ACE report advice?
Posted in 1997
Rudy Fernandes — — source: Informix-list mailing list archive (1991-1998)
Your report seems to working on the assumption that the categories to be reported are pre-defined. In that case, you could report 'notfound' categories at the end of the report in the 'on last row' clause. I'm unsure of ACE syntax, but something like this could work ON LAST ROW IF (COUNT(?) WHERE category = 'x') = 0 THEN PRINT 'x category : No rows found' In article <5o9157$dg5@hpaneqb4.an.hp.com>, kistler@an.hp.com (Jim Kistler) wrote: >Can anyone help with advice for an ACE report?.... other than to use I4GL! > >Is there a way to inform the report user that nothing was found in >a particular "group"? > <snip> HTH. ---------------------- Rudy Fernandes GIC, Kuwait OL 7.20, 4Gl 6.04 ----------------------