VS 2005 Connect to SQL 2008 with Reportviewer (not displaying) (Network Steve Forum)

VS 2005 Connect to SQL 2008 with Reportviewer (not displaying)

Ok i now managed to get the Reportviewer to work in VS 2008 with SQL 2008 R2 now i am working backwards and i want to use VS 2005 with SQL 2008. from other forums i read it suggested that i do a download of the Redist for ReportViewer (ver 9.0.0.0). I did that, Installed the exe and add the references to the project. and now i am sitting with a situation where the page loads but then there is nothing in the ReportViewer. Even if i change the ReportServerURL to a non-existent one then it does not even through an error. Once again (just like the previous one) i just want to get the report loaded as the page starts up so i have no CodeBehind. Here is the HTML code. with a valid url on the network. <form id="form1" runat="server"> <div> <rsweb:ReportViewer ID="ReportViewer1" runat="server"> <ServerReport ReportServerUrl='http://zamntTest5/ReportServer' ReportPath="/Report1" /> </rsweb:ReportViewer> </div> </form> and with this i just get a blank screen. Hope i gave enough detail and that someone can help. Regards. Coffee is what makes civilised life Possible

December 30th, 2010 4:54am

Hi Gremlin1708, From your description, it seems you just added the assemblies reference in the project, but you didn't configure the HTTPHandle in the web.config of the application, right? If I am correctly, that should be the cause, the HTTPHandle is not configured correctly in the web.config of the application. Please make sure the following configuration is configured within HttpHandler: <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> Also, within assembly: <add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /> <add assembly="Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" /> If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Free Windows Admin Tool Kit Click here and download it now

January 3rd, 2011 3:29am

Good Day Jin. Sorry i only reply now but i was not in the office yesterday. I looked at my web.config and see that the three lines that you mentioned is in the web.Config file(Exactly as they are at the top). Is there anything else that i can try. I need this to work :-( I am want to upgrade our SQL from 2000 to 2008 but i first want to get the basic right. I am using the Adventure works DB on the SQL R2 2008. This is my web.Config file <?xml version="1.0"?><configuration> <system.web> <httpHandlers> <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /> </httpHandlers> <compilation debug="true"> <assemblies> <add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/> <add assembly="Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/></assemblies></compilation> <authentication mode="Windows"/> </system.web> </configuration> and then my Default.aspx page looks like this... <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="my_SSRS.WebForm1" %> <%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> <rsweb:ReportViewer ID="ReportViewer1" runat="server"> <ServerReport ReportServerUrl='http://zamnttest5/Reportserver' ReportPath="/Report1" /> </rsweb:ReportViewer> </div> </form> </body> </html> zamnttest5 is my SQL R2 2008 Server and my Report is in the root called Report1 Where is my mistake?Coffee is what makes civilised life Possible

January 4th, 2011 12:28am

Free Windows Admin Tool Kit Click here and download it now

January 4th, 2011 12:28am

Hi Gremlin1708, It there any error message in the SQL Server Reporting Services(SSRS) error logs? Also, if possible, could you please give the control over your computer? If so, I will create a live session for you. Thanks, Jin ChenJin Chen - MSFT

January 4th, 2011 12:35am

Which version of OS you are on? Is it IIS 7? If yes, then you might need to add one more entry in the web.config: <system.webServer> <handlers> <add name="ReportViewerWebControl" path="Reserved.ReportViewerWebControl.axd" verb="*" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/> </handlers> </system.webServer> Please refer: http://blogs.msdn.com/b/webtopics/archive/2009/02/10/report-viewer-toolbar-does-not-render-properly-on-iis-7-0.aspx Hope this helps.. Chaitanya

Free Windows Admin Tool Kit Click here and download it now

January 4th, 2011 1:29am

Hi Jin... what is the difference with using the ReportViewer(Ver 9.0.0.0) and ReportViewer(Ver 8.0.0.0) to connect to SQL 2008? I dont know what i did but the ReportViewer(Ver 8.0.0.0) now connects to SQL 2008 R2 and shows me the report. So the problem is now sorted out i can use VS 2005 to connect to SQL Reporting Services 2008 R2. but i am using the ver 8 of the ReportViewer. Can you explain me the main differences please. Regards.Coffee is what makes civilised life Possible

January 5th, 2011 3:20am

Hi there Chaitanya... No currently i am still on IIS 6. I will be moving stuff over to IIS 7 soon so i will keep this in mind and save the link you send here... Thank you very much. Coffee is what makes civilised life Possible

Free Windows Admin Tool Kit Click here and download it now

January 5th, 2011 3:22am

This topic is archived. No further replies will be accepted.