calling a Report from within Report
Posted: Wed May 17, 2006 9:14 pm
I have been tasked with merging two separate reports in Version8, which are stored with RP5 library format. (a legacy of our V6 era)____The first report is a "member statement". The Master Table has one member record per line. There are link tables vis Exacts, and a Scan. Currently the bulk of the data is reported in 2GH & 2GF, with 3GF showing Σ^s (totals) of the Scan table.____1GH (a group of members) banner page for the member group__2GH (once per member) lists member personal information__3GF multi lines of transaction types summed (over twelve months)__2GF lists additional personal information__1GF closing banner page for the member group____Report 2__Page Header (column headings)__Record (multi lines of transactions, (SCAN link) not the same as Report 1)__2GF multi lines based on transaction types____=============____The ideal would be to place a "function" or "procedure" at the end of 2GF of report 1, to "call" report 2. And yes report 2 has been specified (outside of my sphere of influence, I^m afraid) to be at the end.____=============__(sketch outline of appearence)____Members Personal Information (prints once)__(address, dates of interest)__Summary of a year of transactions (prints once)__(open balances of accounts, payments in the year, closing balances)__Summary of selected Investment (once per choice, ergo possible multi)__(upto twenty selections available, varies each member)__Closing details of Investment performence (prints once)__Listing of "payments in the year"__varying number of possible transactions, #accounts, #periods (100^s)____this above would be repeated for each member in the Master Table.____=============____It can be done that the separate reports do not use the same tables, which avoids any EXCLUSIVE/SHARE issues.