Thanks Tim,
That fits the bill very nicely.
Michael
Tim Rude wrote:
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
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
