https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/109297.aspxFri, 27 Jan 2017 21:29:06 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109297blkmagik0https://www.infopathdev.com:443/forums/thread/109297.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109297Thank you for all your help, yeah i need to figure out what i need to modify/exclude to fix the load issue. After testing it on sharepoint it works ( slow) if there is only one company listed, any more than that causes it to time out. Thanks for all your help, lll post if i find the solutionhttps://www.infopathdev.com:443/forums/thread/109296.aspxFri, 27 Jan 2017 20:01:35 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109296Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/109296.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109296Delete and re-add the section w/ your summary - There seems to be something wrong w/ it - I had the same issue trying to preview. The form is horribly slow tho - I'm guessing because of the huge data load. Not sure what to suggest on that.https://www.infopathdev.com:443/forums/thread/109295.aspxFri, 27 Jan 2017 19:46:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109295blkmagik0https://www.infopathdev.com:443/forums/thread/109295.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109295Ok that file had the updated expression, unfortunately when i previewed it, it didnt provide display any results. :( Not sure what im doing wrong. i removed the filers i originally had in the repeating section itself thinking that was the cause and it displayed every instance of the customer name that was saved within group 4 and also blank row for the extra default value fields i had.https://www.infopathdev.com:443/forums/thread/109292.aspxFri, 27 Jan 2017 19:11:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109292Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/109292.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109292Let's try again.https://www.infopathdev.com:443/forums/thread/109289.aspxFri, 27 Jan 2017 17:39:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109289blkmagik0https://www.infopathdev.com:443/forums/thread/109289.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109289i tested the attached file and it didnt produced any summary information when i ran the preview. Upon closer inspection i looked at the expression embeded in the file and it is sum(/my:myFields/my:group3/my:group4/my:AMT[../my:COMPANY = current()/my:COSUMMARY]) and not the updated expression you suggested. I think you send me the original file i provided youhttps://www.infopathdev.com:443/forums/thread/109287.aspxFri, 27 Jan 2017 17:25:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109287Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/109287.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109287Weird. Worked in my copy of the template. I'll attach it here.https://www.infopathdev.com:443/forums/thread/109285.aspxFri, 27 Jan 2017 17:11:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109285blkmagik0https://www.infopathdev.com:443/forums/thread/109285.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109285and in regards to your other inquiry, i have attached an image of the error message im getting when i run the template on sharepointhttps://www.infopathdev.com:443/forums/thread/109284.aspxFri, 27 Jan 2017 17:10:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109284blkmagik0https://www.infopathdev.com:443/forums/thread/109284.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109284I took your recommendation and deleted the COSUMMARY field and use the expression you provided but got an error message.https://www.infopathdev.com:443/forums/thread/109275.aspxFri, 27 Jan 2017 16:13:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109275Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/109275.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109275Also - I don't understand the default in COSUMMARY. Please remove that and change your AMTSUMMARY default to: sum(/my:myFields/my:group3/my:group4/my:AMT[../my:COMPANY = current()/../my:COMPANY and current()/../my:COMPANY != ""])https://www.infopathdev.com:443/forums/thread/109274.aspxFri, 27 Jan 2017 16:05:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109274Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/109274.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109274Can you attach a screenshot of the error, or the complete text?https://www.infopathdev.com:443/forums/thread/109272.aspxFri, 27 Jan 2017 15:24:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109272blkmagik0https://www.infopathdev.com:443/forums/thread/109272.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109272Thanks 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 present as it is variable and can start from 1 to potentially 500 lines of data.https://www.infopathdev.com:443/forums/thread/109270.aspxFri, 27 Jan 2017 01:42:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109270Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/109270.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109270You shouldn't be getting that error unless you have huge amounts of data. I'd assume there is something else wrong. Feel free to attach your template under the Options tab in a reply if you'd like me to take a look tomorrow.https://www.infopathdev.com:443/forums/thread/109269.aspxFri, 27 Jan 2017 00:01:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109269blkmagik0https://www.infopathdev.com:443/forums/thread/109269.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109269PS 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 they depend on.https://www.infopathdev.com:443/forums/thread/109268.aspxThu, 26 Jan 2017 23:55:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109268Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/109268.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109268You can manually fix that - it is an InfoPath bug. If you search on the message, you should find my blog post on manually fixing it up. Or you can take a look at the sample here, it uses a field w/ a calculated default: http://www.infopathdev.com/files/folders/examples/entry41116.aspxhttps://www.infopathdev.com:443/forums/thread/109266.aspxThu, 26 Jan 2017 23:35:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:109266blkmagik0https://www.infopathdev.com:443/forums/thread/109266.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=109266Thanks 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 try to run it from sharepoint it crashes. It seems to be isolated to this bug. If i remove the summary fields and reupload it without the error it goes back to normal and works