Hi I want to creat a web app with a report viewer control to serve up a result set from a stored proc. Basically I am trying to render a remote report from the RS. The report works fine from a browser from the Report mgr. I thought I had things wired correctly but I get the error below. Beta: SV20008 SS2008R2 Reportviewer 9.0 Thanks in advance. John Webconfig: <appSettings> <add key="ReportViewerServerConnection" value="https://rs2k801.discountasp.net"/> <add key="MyReportViewerUser" value="rs_######"/> <add key="MyReportViewerPassword" value=" "/> <add key="MyReportViewerDomain" value="RS2K801"/> <!-- This is the Domain of the Useraccount on RS--> <add key="MyReportServerUrl" value="https://rs2k801.discountasp.net/ReportServer"/> </appSettings> <connectionStrings> <add name="ApplicationServices" connectionString="Data Source=sql2k803.discountasp.net;Initial Catalog=SQL2008_######_XXXXXX ;User ID=SQL2008_XXXX ;Password= ******" providerName="System.Data.SqlClient" /> </connectionStrings> <system.web> <compilation debug="true"> Error message: Server Error in '/' Application. ________________________________________ The type 'https://rs2k801.discountasp.net' could not be found Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type 'https://rs2k801.discountasp.net' could not be found Source Error: Line 11: <br /> Line 12: <br /> Line 13: <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Line 14: Font-Size="8pt" InteractiveDeviceInfos="(Collection)" ProcessingMode="Remote" Line 15: WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt"> Source File: c:\Users\XXXXXXXX\Documents\Visual Studio 2010\Projects\FootballStatFact\FootballStatFact\Default.aspx Line: 13
Source File: c:\Users\XXXXXXXX\Documents\Visual Studio 2010\Projects\FootballStatFact\FootballStatFact\De fault.aspx Line: 13 Check the Default.aspx file name..
Default name is a copy past into the forum page Thanks Jay, I saw that and the file name is fine. The error is telling me that the reportviewer cannot find The type 'https://rs2k801.discountasp.net' could not be found This is telling me that I have something wired wrong in the webconfig? I need to get htis working so I can distribute the reports on the RS server. I'm almost done with the reports, so what I basically need is an webpage with a reportviewer object to serve up the reports. I'm a Database Developer, so my experience is all on the database support and maintenance. I have seen good examples of reportviewer object on web page and that is my goal. Any help would be appreciated. Thanks. John
Still not working. Woha boy, I need to get this resolved. Anyone have any suggestions? Is there a cookbook method for producing a simple web page with a reportviewer object? Thanks. John
Ouch. a tough question. OK I'm not sure of the symantics, but basically I will be serving reports from DASP RS via a reportviewer control on a web page also hosted by DASP. Does that help? Thanks. John
It is rather complicated but the VS version does not need RS, it isn't as feature full as the RS version however. If you are using RS and just need to serve up a simple report without graphs for example it is very easy to create one and serve it on your site in just a matter of minutes like this: http://www.dasptv.com/avc-view.aspx?videoid=33&categoryid=1
OK I can creae a report from the VS report viewer, but I have reports that I have created and are on the DASP RS server. Nice pretty ones at that. Is this a giant leap from creating a new report from the VS wizard? Is there a reference anyone can recommend to me? I thought that I can created these fairly sophisticated reports (databar, etc.) and then have a Report viewer object serve them up nicely. Thanks in advance. John
The VS method isn't a giant leap but it can't do everything you can with RS. This is one place to look: http://www.gotreportviewer.com/
OK I have successfully recreated an SSRS report using VS and it renders fine on an asp page, but I am had trouble deploying the RDLC file. I went to the properties of the report.rdlc and clicked always copy to source directory and changed the build action to content, which displayes the page with the report. This is OK, but I'm not getting the R2 version benefits with this method. I was able to make a standard chart within a matrix look just like an R2 databar, however not without a lot of work. I will keep playing with this, but I would like to see an SSRS report on the webpage. Otherwise, why add SSRS to the account? Thanks for the help. John
