Say a report contains three columns: A, B and Total. To display subsummary and grand summary values for A and B, I would of course declare summary fields for both.

But for Total, is it more efficient to:

1) use GetSummary() calculations (ie adding together summary, subsummary and grand summary fields for A and :;

or 2) declare first a calculation field (total = field A + field : and then a summary field (summarizing "total")?

quote:

---

Originally posted by uvic_coop:

Say a report contains three columns: A, B and Total. To display subsummary and grand summary values for A and B, I would of course declare summary fields for both.

But for Total, is it more efficient to:

1) use GetSummary() calculations (ie adding together summary, subsummary and grand summary fields for A and :;

or 2) declare first a calculation field (total = field A + field : and then a summary field (summarizing "total")?

---

Either way works, but the second way requires more fields than the 1st option.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=