Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / July 2008

Tip: Looking for answers? Try searching our database.

ACE report help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Leo - 18 Jul 2008 16:05 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.