InfoPath Dev

My Repeating tables Sum the data from the SQL Server database after I close and open up a new form. How do I make the Repeating tables instantly Sum up the data from the SQL Server tables. This might be something simple but I haven't done it before. Thanks.

You should be able to do this with a simple XSL sum() function. This has been discussed many times before on the forum, please use the search function in the top right to check out all the other threads.

This is the XSL sum() function I have came up with. Now Where to I place it??


<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:template match="/">
<p>ytdExpenses= <xsl:value-of select="sum(monthlyExpenses)"/></p>
</xsl:template>
</xsl:stylesheet>