Jim,
If you know the totals (Report Footer Totals) before printing
the report, you could pre-calculate those variables and then
simply locate in Report Footer section.
Example 01:
SET VAR vTotal1 INTEGER = NULL
SET VAR vTotal2 CURRENCY = NULL
SELECT COUNT(*) INTO vTotal1 INDIC IvTotal1 FROM TableName +
WHERE ...
SELECT SUM(ColName) INTO vTotal2 INDIC IvTotal2 FROM TableName +
WHERE ...
PRINT ReportName WHERE ...
Example 02:
SET VAR vTotal1 INTEGER = NULL
SET VAR vTotal2 CURRENCY = NULL
SELECT COUNT(*), (SUM(ColName)) INTO +
vTotal1 INDIC IvTotal1, +
vTotal2 INDIC IvTotal2 +
FROM TableName WHERE ...
PRINT ReportName WHERE ...
Note: In situations like that, make sure that you're consistent
with the WHERE clause ...
Have Fun!
Very Best Regards,
Razzak.
At 09:53 AM 6/6/2001 -0400, Jim Andrus wrote:
>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?
===================================-============================
R:BASE Developers's Conference: http://www.rbase.com/conference
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
