>I like the idea of preprocessing the file. VFP7 with it's 'updatable cursors' should be a big help with that approach...
>
>Todd
Hi Todd & Nadja,
My 'vote' also goes for preprocessing, but just for record, you don't need
VFP 7 to do that. All you need is create cursor command !
You simple open all your tables in one datasession (See Session base class that came with VFP6/SP3) relate them as you are pleased , run your ranges, filters, calculations or whatever, preparing at the end cursor (or group of related cursors) suitable for PRESENTATION by frx.
This gives you all flexibility you will ever need!
I used in the past one more solution, which was working by calling UDFs at every group level and doing alternative totalling in predefined array that was covering all report bands. e.g. six group levels would need array with 7 rows and columns as you need them, but I gave it all up in favour of cursors & session objects.
Good luck.