Has anyone every heard of 'Roll your own Level Breaks' in RPG? Can you enlighten me on how it works?
I have to mimic a program that does this already with a different set of data. Here is a basic overview of the application. A selection screen allows you to select a date range, region, territory, salesman, customer, product class, product, PDF or Excel output, print or email. Each 'flag' selected on the first screen takes you to another, i.e. Regional selections, Territory selections and so forth. As these selections are taking place, the results are being recorded in files. Then a job will submit to batch and build a master work file using the selections and pulling data from all over the place to en dup with a detail level file of all of the selections.
Next, the reporting process reads through the file, bounces(chains) for the selections, sorting, and setting internal fields to mimic level breaks, totals. This thing is using arrays, SQL to select the records from the detail file, a ton of fields(looks like output fields for each level.
I have never seen a program like this and its logic just hasn't clicked with me yet. Any thing you can tell me would be helpful.