Hi,
I am trying to display a report that is deployed on a reporting server using the asp.net reportviewer control. I am using visual studio 2010, the reportviewer control from the assembly Microsoft.ReportViewer.WebForms, Version 10.0.0.0. The SQL server is a 2008 version on a remote machine. This gives me the following error.
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.
The code I am using is
<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" >
<ServerReport DisplayName="Time By Employees"
ReportPath="/Reports/ProjectTimes"
ReportServerUrl="http://sqlserver03/Reports_PRIMA_VERA_DEV" />
</rsweb:ReportViewer>
If its a version problem with the reportviewer control, I don't know what other version to use or how to get it.
I am not sure its an access problem, because I can see the reports in the web browser from my asp.net machine. I open up explorer and type "http://sqlserver03/Reports_PRIMA_VERA_DEV" in the address bar, see the SQL Server Reporting Services Home page. Navigate the "Reports" folder and see the relavent reports.
There is also a Sharepoint 2007 instance on the local asp.net dev machine. It has a reportviewer web part that is pointing to the same address and displays the reports fine.
Basically I have a couple of reports being displayed in a Sharepoint 2007 site via report viewer web part. I am trying to show the same reports in another web app (being built on the same machine at the moment as the Sharepoint instance), and using the Reportviewer control. So while I have access to the reports, through Sharepoint and via the browser, the report control doesn't seem to work.
Any ideas or help would be much appreciated.