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: [email protected]
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.
