1. Set Zero ON
2. Predefine the variables used in the report
I found that by doing these two things the "sum of x" worked with no problems.
Also, if you are using breakpoints you may have to reset the variables on the breaks.
Gary
----- Original Message ----- From: "John Docherty" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Monday, September 27, 2004 3:24 PM
Subject: [RBG7-L] - Sum of problem in reports
I too have had major problems with getting 'sum of x' to work in reports, the totals (sums) being nulls or zeros when they should exist. Using a DB calc variable works properly but my simple sum of x does not. I found however that if I set the variable to zero prior to printing the report, rather than leaving it as a null, the sum was calculated correctly.
However the next problem is, if I print to the screen, the sums are correct,
but then if I print from the preview screen, the sums revert to 0. (I am
using build 7.1.76.30715 on one PC and 7.1.78.30916 on another - both
exhibit similar problems)
Any suggestions would be appreciated.
Regards,
John Docherty
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Oakes Sent: Friday, 17 September 2004 4:06 a.m. To: RBG7-L Mailing List Subject: [RBG7-L] - RE: sum of problem in reports update 77
Strange indeed...Like I said - I wasn't ever able to pin it down either or else I would have reported it.
-----Original Message----- From: Dan Goldberg [mailto:[EMAIL PROTECTED] Sent: Thursday, September 16, 2004 12:05 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: sum of problem in reports update 77
I tried the dot but it didn't work. I also tried saving it, exiting, and trying again.
I gave up and created a new report and now it works. Strange...
Thanks
Dan
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dawn Oakes Sent: Thursday, September 16, 2004 8:46 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: sum of problem in reports update 77
Dan, I've had that problem before. You need the dot (.vtotalcost2). Sometimes I would just OK out of the create variable window and then go back in and try it again. In prior releases, I noticed that sometimes newly created variables weren't available for use in sum of expressions unless you "save" first. I wasn't able to pin it down - probably something I was doing wrong, and it hasn't happened to me in update 77 - I think 76 was the last time. Dawn
-----Original Message----- From: Dan Goldberg [mailto:[EMAIL PROTECTED] Sent: Thursday, September 16, 2004 10:59 AM To: RBG7-L Mailing List Subject: [RBG7-L] - sum of problem in reports update 77
I have a couple of variables in my report:
1 : CURRENCY : F0 : vtotalcost = (sum(TOTCOST)) in invoice2 where invoicenum = invoicenum 2 : CURRENCY : F0 : vtotalcost2 = (.vtotalcost + FREGT575 )
I am trying to put the grand total variable:
vgtotalcost2 = sum of vtotalcost2
It gives me the error: Sum of operand must be a column or variable
It is a variable. I have also tried with the period:
vgtotalcost2 = sum of .vtotalcost2
But it still gives me an error. Help!!
Dan Goldberg
