Summary Report Help

[Kristen]

I have 2 related files Donor.fp5 & Buyer.fp5, related buy the relationship BuyerNumber(Donor::BuyerNumber = Buyer::BuyerNumber). I want to create a summary invoice. I want the report to run from Donor, based on the found set of records. If the buyer purchased 3 seperate items I would like the reoprt to show each individual item, the charges for the item, and the subtotal for the item, and then at the bottom, the total amount due for all charges combinded. (basically a total of all the individual itme net) I know this is possibl, but my md has gone blank. Thank you.

[Riley Waugh]

Generally, reports are generated in the child file (in your case, the Buyer file). Here you can find the buyer you want, list the transactions in list view in the body, and use all the summay fields, sub-summary parts, and trailing grand summaries you want. The summary report can, of course, be called by a script in the Donor file... you don't need to know that you are printing from the other file.

[Kristen]

I am trying that approach, but I am having a problem. If there are more than one related records in the donor file (buyer bought multiple items), the report, (being created in buyer) only shows the information from the first related record. I have it using fields through the relationship, but it does not show all of the related reocrds. Humm...

[-Queue-]

Kristen, on your report layout click the View menu and select View as List, if you haven't already.

[Riley Waugh]

Kristen,

in the Buyer file do a find for whatever the relating field is that relates you to the Donor file (so that you will find all the records). Or perhaps you need to just do a find for the buyer.

You can, write a script in the Buyer file [sort_me]that sorts by the sort field for your sub-summary part.

now, in the Donor file write a script that, based on your relationship, includes:

Go to related record [show only related]

Perform Scrip [sub-script, External: "Buyer.fp5"

This should get you there with the records you want in the found set.

Keep trying, we'll get there. If you're lost (my directions aren't that good) email me the file and I'll look at it.

[Kristen]

I did a test, and created the report in DONOR instead of BUYER and it works GREAT!!! Is there any "harm" in running the report here instead of Buyer?