Possible Bug in Aggregate Data Sources in DVWPs?

1 minute read

I think I’ve found a bug in using aggregate data sources in DVWPs with SQL Stored Procedures.  I’m trying to use the results of a Stored Procedure combined with the content of a list in SharePoint.  I’ve isolated the issue to the Stored Procedure. The first asp:SqlDataSource statement below is what I want the data source to be; the second is a simple select from a SQL table. The former does not work, while the latter does. I’ve tested it in a totally stripped down page where there is nothing but the DVWP.

The Stored Procedure works fine by itself; the issue arises when I try to use it in an aggregate data source with any other type of data source.

I’m guessing it is a bug, and I think we’ll try exposing the Stored Procedure as a Web Service, which should get around the issue.


Have a thought or opinion?