John - You could see if you can calculate the variables before you run the report and then just place these global variables in the report footer.
i.e. SELECT (SUM(Column)) + INTO vVariable + FROM (same table/view as the report) + WHERE (same WHERE CLAUSE as the report) AND - be sure to submit an example to RBTI so they can fix the problem! Sami -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Docherty Sent: Friday, March 11, 2005 1:23 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Resetting of variables in reports after preview Eva, Sami I have changed to the DBCalc method where possible, however the problem is where I want to use a �sum of� multiplied by another variable to create another value to be displayed on the report footer. If there was a method of assigning the value from a DBCalc object to a variable, which I could then use in my simple calculation, then that would solve the problem, but presumably there is no way of doing this ? Regards, John Docherty _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Eva Kis Sent: Friday, March 11, 2005 11:07 PM To: RBG7-L Mailing List Subject: [RBG7-L] - AW: [RBG7-L] - Resetting of variables in reports after preview John, I had the same problem since R:Base 7.x with SUM OF - variables in reports, wich I created in older versions. The solution for me was, to replace all SUM OF variables with the DBCalc - object for each break an column separately. Since then works my reports fine. Regards Eva Kis H�ssy Engineering GmbH Stadtturmstr. 13, CH-5401 Baden, Switzerland Tel. 056 210 91 71, Fax 056 210 91 75 HYPERLINK "mailto:[EMAIL PROTECTED]"[EMAIL PROTECTED] -----Urspr�ngliche Nachricht----- Von: John Docherty [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 10. M�rz 2005 08:31 An: [email protected] Betreff: [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 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
