Thanks Razzak. I knew there was more documentation than I was finding. I completely forgot about the regular Rbase 7.6 directory, since I've been using the enterprise edition. I do want to bone up on the GetProperty logic after the bulk of this conversion I'm doing. But I finally figured out the problem. I had zero set off. (four hours for such a simple thing) Patti
--- On Mon, 7/28/08, A. Razzak Memon <[EMAIL PROTECTED]> wrote: From: A. Razzak Memon <[EMAIL PROTECTED]> Subject: [RBASE-L] - Re: Subtotals in Reports To: "RBASE-L Mailing List" <[email protected]> Date: Monday, July 28, 2008, 5:24 AM At 12:55 AM 7/28/2008, Patti Jakusz wrote: >I can't figure out what I'm doing wrong. Patti, A few suggestions: 01. Pre-define all variables (with correct Data Type) as NULL using the "Before-Generate..." action in report designer. Report Designer | Main Menu | Report | Actions | Before Generate .. -- Example: SET VARIABLE vCount INTEGER = NULL SET VARIABLE vSubTot INTEGER = NULL SET VARIABLE vGrTot INTEGER = NULL 02. Re-visit all report "Breaks", if defined, and make sure that all appropriate variables are "Reset" accordingly. 03. Make sure that the option for "Clear Variables After Printing" is checked. Report Designer|Main Menu|Variables|Clear Variables After Printing >I don't want to use DB Calc, because I want to use the subtotals in >other expressions. Actually, you can, using the supported GETPROPERTY command in reports. Take a look at the "Capturing DBCalc Results as Variables in Reports", sample application, included in the Super Advanced Training CD. Also, to understand the proper use of report "Sub-Totals and Grand Totals" (DB Calc vs SUM OF colname), take a look at the "SubTotalsAndTotals" report included with the Running R:BASE Your Way! (Part 14), included with the full installation of R:BASE 7.6 for Windows. Here's a report that demonstrates everything! http://www.rbase.com/rbg76/reports/SubTotalsAndTotals.pdf Notice the "Sub-Total and Grand Total Using DB Calc Option" versus the "Sub-Totals and Totals Using SUM OF Option". Hope that helps! Razzak.
