Michael, In order to be able to sort the report by the Receipt Number (regardless of which panel the payment record comes from), you're going to have to first combine the records into one panel. However, this doesn't mean that you have to permanently do this or abandon your database structure as you have it now.
Create a new panel to hold temporary records. No user need ever see this panel so it doesn't have to be pretty. Include on this panel all of the fields you need to produce your report (i.e. Receipt Number, Name, Payer Type [Advertiser or Subscriber], Amount, etc.). Create an index to sort by Receipt Number. Then create a report based on this Temporary Panel that does the following: 1) First delete all records (if any) in Temp Panel 2) Using virtual subreports, go through each of your two separate Advertiser and Subscriber panels and copy relevant fields from the records you wish to include in the report to records created in the Temp Panel 3) Generate the actual printed report from the records now in the Temp Panel 4) Clean up Temp Panel by deleting all records from it (to conserve database size) It will take a little fiddling to set it up, but once it's done the user can just run the report to complete the entire process seamlessly. Tim Rude ----- Original Message ----- From: "Michael Iannantuoni" <[EMAIL PROTECTED]> To: "DataPerfect Users Discussion Group" <[email protected]> Sent: Tuesday, May 01, 2007 6:41 AM Subject: [Dataperf] Totalling across Panels > I have a database in which I have a Contacts panel which has Panel Links > to two payment panels, one for Advertisers and one for Subscribers > (these are kept as separate panels because Advertiser & Subscriber > payments follow a different structure). Each payment in both sub panels > has a Receipt Number and I have indexes based on these Receipt Numbers > so that I can sort by Receipt Number and total payment from a given > Receipt Number up to the latest. This works fine within each sub panel > but what I would now like to do is set up a report to list in Receipt > Order & total payments across BOTH panels. ie to produce a list like this: > > *Receipt Name & Amount* > 0221 Smith (Advertiser) £20 > 0222 Jones (Advertiser) £30 > 0223 Brown (Subscriber) £6 > 0224 Walker (Advertiser) £20 > 0225 Dexter (Subscriber) £6 > > Total: £82 > > Anyone any ideas on the best way to do this please? > > TIA > > Michael > > ---------------------------------------------------------------------------- ---- > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf > _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
