[RBG7-L] - Re: SET ZERO ON Required for reports?

[A. Razzak Memon]

At 03:19 PM 7/12/2004 -0700, Larry Lustig wrote:

Any suggestions?

Larry,

Here are a few suggestions:

01. When SubTotals or Totals are used as expressions in Reports,
    use the following approach:

    Example:

    CLEAR VAR vSubNetAmount,vSubFreight,vSubTax,vSubInvoiceTotal +
    vGrandNetAmount,vGrandFreight,vGrandTax,vGrandInvoiceTotal

    SET VAR vSubNetAmount CURRENCY = 0.00
    SET VAR vSubFreight CURRENCY = 0.00
    SET VAR vSubTax CURRENCY = 0.00
    SET VAR vSubInvoiceTotal CURRENCY = 0.00
    SET VAR vGrandNetAmount CURRENCY = 0.00
    SET VAR vGrandFreight CURRENCY = 0.00
    SET VAR vGrandTax CURRENCY = 0.00
    SET VAR vGrandInvoiceTotal CURRENCY = 0.00

    CLS
    PRINT SubTotalsAndTotals +
    OPTION SCREEN|WINDOW_STATE MAXIMIZED

    CLS
    CLEAR VAR vSubNetAmount,vSubFreight,vSubTax,vSubInvoiceTotal +
    vGrandNetAmount,vGrandFreight,vGrandTax,vGrandInvoiceTotal

02. Use "DBCalc" approach to define SubTotals and Totals without
    the overhead of defining expressions, if you can.

For a sample comparison test, take a look at the "SubTotalsAndTotals"
and "SalesSumAndSubTot" reports in ConComp sample database.

Hope that helps!

Very Best R:egards,

Razzak.