Doug: AFAIK the report previewer has always acted that way. The "old fashioned" summing variables (rather than DBCalcs), are never cleared when you use the "preview" tab of the report designer so they constantly double themselves. And they usually stick around when you exit the report designer so you must clear them if you intend on printing the report from outside the designer right away. As long as those variables are initialized to 0, or cleared, before the report runs you should be okay (to be sure, initialize them in the before generate). Any reason you can't use DBCalcs instead?
Karen > I (think I) know it's because the variable totals aren't being cleared, > but I can't figure out how while staying in the preview mode. > The larger questions is why are they compounding? I thought once a > report was generated for preview, the static results were displayed. > But the report appears to be recalculating on next/prev page and when > sent to a printer. The printed report is correct - most of the time; > client says sometimes not, but I haven't taken the time to confirm. I > figure once I get the problem resolved in preview, the printed report > will be OK.
