I have a report with SUM(MyColumn) type expressions to gather totals to display in the BREAK and REPORT FOOTER sections.
They do not calculate (they stay NULL) if ZERO is SET OFF. If I SET ZERO ON they're OK. Two problems: 1. I do not remember having ZERO ON as a requirement for doing sums. Has this always been true, is it a new rule in RB7, or am I doing something else wrong? 2. None of the (two) records in my table have a NULL value in the field I am SUMming -- they all have data (it's a CURRENCY column). Any suggestions? -- Larry
