Data Veiw Web Part Shows Wrong Group Count - SharePoint 2010
-
I have searched many places and could not find a solution to my problem. I created a Linked Source to connect and create a view for multiple lists. I then created a page displaying my data view web part. Perfectly good up to think point. Then I tried to group my data view web part by date and added a header and footer for the group. The data is now showing in groups, the issue is that the group footers display the wrong count (with exception of the last group which shows the correct count). I also added a footer for the web part and the count is also correct for the Total data set/web part. I don't understand why the group count for all the groups is zero (with exception to the last group from the bottom).
-
I have searched many places and could not find a solution to my problem. I created a Linked Source to connect and create a view for multiple lists. I then created a page displaying my data view web part. Perfectly good up to think point. Then I tried to group my data view web part by date and added a header and footer for the group. The data is now showing in groups, the issue is that the group footers display the wrong count (with exception of the last group which shows the correct count). I also added a footer for the web part and the count is also correct for the Total data set/web part. I don't understand why the group count for all the groups is zero (with exception to the last group from the bottom).
As I mentioned above 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 know very little about the code. But I have played with it to make some sense of it. I would appreciate if you can propose a solution. 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. My Group footer code is: <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>ms-altering" nowrap="nowrap"> Count :<xsl:value-of select="count($nodeset)" /></t d> And the code for my DVWP Footer which displays the total number of items in the web part is (the count for this part is correct): <xsl:value-of select="Count**(/dsQueryResponse/soap:Envelope/soap:Body/ddw1:GetListItemsReponse/ddw1:GetListItemsResutl/ddw1:listitems/rs:data/z:row)**" />