I second what great examples these are - I was having trouble with totals in a converted report and these made it clear what to do!
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: Monday, July 12, 2004 7:32 PM Subject: [RBG7-L] - Re: SET ZERO ON Required for reports? > > 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. > >
