Is this a "Variable Label" object or a "DB Calc" object? Was the report created in R:base 7.1 or converted? If it is not a DB Calc object I'd recommend recreating the variable as a DB Calc and see if the problem is solved.
I've seen this problem before soon after I started using 7.1 with converted reports. Moving through the pages in the preview mode before printing seemed to create the issue. I haven't seen this problem in a long time but I have switched to DB Calc objects for all of my summing variables. Jim Buddemeyer >>> [EMAIL PROTECTED] 03/11 2:42 AM >>> Sami, Thanks for your suggestion, however I am still not having much success. The variable that I am having trouble with is in the report footer, so I need to be able to reset that variable after the preview, but there appears to be no way of doing this. If there was an option to choose which variables are reset at the RF level, then I imagine that the problem would disappear (or have I missed the point here somewhere ?) Thank you. Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sami Aaron Sent: Friday, March 11, 2005 8:01 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Resetting of variables in reports after preview John - I noticed in your first post that you mentioned that the problem was in SUM OF variables. Why don't you change those to be: If your column you are summing is "ColumnA' then create this variable at the Detail Level Report Footer: rSUMColumnA = (.rSUMColumnA + ColumnA) Break Footers: rF0_SUMColumnA = (.rF0_SUMColumnA + ColumnA) --and mark this one to reset at level F0 rF1_SUMColumnA = (.rF1_SUMColumnA + ColumnA) --and mark this one to reset at level F1 Etc. Sami ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Docherty Sent: Thursday, March 10, 2005 12:32 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Resetting of variables in reports after preview Dawn, I am using 7.1.80.30221. I have tried it with variables defined in the report, and I have just modified this to define these in an EEP which initiates the printing * same result. I have found that on some occasions this doesn't happen and I do get the correct values, but when & why this occurs is something of a mystery so far. Thank you for your response. Regards, John Docherty ________________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Oakes Sent: Friday, 11 March 2005 12:24 a.m. To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Resetting of variables in reports after preview John, Which update are you running? I believe there was a bug fix in update 79 that took care of the preview to printer calculation issue. Also, are you predefining your variables before the report or are they just defined in the report itself? Dawn ________________________________________ From: John Docherty [mailto:[EMAIL PROTECTED] Sent: Thursday, March 10, 2005 2:31 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Resetting of variables in reports after preview I often print reports from the preview facility, however I find that totals which are calculated based on user defined 'sum of' variables end up being doubled if the report is subsequently sent to a printer from the preview (the totals in the preview also double after printing). I have Clear Variables After Printing turned on. Is there any way that this problem can be overcome ? Any suggestions would be welcomed. Thank you. Regards, John Docherty -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.1 - Release Date: 9/03/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.1 - Release Date: 9/03/2005 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.1 - Release Date: 9/03/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.1 - Release Date: 9/03/2005
