I've almost completed converting an Alpha Four app to Alpha Five. I'm down to one final summary report. This report was initially created in Quick Basic because the developer could find no way to produce it in Alpha Four. I seem to be having the same issue in Alpha Five. Essentially there are three parts on the report: a summary of various billable transaction types identified by a two-character code; a summary of non-billable (maintenance) items of which there are only four; a late-charge detail of varying size. The simplest method I came up with has all the transactions in one table and a report consisting of a single detail section for the first section and two sub-reports for the other two sections. The first two sections work just fine but the third (second sub-report) comes up empty. I finally found the reason to be the initial section filters all transactions except "LD" (late-charge detail). In the second sub-report when I try to filter on only "LD" transactions it doesn't find any ... because they were excluded in the main part of the report.
I subsequently created a "summary" set and added two more extract tables: one for the maintenance items and one for the late-charge detail. I fudged the invoice types in the linked tables to match the type of a single summary record in the primary table. It doesn't matter which, the idea was that when the report found the type in the primary table it would pick up the matching items in the linked tables for the sub-report sections. Voila. I have three sections exactly as I wanted except ... in the first summary section I now have a summary item for each detail item in the linked tables!!
I've attached a zip file with the set (and hopefully the report (layout?) based on the set), a PDF of the old Alpha Four report and a PDF of what I'm now getting with my last attempt in Alpha Five. I've been working on this for five days and it's driving me nuts. Any thoughts?
I subsequently created a "summary" set and added two more extract tables: one for the maintenance items and one for the late-charge detail. I fudged the invoice types in the linked tables to match the type of a single summary record in the primary table. It doesn't matter which, the idea was that when the report found the type in the primary table it would pick up the matching items in the linked tables for the sub-report sections. Voila. I have three sections exactly as I wanted except ... in the first summary section I now have a summary item for each detail item in the linked tables!!
I've attached a zip file with the set (and hopefully the report (layout?) based on the set), a PDF of the old Alpha Four report and a PDF of what I'm now getting with my last attempt in Alpha Five. I've been working on this for five days and it's driving me nuts. Any thoughts?
Comment