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
Eric Rowell - 18 Jul 2008 16:14 GMT
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
> 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
[quoted text clipped - 21 lines]
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list

Signature
Eric B. Rowell