Re: Outputting the contents of cursors in a Report Summary

Author: Ken Dibble

Posted: 2015-07-01 at 19:25:56

>Is there a way to read the cursors into arrays when the form initializes?

SELECT * FROM MyCursor INTO ARRAY aMyArray

Autocreates the array if it doesn't exist. But you can reference as

many different distinct data sources as you have fields in the

report, as long as they are in scope, so I don't see why you would

prefer arrays to cursors in that case.

If you want the execution of the report itself to generate the

summary data then the report variables are the way to go.

Though I agree with the people who say: Denormalize and process

everything down to one or more cursors, perhaps, say, one cursor per

detail band, and one cursor for header and summary data, before

running the report. It's a lot easier to understand, and it has the

advantage of being portable in case you need the same or similar data

in a radically different report layout.

Ken Dibble

www.stic-cil.org

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/62.38.14080.46984955@cdptpa-oedge02

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2015 Ken Dibble