Dear Jim,
Could you create a view with the extra computed column and
the date parameter and base the report on the view?
At 19:17 6/06/01 -0400, you wrote:
>Oma, Bill, Albert, & Dr.R.
> Unfortunately in my attempt to simplify the problem I left out a very
>important condition which, I think, means I will have to pursue Razzak's
>approach.
> I failed to mention that I need to meet the where condition
> "between two
>dates" where the computation is performed for both A and B rather than use
>all values for A and B types from the table, and I haven't been able to
>figure out how to incorporate such a condition into the vtot variable
>calculation
>
> Although it really doesn't matter if it is not possible to work
> the "where"
>condition into the vtot variable calculation, In trying the
>"sum(IFEQ(colQ.........)" approach (assuming no where condition) I did
>encounter an error and can't see where I deviated from your examples. The
>error message reads "Cannot recognize "OF" in sum of (2188)". I definitely
>didn't have "of" after sum.
>
> Thanks for your suggestions which are greatly appreciated.
>Jim
>
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> > Behalf Of Oma Cox
> > Sent: Wednesday, June 06, 2001 11:10 AM
> > To: [EMAIL PROTECTED]
> > Subject: RE: Report Totals
> >
> >
> > 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
> >
> >
Warmest regards,
Tom Grimshaw
coy: Just For You Software
tel: 61 (0)2 9552 3311
fax: 61 (0)2 9566 2164
mobile: 0414 675 903
post: PO Box 470 Glebe NSW 2037 Australia
street: 3/66 Wentworth Park Rd Glebe NSW 2037
email: [EMAIL PROTECTED]
web: www.just4usoftware.com.au
