Albert This worked great.
Thanks for your support. I am continually grateful and amazed at the supportiveness of the R:base community. Steve Breen -----Original Message----- From: Albert Berry [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 12:56 AM To: [EMAIL PROTECTED] Subject: [RBG7-L] - Re: Variable in reports I think you need to note that the syntax here is the syntax from a standard SELECT clause, not the internal report group totalling. You will find, incidentally, that this is faster if you set the variable to only calculate in the footer or header where you place it. Oh, yeah, using the SQL syntax, you can place the variable anywhere, header or footer or in the detail lines, which is handy for creating percentages in a report. The following assumes that the literal 017 is the break point. vWhatever = (SUM(POnTotal)) FROM table WHERE MajorGroup = MajorGroup --- Steve Breen <[EMAIL PROTECTED]> wrote: > Is it possible to create the following report variable; > > Sum of POnTotal where majorgroup = '017' - Please note majorgroup is Text > and POnTotal is Currency > > When I try this I get an illegal number of expressions error > > Of course Sum of POnTotal works fine > > > Stephen Breen > CDI Services, Inc. > 3610 Deahl Court > P.O. Box 3838 South Bend, IN 46628 > 574-271-2027 Ext: 200 > Fax 574-247-4638 > Fax: 574-247-4631 > Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Web Site www.911roadrepair.com <http://www.911roadrepair.com/> > Pager 800-668-8023 > Cell 574-339-2356 > > > > > ATTACHMENT part 2 image/gif name=Blank Bkgrd.gif ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
