getting subsummary data into one text field

[Reed]

I'm going to apologize in advance for the extremely long post, but I'm really stuck here and I'm hoping someone can help me out.

I have created a report that breaks down sales by account number, and contains subsummary parts broken out by different customers who use the same account. I'm pretty sure that the only way to get the subsummary values into fields that can be used in calculations and scripts is to export the data to another file and reimport the data into a file that contains the scripts and calculations that you want to use. (Can anyone tell me if there is another way?)

I'm sure everyone is familiar with how the subsummary data is formatted in the export.fp5 file, but I've attached my example file here anyway. My file has a script that consolidates all of the subsummary data into one text field in each "parent" record. (If anyone knows a way to set this up using self-joins and a single calculation field, I'm all ears... I can't see a way to do it) The way I do it in the script follows:

(Basically the script has a couple of loops that navigate to the records that contain the subsummary data and uses copy and paste to consolidate that information into the proper parent record.)

Freeze Window

Go to Record/Request/Page

[ First ]

Loop

If [ not IsEmpty(Budget Number) ]

Set Field [ all_info_summary, budget_quan_charge ]

Insert Calculated Result [ all_info_summary, "

export.fp5.zip

[CobaltSky]

Hello Dana,

I believe it would be worth your while to investigate the GetSummary( ) function.

Check in the FileMaker help file for a description of how to use it. You will find that you can set up your script to write the sub-summary values using GetSummary( ), or alternatively, incorporate them directly into your calculations without using a scripta at all (though you will still have to sort the db by the 'break field' in order for the sub-summary values to calculate).

[Reed]

thanks again! This forum is really a great place to get help. Hopefully I'll be able to post some helpful info here one of these days.