Not able to see report through reportViewer
I wrote a report using SQL Server 2008 Business Intelligence Developement Studio. I can preview the report in Development Studio. I can see the report through report manager with IE. When I try to view it from my .net page, I get an exception: "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." In SQL Server 2008R2 Reporting Services Configuration Manager , Report manager URL is: http://<my laptop>:80/Reports Virtual Directory: "Reports" Web Service URL: http://<my laptop>:80/ReportServer Virtual Directory: "ReportServer" from aspx page <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="430px" ProcessingMode="Remote" Width="980px"> <ServerReport ReportServerUrl="http://<my laptop>/reports"/> </rsweb:ReportViewer> From aspx.vb ReportViewer1.ServerReport.ReportPath = "/HcpSpendByDateRptVer2.rdl" Can Anyone tell me why I am getting this error?
May 9th, 2011 2:54pm
Hi, Are you able to access Report Manager with the below URL? http://<my-laptop>/Reports Are you able to access your Report Viewer with the below URL? htpp://<my-laptop>/ReportServer Please let us know your feedback. Thanks KumarKG, MCTS
May 9th, 2011 3:05pm
Hi, From you description, the root cause of the issue might be Report Manager URL is specified to the ReportViewer. As Kumar posted, we must specify the Web Service URL. In addition, if your Reporting Services is configured in Native mode, we dont need to specify the report extension name (.rdl) in the ReportPath. For more information about Configuring ReportViewer for Remote Processing, please refer to http://msdn.microsoft.com/en-us/library/ms252075.aspx Thanks, Tony ChainTony Chain [MSFT CSG] | Microsoft Community Support Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
May 13th, 2011 3:28am