SQL Server 2005 Reporting Services and the Report Viewer

Posted by Kendra on Stack Overflow See other posts from Stack Overflow or by Kendra
Published on 2010-04-01T16:07:45Z Indexed on 2010/04/01 16:13 UTC
Read the original article Hit count: 334

I am having an issue embedding my report into an aspx page.

Here's my setup:
1 Server running SQL Server 2005 and SQL Server 2005 Reporting Services
1 Workstation running XP and VS 2005
The server is not on a domain.
Reporting Services is a default installation.

I have one report called TestMe in a folder called TestReports using a shared datasource.

If I view the report in Report Manager, it renders fine. If I view the report using the http ://myserver/reportserver url it renders fine. If I view the report using the http ://myserver/reportserver?/TestReports/TestMe it renders fine. If I try to view the report using http ://myserver/reportserver/TestReports/TestMe, it just goes to the folder navigation page of the home directory.

My web application is impersonating somebody specific to get around the server not being on a domain. When I call the report from the report viewer using http ://myserver/reportserver as the server and /TestReports/TestMe as the path I get this error:

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.

When I change the server to http ://myserver/reportserver? I get this error when I run the report:

Client found response content type of '', but expected 'text/xml'. The request failed with an empty response.

I have been searching for a while and haven't found anything that fixes my issue. Please let me know if there is more information needed.

Thanks in advance,
Kendra

© Stack Overflow or respective owner

Related posts about reporting

Related posts about Services