SPDataSource Cross List Data View – Roll up all tasks across site collection

By peter.stilgoe

Hello there! If you are new here, you might want to subscribe to the RSS feed for updates on this topic.

Add the following code to your Data View webpart (tbc)

<SharePointWebControls:SPDataSource runat="server" DataSourceMode="CrossList" SelectCommand="<Webs Scope='Recursive'></Webs><Lists ServerTemplate='107'</Lists><Query /><ViewFields><FieldRef Name='Title' /><FieldRef Name='Status' /><FieldRef Name='PercentComplete' /><FieldRef Name='Matter_x0020_Number' /><FieldRef Name='Task_x0020_KPI' /></ViewFields><QueryOptions />" UseInternalName="True" UseServerDataFormat="True" ID="dataformwebpart1"><SelectParameters><WebPartPages:DataFormParameter ParameterKey="ListID" PropertyName="ParameterValues" DefaultValue="{470C3D07-87CE-4FFD-908B-A59223155B15}" Name="ListID"></WebPartPages:DataFormParameter><asp:Parameter DefaultValue="0" Name="StartRowIndex"></asp:Parameter><asp:Parameter DefaultValue="0" Name="nextpagedata"></asp:Parameter><asp:Parameter DefaultValue="10" Name="MaximumRows"></asp:Parameter>

More From pstilgoe

Sharepoint 2010, Sharepoint DVWP, Sharepoint How To commento

No Comments data

February 15th, 2011

About... peter.stilgoe

This author published 497 posts in this site.
Sharepoint, InfoPath, K2, Nintex, Business Process Mapping, Business Intelligence, Automation, ECM, Document Management, Document Imaging, Internet Marketing & Online Business Consultant Email / MSN: pstilgoe@hotmail.com LinkedIn: Pete Stilgoe - Sharepoint Consultant