At 09:18 AM 11/18/2010, [email protected] wrote:
Doug: AFAIK the report previewer has always acted that way.
I don't think so.
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?
Take a close look at the "SubTotalsAndTotals" report included with
RRBYW15, RRBYW16, and RRBYW17 to explain and understand the CORRECT
use of "DB Calc vs SUM OF colname".
This specific report will help you understand the proper logic and
routines to initialize all variables when used as traditional SUM
OF varname, etc.
While in Report Designer, Runtime, or printing report with OPTION
SCREEN, should ALWAYS provide you with consistent results.
Very Best R:egards,
Razzak.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
