How do I run ReportViewer.exe on the Web server. Is this something I can do or is it something DiscountASP.NET people must do for me? MSDN: Deploying Reports and ReportViewer Controls. For ASP.NET applications, run ReportViewer.exe on the Web server that hosts your application. How do I do it? My reports do not run on my DiscountASP.net web site. The reports work fine on my local machine. I'm new to hosted web sites.
Hi, Serving the reports via the report viewer isfrom each machine. The reports will be on the DASP server. If you don't want them to need the report viewer you can create ASP.NET pages to serve the reports. Salute, Mark
What does it mean: "The reports will be on the DASP server." How do I get my ReportViewer to use the DASP server? Thank you. Jim
Hi, I've been holding off on creating a Webcast for this because of the new versions. (Both SQL Server and the ReportView controls, and most recently all the service packs.) Once I catch up on the things I'm currently working on I'll work on an example, with code, for you. Would you like the example to use the remote report viewer? Salute, Mark
Please, I would like an example of the report viewer working on a web site that is not the local machine. I see this issue by several people when I google and MSDN. This idea of deploying on a remote web site seems to be the problem. Why does it work on the local machine but does not work on the remote web site. Remember I'm new to this remote web stuff.
Hi, Are you using Visual Studio 2005 or 2008? (Maybe VWD) There are two ways currently to run the reports on-line for DASP accounts. You can only use the executable on a local machine but it can access your on-line reports. The other method is via ASP.NET code pages in VS. Info here: http://technet.microsoft.com/en-us/library/ms159868(SQL.90).aspx Development center: http://technet.microsoft.com/en-us/library/ms159162(SQL.90).aspx Salute, Mark
Hi, Are you using Visual Studio 2005 or 2008? (Maybe VWD) There are two ways currently to run the reports on-line for DASP accounts. You can only use the executable on a local machine but it can access your on-line reports. The other method is via ASP.NET code pages in VS. Info here: http://technet.microsoft.com/en-us/library/ms159868(SQL.90).aspx Development center: http://technet.microsoft.com/en-us/library/ms159162(SQL.90).aspx Salute, Mark I'm developing with VS2008 on Vista. I used the ASP.NET Web Application template. I create a dataset with one table (AdventureWorkLt.Customer). I add a new item Report Wizard to create a report that lists the CompanyName column in the Details section of the report. No Page or Grouping. I drag the MicrosoftReportViewer control on to the Default.aspx webform. I set the Report to the only report "Report1.rdlc". I run the application and it all run fine. I deploy it to my remote web site and I get the following error message. <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">An error occurred during local report processing. <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">The report definition for report 'E:\web\weavetogeth\htdocs\Reports\Report1.rdlc' has not been specified <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">Could not find file 'E:\web\weavetogeth\htdocs\Reports\Report1.rdlc'. <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana"> Several other people have the same or similar error (Google) "The report definition for report "xxx" has not been specified". It works on my local machine but not on the remote web site. Thank you for your kind attention to this matter. Jim <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">
Do I need "Reporting Services" to display a simple MicrosoftReportViewer control with onereport on a web form?
Hi, <STRIKE>Currently yes but SQL Server 2008 may change that later this year. I'll try and whip-up an example for SSRS on SQL Server 2005 for you. Update: It's in the works. Salute, Mark Post Edited (wisemx) : 9/16/2008 12:37:33 AM GMT
I'm using VS2008 on Vista OS. I created a new project (ASP.NET Web Application). I created a dataset with one table. I created a (Reports Application). I placed a Microsoft.Reporting.WeForms.ReportViewer on the web form. I created an ObjectDataSource. It runs fine on my local machine http://localhost:50546/Default.aspx. I deploy it to my remote web site http://www.weavetogether.com/reports/using the Build | Publish tool on VS2008. I get the following error. <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">An error occurred during local report processing. <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">The report definition for report 'E:\web\weavetogeth\htdocs\Reports\Report1.rdlc' has not been specified <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">Could not find file 'E:\web\weavetogeth\htdocs\Reports\Report1.rdlc'. I do not know how to solve this error. Jim
Howdy Jim, I've been pulling my hair out over this for weeks. Getting the reports to work, creating them, etc., with the Report Server and ReportViewer is easy. Doing it with ASP.NET so they can be served on a site with no Report Server, well, that part has been a nightmare. I finally got it to work this morning. The code I'll post below is the only code needed. In my App_Code folder for the site I've created an ObjectDataSource. This contains the SQL Server Database connection and table I'm using. It does not use a Report Server. In Visual Studio 2008 I created a normal SQL Report that uses that ObjectDataSource. Nothing fancy, just drop it on the page, add the ObjectDataSource. SessionState and ViewState must be enabled for the ASP.NET page, Async must be disabled. The code shown below is loading a report from the site root, any folder on the site can be used. Notice that in the code for the ASP.NET ReportViewer you must also set AsyncRendering="false" for this to work. Salute, Mark
Mike:</o> </o> I got it to work. I am so grateful to you for the time and effort you spent.</o> I had one additional problem with IE on my dev machine/computer system. I used my laptop to view the remote website and it worked just fine. I then used two different browsers to view the website successfully. So, after all that, I have a problem with IE browser on my dev machine. I?ll fix that soon.</o> </o> Just to confirm, adding the following two line of code made the difference. </o> EnableSessionState="True" EnableViewState="true" Async="false"</o> AsyncRendering="false"</o> </o> Make sure your browser is working too. J</o> </o> Jim</o>
I forgot to post this link. http://www.gotreportviewer.com/ lots of sample code here. Bruce DiscountASP.NET www.DiscountASP.NET
Dog'gone'it! I hadn't checked that site in over a year, everything was outdated... Looking now they even updated the SQL 2008 links. Cool
No. You do not need reporting service if you just want to display a report on a webform. Simply use report viewer control. I had some sample code before.. but i don't know where i placed them. Let us know if you couldn't figure it out. Bruce DiscountASP.NET www.DiscountASP.NET
Good catch bro...I must have been cross-eyed. Currently working on the Webcast and examples for this. Guess it will be best to have two Webcasts, one for the remote Viewer, one for the ASP.NET method. note: The Report Viewer method is a snap, the ASP.NET method has been kicking my tail.
