Thanks, Tom. I'll give that approach a try along with the others suggested.
Jim
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Tom Grimshaw
> Sent: Wednesday, June 06, 2001 8:55 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Report Totals
>
>
> 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
