Custom reports in process template

Question

I'm trying to add a custom report to a modified process template. I'm using the Power Tools to modify the process template. When adding the report, a data source needs to be defined. It has two entries: 'Name' and 'DS Name'. Existing reports are set to '/Tfs2010ReportDS' and 'TfsReportDS' respectivly.

My Custom report has a datasource named '\Model' (at least that's what it says in the report manager web page). When I'm looking at the 'Model' (found under 'Home' in the report manager web page), this has a datasource called '/Tfs2010ReportDS'.

I attempted to set the datasource for my custom report as:

Name = /Tfs2010ReportDS

DS Name = Model

I get the following error message:

Exception Message: The data source 'Tfs2010ReportDS ' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.DataSourceNotFoundException: The data source 'Tfs2010ReportDS ' cannot be found. (type SoapException)SoapException Details: <detail><ErrorCode xmlns="rsDataSourceNotFound</ErrorCode><HttpStatus">http://www.microsoft.com/sql/reportingservices">rsDataSourceNotFound</ErrorCode><HttpStatus xmlns="400</HttpStatus><Message">http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="The">http://www.microsoft.com/sql/reportingservices">The data source 'Tfs2010ReportDS ' cannot be found.</Message><HelpLink xmlns="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsDataSourceNotFound&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=10.0.5500.0</HelpLink><ProductName">http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsDataSourceNotFound&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.0.5500.0</HelpLink><ProductName xmlns="Microsoft">http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="10.0.5500.0</ProductVersion><ProductLocaleId">http://www.microsoft.com/sql/reportingservices">10.0.5500.0</ProductVersion><ProductLocaleId xmlns="127</ProductLocaleId><OperatingSystem">http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="OsIndependent</OperatingSystem><CountryLocaleId">http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="1033</CountryLocaleId><MoreInformation">http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="<Source>Microsoft.ReportingServices.ProcessingCore</Source><Message">http://www.microsoft.com/sql/reportingservices"><Source>Microsoft.ReportingServices.ProcessingCore</Source><Message msrs:ErrorCode="rsDataSourceNotFound" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsDataSourceNotFound&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=10.0.5500.0" xmlns:msrs="The">http://www.microsoft.com/sql/reportingservices">The data source 'Tfs2010ReportDS ' cannot be found.</Message></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>

Exception Stack Trace:    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at Microsoft.TeamFoundation.Client.Reporting.ReportingService.SetReportDataSources(String Item, DataSource[] DataSources)
   at Microsoft.TeamFoundation.Client.Reporting.ReportingUploader.UploadReport(XmlNode report)

Answer 1

Hi Jensen, 

Thanks for your post.

When we configured Reporting Service for TFS 2010, there will have two default TFS 2010 data source, Tfs2010OlapReportDS(connecting to Tfs_Analysis database) and Tfs2010ReportDS(connecting to Tfs_Warehouse database). We can view these two default data source in http://servername/reports
site.     

Do you mean that you created the Model data source in your Reporting Service(http://servername/reports)? How did you create the “\Model” data source? How to new data source, please refer to this article: http://www.enewsbuilder.net/nwcadence/e_article002169458.cfm?x=bjMkMVt,bc1RsVg9,w.
 

The Name is the data source which you created in your Reporting Service, in your case, the Name should is /Model if you created the Model data source in your Reporting Service, the DS Name is
the data source name which you defined in your report file. For how to customizing Reports for TFS 2010, please refer to the detailed information in this MSDN document: http://msdn.microsoft.com/en-us/library/ff730838.aspx.     

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us