https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/7542.aspxTue, 23 Aug 2005 08:47:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:7542tatopitta0https://www.infopathdev.com:443/forums/thread/7542.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=7542Hi mmahmoud,<br />in the datasource I'd try to move the sub-totals outside the group where they are (for example putting them in the same group of grand-total) leaving them in the original optional secting.<br />Bye!https://www.infopathdev.com:443/forums/thread/4871.aspxTue, 23 Aug 2005 07:53:03 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:4871mmahmoud0https://www.infopathdev.com:443/forums/thread/4871.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=4871I have 13 optional section inserted with repeating table and each<br />section has a subtotal field in it.<br /><br />At the end of the form I have a grand total box, which is the sum of<br />all the sub-totals in the optional sections.<br /><br />However, the grand total doesn't show up unless i open all the 6<br />optional sections. But I don't need all 6 to open at one time. Some<br />time I need 2 or 4 sections only.<br /><br />So how can I show the grand total, without opening 2 or 3 sections in<br />my form.