Bernard, Thanks for your response - I use DBCalc where possible however I do some additional calculations in the report footer, hence I have to use 'sum of'. I have sent my database to RBTI so hopefully they will be able to tell me if I am doing something wrong.
Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Sunday, March 13, 2005 2:30 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Resetting of variables in reports after preview John, Try using dbcalc instead of sum of That fixed it for me. Bernie Lis ----- Original Message ----- From: "John Docherty" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, March 11, 2005 3:42 AM Subject: [RBG7-L] - RE: Resetting of variables in reports after preview 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 --- RBG7-L =======================3D======================= D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D======================= D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D======================= D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D======================= D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D======================= D= -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.2 - Release Date: 11/03/2005
