ReportViewer error with SSRS2005 on a non-default website

I am facing a problem when trying to access a report using ReportViewer
ASP.NET 2.0 WebForms control. The reportviewer displays an 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". When I try to access any of the SSRS2005 Web Service
method (For example: ListChildren) with a proxy, I get an error "The request
failed with HTTP status 404: Not Found."
Here are the exception details:
-----
{"The request failed with HTTP status 404: Not Found."}
[System.Net.WebException]: {"The request failed with HTTP status 404:
Not Found."}
Data: {System.Collections.ListDictionaryInternal}
HelpLink: null
InnerException: null
Message: "The request failed with HTTP status 404: Not Found."
Source: "Test.MDC.CRI.SSRS2005.Helper"
StackTrace: " at
Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildren(String parentFolder,
Boolean recursive, CatalogItem[]& items) in
C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
252\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildrenByType(String
parentFolder, ItemTypeEnum itemType, Boolean ignoreDatasourceFolder,
SortedList& childItems) in
C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
105\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetFolders(String
parentFolder, Boolean ignoreDatasourceFolder, SortedList& childFolders) in
C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line 26\r\n
at BrowseFolders.Page_Load(Object sender, EventArgs e) in
c:\\SSRS\\CRI\\Prototype2\\ReportViewerWebClient\\UserCtls\\BrowseFolders.ascx.cs:line
33\r\n at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp,
Object o, Object t, EventArgs e)\r\n at
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e)\r\n at System.Web.UI.Control.OnLoad(EventArgs e)\r\n at
System.Web.UI.Control.LoadRecursive()\r\n at
System.Web.UI.Control.LoadRecursive()\r\n at
System.Web.UI.Control.LoadRecursive()\r\n at
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
Boolean includeStagesAfterAsyncPoint)"
TargetSite: {Boolean GetChildren(System.String, Boolean,
Test.MDC.CRI.SSRS2005.WebService.CatalogItem[] ByRef)}
-----
Response object of System.Net.WebException:
-----
{System.Net.HttpWebResponse}
[System.Net.HttpWebResponse]: {System.Net.HttpWebResponse}
base {System.MarshalByRefObject}: {System.Net.HttpWebResponse}
ContentLength: 629
ContentType: "text/html"
Headers: {Pragma: no-cache
Proxy-Connection: Keep-Alive
Connection: Keep-Alive
Content-Length: 629
Cache-Control: no-cache
Content-Type: text/html
}
IsFromCache: false
IsMutuallyAuthenticated: false
ResponseUri:
{http://ssrs.dev.reports.com:8084/ReportServer/ReportService2005.asmx}
-----
My Report Server configuration:
Web Server: Windows 2003 Standard SP1
SQL Server: SQL Enterprise 2005 SP1
Report Server Web Site: Installed on a non-default web site, running under
ASP.NET 2.0, part of app pool with identity NetWork Service
Reporting Services Windows Service running under Local System account
Identity of the web site: Anonymous access disabled, Windows Authentication
checked
Reports virtual directory - Integrated Windows Authentication, Anonymous
disabled
ReportServer virtual directory - Integrated Windows Authentication,
Anonymous disabled
Patches:
1. Disable loopback entry set as per MSKB article:
http://support.microsoft.com/kb/896861/
2. RSWebApplication.config changed as below:
Before:
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
After:
<UI>
<ReportServerUrl>http://ssrs.dev.reports.com:8084/ReportServer</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
The following sites runs OK.
- http://ssrs.dev.reports.com:8084/ReportServer/ (Able to deploy reports
to this using VS2005 designer. Currently displays the version Microsoft SQL
Server Reporting Services Version 9.00.2047.00)
- http://ssrs.dev.reports.com:8084/Reports/ (Displays deployed reports and
able to browse folders)
If you can help me to fix the issue, it would be of great help. Struggling
for few days already with this issue.
Thanks,
Live_Love_LaughOne more thing to mention:
After playing with SSRS2005 for few days, I figured out that if the
WebApplication is running of file system(ASP.NET 2.0 feature), rather than on
a website I could able to see the results through report viewer control but
as soon as I put it on IIS, I am getting the 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."
Any ideas?
Thanks,
Live_Love_Laugh
"Live_Love_Laugh" wrote:
> I am facing a problem when trying to access a report using ReportViewer
> ASP.NET 2.0 WebForms control. The reportviewer displays an 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". When I try to access any of the SSRS2005 Web Service
> method (For example: ListChildren) with a proxy, I get an error "The request
> failed with HTTP status 404: Not Found."
> Here are the exception details:
> -----
> {"The request failed with HTTP status 404: Not Found."}
> [System.Net.WebException]: {"The request failed with HTTP status 404:
> Not Found."}
> Data: {System.Collections.ListDictionaryInternal}
> HelpLink: null
> InnerException: null
> Message: "The request failed with HTTP status 404: Not Found."
> Source: "Test.MDC.CRI.SSRS2005.Helper"
> StackTrace: " at
> Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildren(String parentFolder,
> Boolean recursive, CatalogItem[]& items) in
> C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
> 252\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetChildrenByType(String
> parentFolder, ItemTypeEnum itemType, Boolean ignoreDatasourceFolder,
> SortedList& childItems) in
> C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line
> 105\r\n at Test.MDC.CRI.SSRS2005.Helper.RSHelper.GetFolders(String
> parentFolder, Boolean ignoreDatasourceFolder, SortedList& childFolders) in
> C:\\SSRS\\CRI\\Prototype2\\Libraries\\SSRS2005Helper\\RSHelper.cs:line 26\r\n
> at BrowseFolders.Page_Load(Object sender, EventArgs e) in
> c:\\SSRS\\CRI\\Prototype2\\ReportViewerWebClient\\UserCtls\\BrowseFolders.ascx.cs:line
> 33\r\n at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp,
> Object o, Object t, EventArgs e)\r\n at
> System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
> EventArgs e)\r\n at System.Web.UI.Control.OnLoad(EventArgs e)\r\n at
> System.Web.UI.Control.LoadRecursive()\r\n at
> System.Web.UI.Control.LoadRecursive()\r\n at
> System.Web.UI.Control.LoadRecursive()\r\n at
> System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint,
> Boolean includeStagesAfterAsyncPoint)"
> TargetSite: {Boolean GetChildren(System.String, Boolean,
> Test.MDC.CRI.SSRS2005.WebService.CatalogItem[] ByRef)}
> -----
> Response object of System.Net.WebException:
> -----
> {System.Net.HttpWebResponse}
> [System.Net.HttpWebResponse]: {System.Net.HttpWebResponse}
> base {System.MarshalByRefObject}: {System.Net.HttpWebResponse}
> ContentLength: 629
> ContentType: "text/html"
> Headers: {Pragma: no-cache
> Proxy-Connection: Keep-Alive
> Connection: Keep-Alive
> Content-Length: 629
> Cache-Control: no-cache
> Content-Type: text/html
> }
> IsFromCache: false
> IsMutuallyAuthenticated: false
> ResponseUri:
> {http://ssrs.dev.reports.com:8084/ReportServer/ReportService2005.asmx}
> -----
> My Report Server configuration:
> Web Server: Windows 2003 Standard SP1
> SQL Server: SQL Enterprise 2005 SP1
> Report Server Web Site: Installed on a non-default web site, running under
> ASP.NET 2.0, part of app pool with identity NetWork Service
> Reporting Services Windows Service running under Local System account
> Identity of the web site: Anonymous access disabled, Windows Authentication
> checked
> Reports virtual directory - Integrated Windows Authentication, Anonymous
> disabled
> ReportServer virtual directory - Integrated Windows Authentication,
> Anonymous disabled
> Patches:
> 1. Disable loopback entry set as per MSKB article:
> http://support.microsoft.com/kb/896861/
> 2. RSWebApplication.config changed as below:
> Before:
> <UI>
> <ReportServerUrl></ReportServerUrl>
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> After:
> <UI>
> <ReportServerUrl>http://ssrs.dev.reports.com:8084/ReportServer</ReportServerUrl>
> <ReportServerVirtualDirectory></ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> The following sites runs OK.
> - http://ssrs.dev.reports.com:8084/ReportServer/ (Able to deploy reports
> to this using VS2005 designer. Currently displays the version Microsoft SQL
> Server Reporting Services Version 9.00.2047.00)
> - http://ssrs.dev.reports.com:8084/Reports/ (Displays deployed reports and
> able to browse folders)
>
> If you can help me to fix the issue, it would be of great help. Struggling
> for few days already with this issue.
> Thanks,
> Live_Love_Laugh

ReportViewer does not print on first attempt

Hi,
Has anyone found a solution to the problem of the reportviewer not printing
the first time you try to print? We found a solution on another newsgroup
but it doesn't fully resolve the problem.
Me.ReportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout)Me.ReportViewer1.RefreshReport()
By using the displaymode.printlayout now you have to press the Print button
in the print dialog twice. But at least it prints. It seems that when the
print dialog displays it does not have focus. Clicking the print button or
anything else in the print dialog, then clicking the Print Button again does
actually print the report.there is a fix on msdn.
using a timer
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.comsql

Reporting Services: Deserialization Failed

Hi,

I have an SSRS 2000 report which has been unchanged in months. I've been asked to make a few changes and when i attempt to open the report in VS.net 2003 i get the following warning and error message.

Warning 1 Deserialization failed: The table "table1" has rows with a different number of cells than the number of the columns in the table (including cells that span more than one column). Line 9, position 23479. 9 0

Error 2 [rsWrongNumberOfTableCells] The table ‘table1’ has rows that contain a different number of cells than the number of the columns in the table (including cells that span more than one column). C:\Documents and Settings\Leigh.Moore.VETS4PETS\My Documents\Visual Studio 2005\Projects\Report Project1\Report Project1\Daily Sales - Invoiced.rdl 0 0

Has anyone come across this problem and can anyone suggest how i rectify it as i really don't want to have to create the report from scratch.

Thanks in advance,

Leigh.

I come accross this problem everytime I try to edit the sql query in the rdl.

Reporting Services: Deserialization Failed

Hi,

I have an SSRS 2000 report which has been unchanged in months. I've been asked to make a few changes and when i attempt to open the report in VS.net 2003 i get the following warning and error message.

Warning 1 Deserialization failed: The table "table1" has rows with a different number of cells than the number of the columns in the table (including cells that span more than one column). Line 9, position 23479. 9 0

Error 2 [rsWrongNumberOfTableCells] The table ‘table1’ has rows that contain a different number of cells than the number of the columns in the table (including cells that span more than one column). C:\Documents and Settings\Leigh.Moore.VETS4PETS\My Documents\Visual Studio 2005\Projects\Report Project1\Report Project1\Daily Sales - Invoiced.rdl 0 0

Has anyone come across this problem and can anyone suggest how i rectify it as i really don't want to have to create the report from scratch.

Thanks in advance,

Leigh.

I come accross this problem everytime I try to edit the sql query in the rdl.