I'd like to have a button on my form to quickly calculate the sum for a money field for all records in the current results batch. The command @FormGetValues() in combination with @SumListValues()  works fine, but is too slow when dealing with large batches (more than 500 records, flat database, no sub-records.).

I would like to make use of the speed of XResultSet commands to present this easy calculation to the user (in a writeln window or in a static LE on the form), based on any results batch that a user chooses to retrieve. However, the documentation (and my limited knowledge) for XResultSets leads me to believe that these powerful commands only create and work from a 'virtual' set of records that reside in Sesame memory, and are not 'visible' to the user and must be retrieved using programming.

Am I way off base here? Any suggestions are welcome.

Sincerely,
Steve

Thanks Erika. Our reports have always been very specific to certain result sets, but I can see now how a more generic report could be used for a variety of purposes.

Simple and effective. Thanks for enlightening me!

Steve