Thanks for that Gary - it also sorts out the problem with the print preview, however having to predefine the variables is not the most convenient way of doing things. Hopefully this will be modified at some stage.
Regards, John Docherty -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, 28 September 2004 12:02 p.m. To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Sum of problem in reports I had the same problem this week. Here is what I did before running the report.... 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 > >
