InfoPath Dev

I took your recommendation and deleted the COSUMMARY field and use the expression you provided but got an error message.

Thanks for looking into this. As i mentioned it work in preview more but fails in sharepoint. I know that part of the issue with the amount of data comes from the default values under group 3 as i had to create 200+ instances of it im wondering if there is a way to adjust the form so it doesnt fail due to the amount of data that might be ...

PS the template runs very slow with the addition of the calculated fields. Works if there is only 1 company record but if there are 2 or more i get this error The form could not be displayed because default values or rules are taking too long to evaluate. To correct this, simplify the expressions or reduce the size of the data sets that ...

Thanks Hilary, Thanks for that sample you provided, I managed to get it to work to a limited degree. Unfortunately when i converted the Subtotal Amount field to a calculated value, i got an error advising me that the control binding is not supported and allow me to upload it to the sharepoint. I attempted to upload the template but when i ...

Hi Hilary I would like to request your assistance on a little issue i'm having with my form. Since the last time i contacted you there was a recomended need to add summary subtotals to the original form. I originally used a Dropdown list box with a secondary field to calculate the total amounts for each customer name identifed from ...

That Works!!!!! thanks you are awesome.. i cant believe that d before company was the cause of my problems. Again appreciate your time, patience and expertise.

Yes Company exist in the sharepoint list items Hes is the list of fields in the sharepoint list COBA COMPANY (xpath /dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:COMPANY) CUST INVNO INVDATE AMT COMMENT WOTYPE ID here is the list of fields for group4 COPY (attribute field) COMPANY (xpath ...

 Yes COMPANY is a field in group4. I made the recommended change but now im getting an error of  "xdXDocument:GetDOM("WriteOffQueryData")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/COMPANY" does not point to a valid location path of a field or group

   Hilary  I managed to get the button to work. It copies the data to the repeating table destination  however it duplicates and concatenates all the data for each of the rows I have set.  I played around with it  and understand that I has to do with the syntax I am using in for the xpath formula. So ...

 Thanks Hilary, This looks promising, I seem to understand the concept. However im not quite clear how you managed to set up the rules for the button and the copy attribute field. For the button I see a value of 1 but I don't know how this was created or what it is referring to For the copy attribute field. i'm ...