I desperately need help with this...I have searched and tried everything I know.
I have come across a group count error. I have created a data view web part using a linked source. The DVWP has only one level of grouping: Date.
My Group Totals are incorrect (with the exception of the last group on the bottom). And my Webpart total count is also correct.
I can't display a picture but my Data Veiw Web Part presently breaks down is something like this:
Date: 1/15/2012
Entry 1
Entry 2
Group Count: 0 (Wrong Count)
Date: 1/31/2012
Entry 1
Group Count: 0 (Wrong Count)
Date: 2/15/2012
Entry 1
Entry 2
Group Count: 2 (Right Count)
Total Count: 5 (Right Count)
What is frustrating is that all the group counts are based on the same formula then why are the first group counts wrong when the last one generates the correct value.
Group Count Code:
<xsl:template name="dvt_1.groupfooter0">
<xsl:param name="fieldtitle" />
<xsl:param name="fieldname" />
<xsl:param name="fieldvalue" />
<xsl:param name="fieldtype" />
<xsl:param name="nodeset" />
<xsl:param name="groupid" />
<xsl:param name="displaystyle" />
<xsl:param name="showfooter" />
<xsl:param name="showfootercolumn" />
<xsl:if test="$showfootercolumn" ddwrt:cf_ignore="1">
<t r valign="top" style="display:none">
<xsl:if test="$dvt_1_automode = '1'" ddwrt:cf_ignore="1">
<t h class="ms-vh" width="1%" nowrap="nowrap"></t h>
</xsl:if>
<t d class="ms-gb2 ms-altering" nowrap="nowrap"> Count : <xsl:value-of select="count($nodeset)" /></t d>
Total Web Part Total: This portion shows the correct value and uses:
<xsl:value-of select="count(/dsQueryResponse/soap:Envelope/soap:Body/ddw1:GetListItemsResponse/ddw1:GetListItemsResult/ddw1:listitems/rs:data/z:row)" />
I would greatly appreciate your help.