John: If your computations are all in the report footer, then you can pre-calculate the values into variables and just print the variables in the report footer. This will work only if you do not need to reset your variables at breaks. I have used this approach for a report where I had the same problems you have and I have not bothered to change it although I was under the impression that this problem had been resolved... Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] 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
