I need to have SPGridView with Totals and Counts how can i set that up? I dont even know where to start... <div><br/></div> <div>I have Sorting&amp;Filtering and Grouping and also paging but if i try the SPGridViewPager i get an ArgumentNullExp in container.</div> <div><br/></div> <div>Can anyone help me on there two issues?</div> <div><br/></div> <div><br/></div> <div> <div><br/></div> <div><br/></div> <div><br/></div> <div><br/></div> </div><hr class="sig">http://pontodepartilha.blogspot.com© 2009 Microsoft Corporation. All rights reserved.Tue, 07 Jul 2009 13:26:42 Zdb2b346b-52f7-4f8a-8129-800e9fea9951http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/db2b346b-52f7-4f8a-8129-800e9fea9951#db2b346b-52f7-4f8a-8129-800e9fea9951http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/db2b346b-52f7-4f8a-8129-800e9fea9951#db2b346b-52f7-4f8a-8129-800e9fea9951Pedro Mateushttp://social.msdn.microsoft.com/Profile/en-US/?user=Pedro%20MateusI need to have SPGridView with Totals and Counts how can i set that up? I dont even know where to start... <div><br/></div> <div>I have Sorting&amp;Filtering and Grouping and also paging but if i try the SPGridViewPager i get an ArgumentNullExp in container.</div> <div><br/></div> <div>Can anyone help me on there two issues?</div> <div><br/></div> <div><br/></div> <div> <div><br/></div> <div><br/></div> <div><br/></div> <div><br/></div> </div><hr class="sig">http://pontodepartilha.blogspot.comTue, 26 May 2009 17:16:04 Z2009-05-26T17:16:04Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/db2b346b-52f7-4f8a-8129-800e9fea9951#d8ea0f12-0eb1-4b17-b437-0aa1afb6f877http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/db2b346b-52f7-4f8a-8129-800e9fea9951#d8ea0f12-0eb1-4b17-b437-0aa1afb6f877André Lagehttp://social.msdn.microsoft.com/Profile/en-US/?user=Andr%u00e9%20LageHi,  <div><br/></div> <div>Where you need you SPGridview, &quot;WebPart&quot;,&quot;ASPX Page&quot; have connection to Other Database?</div> <div>here a nice example:</div> <div><a href="http://blogs.msdn.com/powlo/archive/2007/02/25/displaying-custom-data-through-sharepoint-lists-using-spgridview-and-spmenufield.aspx">http://blogs.msdn.com/powlo/archive/2007/02/25/displaying-custom-data-through-sharepoint-lists-using-spgridview-and-spmenufield.aspx</a><br/></div> <div>Can you use Sharepoint Designer &quot;Data view&gt;Manage Data sources&quot; there you can make connection to SQL and other database and use the Datasources, or want to create a WSP file, to create your custom code. </div> <div> </div> <div><br/></div> <div>Hope this help....</div> <hr class=sig> André Lage Microsoft SharePoint and CRM Consultant<br/> Blog:<a href="http://aaclage.blogspot.com">http://aaclage.blogspot.com</a><br/> Codeplex:<a href="http://spupload.codeplex.com/">http://spupload.codeplex.com/</a>Tue, 26 May 2009 17:33:56 Z2009-05-26T17:36:23Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/db2b346b-52f7-4f8a-8129-800e9fea9951#cf607ee5-eb40-4448-8959-682677add992http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/db2b346b-52f7-4f8a-8129-800e9fea9951#cf607ee5-eb40-4448-8959-682677add992Pedro Mateushttp://social.msdn.microsoft.com/Profile/en-US/?user=Pedro%20MateusThanks for the help, i have already done that, i have a custom aspx with an custom webpart and inside i have spgridview getting data from external sql. In this post : http://blogs.msdn.com/powlo/archive/2007/03/23/adding-paging-to-spgridview-when-using-custom-data-sources.aspx there's a link in the comments(http://ketulpatel.wordpress.com/2008/06/06/custom-paging-in-spgridview-extending-spgridviewpager/) on how to use SPGridViewPager but it doesnt work when you have spgridview.AllowGrouping = true. But thats not really a requirement, its just something i would like to do, it looks better than the &quot;1 2 3 4&quot; Pager.<br/> <br/> My main problem is that i havent found any reference about having Totals and Counts in SPGridView...just in EndUserSharePoint.com something about jQuery...<br/> <br/> <br/><hr class="sig">http://pontodepartilha.blogspot.comTue, 26 May 2009 20:22:30 Z2009-05-26T20:22:30Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/db2b346b-52f7-4f8a-8129-800e9fea9951#58b2b0d9-3d8b-4c17-b5e4-47c89017157dhttp://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/db2b346b-52f7-4f8a-8129-800e9fea9951#58b2b0d9-3d8b-4c17-b5e4-47c89017157dAndré Lagehttp://social.msdn.microsoft.com/Profile/en-US/?user=Andr%u00e9%20LageRemember this spgridview derived from gridview, so the same control exist on gridview also exist on spgridview. <div>Try use footertemplate of gridview to make you counts and sum. </div> <div><a href="http://aspalliance.com/782">http://aspalliance.com/782</a><br/></div> <div>Examples code:</div> <div><a href="http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.webcontrols.spgridview.onrowcreated.aspx">http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.webcontrols.spgridview.onrowcreated.aspx</a><br/></div> <div><br/></div> <hr class=sig> André Lage Microsoft SharePoint and CRM Consultant<br/> Blog:<a href="http://aaclage.blogspot.com">http://aaclage.blogspot.com</a><br/> Codeplex:<a href="http://spupload.codeplex.com/">http://spupload.codeplex.com/</a>Tue, 26 May 2009 20:54:23 Z2009-05-26T21:12:38Zhttp://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/db2b346b-52f7-4f8a-8129-800e9fea9951#7af22e9f-81b9-41a2-aec1-1834769dfee3http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/db2b346b-52f7-4f8a-8129-800e9fea9951#7af22e9f-81b9-41a2-aec1-1834769dfee3Pedro Mateushttp://social.msdn.microsoft.com/Profile/en-US/?user=Pedro%20MateusThank you André, <div><br/></div> <div>It seems Grouping enabled caused an error on postback, i thk its a known bug and that was slowing things...</div> <div><br/></div> <div>in rowdatabound or from sql i was able to get totals and counts :)</div> <div><br/></div> <div>tks</div><hr class="sig">http://pontodepartilha.blogspot.comFri, 03 Jul 2009 17:09:41 Z2009-07-03T17:09:41Z