Razzak, David, Dawn, Thanks for your responses. I have been looking at the sample, and my report, and I am trying to work out what the difference is, but apart from my report having four break levels, and no variables being reset at any break levels, (because there is no requirement to do this), I can see little difference.
The problem with mine is that the 'sum of column' variables just keep on getting doubled up every time the report is printed, so after the print preview, the numbers are incorrect. (The DBCalc ones are correct though, but I can't access those values unfortunately to get my combined totals.) The two variables that are wrong are simply defined as follows:- 7 : CURRENCY : D : vtlab = sum of splab 8 : CURRENCY : D : vspmatl = sum of spmatl I have the report set to 2 pass and the variables are predefined and set to zero and SET ZERO is on. The method suggested by Sami and Javier works fine, but that somewhat upsets the integrity of the report. Any further suggestions would be most welcome. Regards, John Docherty -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David M. Blocker Sent: Sunday, March 13, 2005 3:26 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Resetting of variables in reports afterpreview John I tried the report Razzak suggested and it DOES do what you want it to - did you ever doubt it? - but note two keys: In the sample report pass setting is TWO pass For the variables to work, you must either pre-define the variables to value zero before you print, or SET ZERO ON David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, March 11, 2005 11:10 PM Subject: [RBG7-L] - RE: Resetting of variables in reports afterpreview > > At 03:42 AM 3/11/2005, John Docherty wrote: > > >... 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. > > John, > > Take a look at the sample "SubTotalsAndTotals" report in > ConComp database. This particular report demonstrates the > use of classic "SUM OF" options used in "Break Footer" > as well as "Report Footer". > > Database: ConComp > Report: SubTotalsAndTotals > Associated Table/View: SalesData > Command File: Reports13_SubTotalsAndTotals.RMD > > Hope that helps! > > Very Best R:egards, > > Razzak. > > -- 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.2 - Release Date: 11/03/2005
