Greetings,
I need a "Report Writing Guru" !
I have a Client File that contains over 1.2 million records. These are an extract of an A/R System that contains such things as the System_No, Divison_No, Acct_No, Billing_Name, some Classification_Codes, Totals, Aging Buckets (Current, Over30, Over60, etc.) and a Grouping Code. I need to determine the Top 50 consolidated accounts (By Grouping Code) ! !
If this were under 65,000 lines (with subtotal lines...), in Excel I could sort, by the Grouping Code and then do a Sub_total on the Grouping Code and sum the buckets and the Total column.
Then by collapsing the detail levels to Sub-Totals only (by clicking on the "2" at the top left of the Spreadsheet area) I could do a Descending Sort on the Totals Column (which results in a Paragraph Sort) so that once I clicked on the "3" again (so all detail could be seen) I would have the accounts grouped in Descending Dollar sequence with the respective detail right with the Descending Totals.
Now, is there any way to accomplish this in Alpha5 without writing summary records, and then using the summary records to write the 1.2+ million records to another file, already in Descending Group Sequence so that I could produce a Top 50 report.
I have banged my head for a couple of hours today on this and it feels so much better at the moment while I am not smaching my head... can anybody help here?
Regards,
Keith
I need a "Report Writing Guru" !
I have a Client File that contains over 1.2 million records. These are an extract of an A/R System that contains such things as the System_No, Divison_No, Acct_No, Billing_Name, some Classification_Codes, Totals, Aging Buckets (Current, Over30, Over60, etc.) and a Grouping Code. I need to determine the Top 50 consolidated accounts (By Grouping Code) ! !
If this were under 65,000 lines (with subtotal lines...), in Excel I could sort, by the Grouping Code and then do a Sub_total on the Grouping Code and sum the buckets and the Total column.
Then by collapsing the detail levels to Sub-Totals only (by clicking on the "2" at the top left of the Spreadsheet area) I could do a Descending Sort on the Totals Column (which results in a Paragraph Sort) so that once I clicked on the "3" again (so all detail could be seen) I would have the accounts grouped in Descending Dollar sequence with the respective detail right with the Descending Totals.
Now, is there any way to accomplish this in Alpha5 without writing summary records, and then using the summary records to write the 1.2+ million records to another file, already in Descending Group Sequence so that I could produce a Top 50 report.
I have banged my head for a couple of hours today on this and it feels so much better at the moment while I am not smaching my head... can anybody help here?
Regards,
Keith
Comment