Stump the Panel Topic: Aggregating Data Sources featuring Cross List DataSourceMode

Stump the Panel Topic: Aggregating Data Sources featuring Cross List DataSourceMode http://www.endusersharepoint.com/STP/ Paul Grenier, Lead Moderator en Wed, 11 Feb 2009 16:03:57 +0000 pjcolbeck on "Aggregating Data Sources featuring Cross List DataSourceMode" http://www.endusersharepoint.com/STP/topic/aggregating-data-sources-featuring-cross-list-datasourcemode#post-4042 Mon, 09 Feb 2009 13:00:25 +0000 pjcolbeck 4042@http://www.endusersharepoint.com/STP/ Thanks Laura! Good information. The CQWP would indeed make life easier...unfortunately I'm working in a WSS-only environment. Do you know if it is possible to join cross list SPDataSources to other SPDataSources in WSS 3.0? When you create a linked data source, SP Designer inserts the following script after the DVWP <DataSources> callout: <SharePoint:AggregateDataSource runat="server" IsSynchronous="" SeparateRoot="true" RootName="" RowsName="" ID="Unique_Combo_ID"> <Sources> <SharePoint:SPDataSource runat="server" ... </SharePoint:SPDataSource> <SharePoint:SPDataSource runat="server" .... </SharePoint:SPDataSource> </Sources> <aggregate> <concat name="data source"> <datasource name="List1" id="0" Type="SPList"/> <datasource name="List2" id="1" Type="SPList"/> </concat> </aggregate> </SharePoint:AggregateDataSource> </DataSources> I'm assuming that it is pretty straightforward to swap out the SPDataSource script for a functioning "cross list" data source with the default "list" data source, but I don't know how to specify a dynamic list of datasources for the <aggregate> attribute. Any thoughts as to how to accomplish this? Are there any other concerns that I should be aware of when attempting to link cross list data sources? Curious, Pat laura67 on "Aggregating Data Sources featuring Cross List DataSourceMode" http://www.endusersharepoint.com/STP/topic/aggregating-data-sources-featuring-cross-list-datasourcemode#post-4036 Mon, 09 Feb 2009 10:39:03 +0000 laura67 4036@http://www.endusersharepoint.com/STP/ Not sure if this is what you're referring to, but I've got a blog post where I talk about merging data sources: <a href="http://spinsiders.com/laurar/2009/01/29/ways-to-display-multiple-document-libraries/" rel="nofollow">http://spinsiders.com/laurar/2009/01/29/ways-to-display-multiple-document-libraries/</a> pjcolbeck on "Aggregating Data Sources featuring Cross List DataSourceMode" http://www.endusersharepoint.com/STP/topic/aggregating-data-sources-featuring-cross-list-datasourcemode#post-4034 Sat, 07 Feb 2009 14:55:07 +0000 pjcolbeck 4034@http://www.endusersharepoint.com/STP/ I am attempting to create a DVWP featuring aggregated data in a WSS-only environment. This is typically a pretty straightforward proposition using linked sources, but what do you do if you would like to include a list in CrossList DataSourceMode? The source for my example looks as follows: <DataSources> <SharePoint:AggregateDataSource runat="server" IsSynchronous="false" SeparateRoot="true" id="ProjectRollup"><sources> <SharePoint:SPDataSource runat="server" DataSourceMode="List" UseInternalName="true" selectcommand="<View></View>"> <SelectParameters><asp:Parameter Name="ListID" DefaultValue="49A9155F-4590-494B-B667-76EAC5710CAB"/> </SelectParameters><DeleteParameters><asp:Parameter Name="ListID" DefaultValue="49A9155F-4590-494B-B667-76EAC5710CAB"/> </DeleteParameters><UpdateParameters><asp:Parameter Name="ListID" DefaultValue="49A9155F-4590-494B-B667-76EAC5710CAB"/> </UpdateParameters><InsertParameters><asp:Parameter Name="ListID" DefaultValue="49A9155F-4590-494B-B667-76EAC5710CAB"/> </InsertParameters> </SharePoint:SPDataSource> <SharePoint:SPDataSource runat="server" DataSourceMode="CrossList" UseInternalName="true" selectcommand="<View><Webs Scope='Recursive'></Webs><Lists ServerTemplate='106' BaseType='0'></Lists><ViewFields><FieldRef Name='_x0025__x0020_Allocation'/><FieldRef Name='Estimated_x0020_Expense'/><FieldRef Name='Assignment_x0020_Status'/><FieldRef Name='Standard_x0020_Rate'/><FieldRef Name='Actual_x0020_Rate'/></ViewFields></View>"> </SharePoint:SPDataSource> </sources><aggregate><concat name="data source"> <datasource name="Projects" id="0" Type="SPList"/> <datasource name="Staffing" id="1" Type="SPList"/> </concat> </aggregate> </SharePoint:AggregateDataSource> </DataSources> I've worked with cross list rollups quite a bit, but never aggregated them with other lists. When I look at the script that is generated, the following fragment jumps out as the potential source of my "non-specific error" source: <aggregate><concat name="data source"> <datasource name="Projects" id="0" Type="SPList"/> <datasource name="Staffing" id="1" Type="SPList"/> </concat> </aggregate> What modifications to the code are necessary to ensure that all of the lists in the cross list rollup are aggregated into the data source definition? Curious, Patrick