Oh sorry, Doug, I didn't read that you're summing variables not columns. And yes I always assume that "preview" means from within the designer, but I think it's correct to use it in the way you are.
I honestly can't remember the difference between "before preview" and "before generate". I think I've always done Before Generate. It would be nice if someone could explain to me what the difference is. But in your case I would make sure to initialize your summing variable to 0 in the "before generate" eep. Karen > Thanks Karen - I don't think DBCalcs will sum variables, only columns, > but CMIIAW (Correct Me If I Am Wrong). > And this anomaly is not in preview mode of report designer, it's the Print > Preview from PRINT IFTACharge WHERE &vWheClause OPTION SCREEN. > And now you've raised another question: Does Preview (as in Before Preview > and After Preview EEPS) refer to Preview in Report Designer or the Print > Preview with the OPTION SCREEN? > > Back to the original issue - I'd thought about creating a view with > calculated columns so I could use DBCalcs vs summing variables, but that's > going > to be a time-consuming rewrite; I was hoping I'd just missed a click-box in > Report Designer somewhere. > D
