I have a report that I need to run that goes like this...
Find Uninvoiced Orders that are due for production current month and then push summarized salesperson totals somewhere.
Do same for next month.
Do same for next, next month.
Do same for orders "on hold" (due dec 25)
Find invoiced orders current month.
"Somewhere" has been text files dumped into the Temporary directory - I export Salesperson, Month and the sorted Summary field of their order total values.
Then I reimport them into a reporting table where I can show a grid by Salesperson with global lables etc.
It works but I rather a pita to tweak. Thus my question is "Could I have been somewhat brighter in my approach?" Writing the summaries into variables is appealing but, as of yet, beyond me.
"Approximately impossible..." --- LHC Physicist Guido Altarelli