Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!ucbvax!agate!violet.berkeley.edu!steve
From: steve@violet.berkeley.edu (Steve Goldfield)
Newsgroups: comp.databases
Subject: Ingres: counting conditionally in Report/Writer
Message-ID: <23730@agate.BERKELEY.EDU>
Date: 28 Apr 89 14:54:28 GMT
Sender: usenet@agate.BERKELEY.EDU
Reply-To: steve@violet.berkeley.edu (Steve Goldfield)
Organization: University of California, Berkeley
Lines: 15

I have an Ingres report in which I wanted to count
some rows according to a where condition and report
the count at the end of the report. (This is version
5.0.) I was surprised (no longer shocked at any
deficiency in Ingres) that although you can count
conditionally in quel, you apparently can't in
Ingres' Report/Writer (at least version 5.0). I
had to go back and write another quel script to
include only those I want to count.

I'd love to be proved wrong. Does anyone know a way
to count conditionally in a report? It seems an
obvious functionality a user would want.

Steve Goldfield