I can finally attach files to my posts so here it is. The Zip file contains the form (in Acrobat 7.0.5 Dynamic PDF format) as well as an XML data file which holds the data to import into the form (this data was taken from one of your earlier replies to this thread).
It took me a while to figure this one out simply because of a lot of event timing issues (when events fire as well as when changes specified within those events actually take place). In the end, I've got a solution that works.
Open the sample form in Acrobat. Click on the
Load Data button . This will open the Import Data dialog from which you should pick the XML data file included in the solution. The result will be the groupings and summations you're looking for.
This was achieved by iterating through data records in the data DOM after importing the data into the form and using the TableRow object's Instance Manager to generate new instances of the TableRow object for each grouping/summation.
The tricky part was how to get the code which groups the data to execute only once the data had been imported. This was achieved by placing that code on an invisible field's Validate event and using a combination of boolean properties to determine whether we should group the data when the Validate event would fire (because the Validate event fires when the form is first opened, as well as every time the form is modified and we don't want to group the data every time a Validate event fires).
The key was setting the ImportData text field's Comb property (a boolean property) just before importing the data because this property change would take effect immediately as opposed to only after letting Acrobat import the data and fire the Validate event. Note that the Comb property is a property of the AcroForm Field Object which represents the XFA Form Field Object in Acrobat's Scripting environment. That's why we need code like this to get to it:
event.target.getField("form1[0].#subform[0].ImportData[0]").comb
Note that this solution assumes that you're importing data into the form by selecting a data file to import in Acrobat (so all this is occurring on the client side). If, in your particular case, the data is being merged-in on the server and then the resulting form is being served to the client, then you wouldn't need to do all this "jumping through hoops". All you would need to do is take the code within the "//// Server-side START ////" and "//// Server-side END ////" delimiters inside the ImportData field's Validate event and put it into the form's (form1 in this case) Form:Ready event. That's it. Things obviously get quite difficult when we do everything on the client side.
If you have any questions, please let me know.
Stefan
Adobe Systems
