Jim,
If I understand your question is how to give a total for the items type
defined in colT - A & B.
Define Report Var as follows:
vtotA= sum (IFEQ(colT,'A',(colQ * colC),0))
vtotB= sum (IFEQ(colT,'B',(colQ * colC),0))
If you have a lot of types or they are dynamic in nature then this means
adding a lot of var!
Adding the extra column and using code before the report is generated is the
best bet if you don't have a fixed amount of types.
Best regards,
Oma
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of J. Andrus
Sent: Wednesday, June 06, 2001 8:54 AM
To: RBase
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
