将SQL Server 2008的.rdl与VS2010集成 [英] Integration of .rdl of SQL server 2008 with VS2010

问题描述

我们使用'Visual Studio 2008'使用'Report Server Project'创建.RDL文件。我们正在使用SQL Server 2008.我们已经在报告服务器上部署了这个.RDL文件，我们需要使用VS2010中的ReportViewer来访问它。我们设置了以下3个属性来访问它： -

We have create .RDL file using 'Report Server Project' using 'Visual Studio 2008'. We are using SQL Server 2008. We have deployed this .RDL file on reporting server from there we need to access it using 'ReportViewer' in VS2010. We have set below 3 properties to access it:-

repViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
repViewer.ServerReport.ReportServerUrl = new Uri(@"http://servername/ReportServer");
repViewer.ServerReport.ReportPath = @"/TestSSASReports/testSSASReport";
repViewer.ServerReport.Refresh();

我们收到以下错误消息： -

We are getting below error message:-

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
The request failed with HTTP status 404: Not Found.

我们发现SQL Server 2008的.rdl与VS2010的集成存在问题。



有没有任何替代解决方案或是否有任何代码问题？

We found that there is problem with Integration of .rdl of SQL server 2008 with VS2010.

Is there any alternative solution for it or is there any code issue?

推荐答案

We created same Virtual directory for "Report Manager URL" and the "Report Server Url". And that conflict raises the error. 

Therefore we create different-different Virtual directory for both of it and use "Report Server Url" path in the code. This resolved the issue

这篇关于将SQL Server 2008的.rdl与VS2010集成的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！