Re: ACE report advice?

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"? > > e.g. when using and "order by" statement that includes a table column > named "category", I create "group" headers as in: > > before group of category begin > > if category = "one" then > print ....... > > if category = "two" then > print ....... > > etc.... > > end { before group of category } > > The report runs just fine, but if a particular category value does not > exist in the table the report is "silent". Can I determine this and tell > the report user? Think I followed that.. One way is to define variables as place holders, set these in a first page header to zero When you process your before groups, set the variables. Use the on last row to print the missing ones. If you have another group above this, use the before/after group of that to set the variables. . . define variable isone integer variable istwo integer variable isthree integer end . . select col1, col2 from from tab order by col1. . first page header let isone=0 let istwo=0 let isthree=0 before group of col2 if col2="One" then begin .. .. let isone=1 end if col2="Two" then begin .. .. let istwo=1 end on last row if isone=0 then print "No category 1" if istwo=0 then print "No category 2" Or something like.... -- Mike Aubury _\\?/_ |O O| +----------oOOO-\\_/-OOOo---------+-------------------------------+ | Heisenberg may have been here | mike@aubury.demon.co.uk | | | http://www.aubury.demon.co.uk | +--------------------------------+-------------------------------+