ACE report help

Posted in 2008

Leo — Fri, 18 Jul 2008 08:05:16 -0700 (PDT) — source: Usenet: comp.databases.informix

I'm hoping there are some ACE report gurus out there who can help. I am trying to do a group total with a WHERE clause in it. It works great with one parameter but I cannot figure out how to use multiple "types". I have certain fees that need to be totaled together per user and I've tried several methods but to no avail. The following code works for the single fee type (the variable "code") but I need to combine all of the (IVD, SCE, NCF) fee types for it to really do what I need. I tried a simple parenthesis at the end, but it doesn't work: group total of amount1 where code = ("IVD","SCE","NCF") The following example does work, but again, only for one type not the several that i need. after group of 4 skip 1 line print column 1, "IVD related fees sub-total for ", user, " = ", group total of amount1 where code = "IVD" skip 1 line

↪ replying to Leo

Eric Rowell — Fri, 18 Jul 2008 11:14:07 -0400 — source: Usenet: comp.databases.informix

Haven't worked on ACE reports in a while but for SQL the following is invalid; where code = ("IVD","SCE","NCF") It should be; where code in ("IVD","SCE","NCF") Try and see... Maybe? Eric B. Rowell On Fri, Jul 18, 2008 at 11:05 AM, Leo <leonidesruiz@gmail.com> wrote: > I'm hoping there are some ACE report gurus out there who can help. I > am trying to do a group total with a WHERE clause in it. It works > great with one parameter but I cannot figure out how to use multiple > "types". > > I have certain fees that need to be totaled together per user and I've > tried several methods but to no avail. The following code works for > the single fee type (the variable "code") but I need to combine all of > the (IVD, SCE, NCF) fee types for it to really do what I need. I > tried a simple parenthesis at the end, but it doesn't work: > > group total of amount1 where code = ("IVD","SCE","NCF") > > The following example does work, but again, only for one type not the > several that i need. > > after group of 4 > skip 1 line > print column 1, "IVD related fees sub-total for ", user, " = > ", group total of amount1 where code = "IVD" > skip 1 line > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > -- Eric B. Rowell