Assuming you know EXACTLY the number of expected results A,B
Then, create report variables for each possible colT (you have two)
Atotal = (IFEQ(ColtT('A',(Atotal + (ColQ * ColC)),Atotal)))
Btotal = (IFEQ(ColtT('B',(ABotal + (ColQ * ColC)),Btotal)))
The variables are in the detail section of the variables list so that they
calculate on each row of data. Place the variables in the footer and they
will print there.
----- Original Message -----
From: J. Andrus <[EMAIL PROTECTED]>
To: RBase <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 8:53 AM
Subject: Report Totals
> RBWIN 2000, Ver 6.5+, Build 1.839xRT03
>
> Table: tablename
> Columns: colC Currency, colQ Real, colT Text
>
> In the report based on tablename each detail line has a vtotal which is
> (colQ * colC) where colT for that line can be any one, for simplicity, of
> two types, A or B.
> Is it possible to show, in the report footer, the total for type A and the
> total for type B without adding a column to the table containing the value
> of (colQ * colC) or determining these two totals in a command file prior
to
> running the report?
>
> Jim
>
