I've found the topic
http://msdn.microsoft.com/en-us/library/ms156421.aspx that provides instruction on moving the Reporting Services Databases; does anybody know if these instructions will work for 2000?
View Complete Post
Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting app using ASP.NET, OWC, and SQL Server 2000 Analysis Services to illustrate the process.
Jeffrey Hasan and Kenneth Tu
MSDN Magazine October 2003
We have build an MOSS 2007 environmentÃÂ on 64 bit servers. We build the reporting services server and configured in SharePoint integration mode. InitiallyÃÂ configuration looks fine with reporting services integration with green indicators.
After creating a web applicationÃÂ and accessing the web site from the report servor, i have found the followingÃÂ errors:
Server Error in '/' Application.--------------------------------------------------------------------------------
Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Could not load file or assembly 'RSSharePointSoapProxy, Version=126.96.36.199, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot fi
Hi,I have Configured All Reporting SErvices Through Rep Serv Configuration Wizard
When I type
on top of Address Bar Of Browser I Am Gettin This Error
Hello, I am having some trouble upgrading an existing SQL Server 2000 Reporting Services installation from an old server to a new one commissioned for this purpose, which is running SQL Server 2008 Reporting Services. I have been following the instructions here:
but after trying to connect with reporting services 2008, i get this error:
The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'C.0.6.54'. The expected
version is '147'. (rsInvalidReportServerDatabase)
before starting the process, I ran upgrade advisor and got back the following results:
DescriptionSetup can upgrade a SQL Server 2000 Reporting Services instance that uses a SQL Server 2000 Database Engine in the same instance. However, upgrade is blocked if the report server database is in a different instance, on a remote instance, or runs on a remote SQL Server 2005 instance in SQL Server 2000 compatibility mode.******note, our reporting services IS in the same instance as the SQL Server 2000 database engine. However, upgrade advisor still reported that this instance can not be au
I have a valid license and install of SQL Server 2000 Enterprise. My Reporting Services disk (also Enterprise) is all scuffed up and doesn't work now. I wanted to install Reporting Services but could not find it anywhere. I found the "Evaluation" version
so I installed that.
1) How do I check when the MS Reporting Services evaluation will expire?
2) How the heck do I upgrade or install the full version of MS Reporting Services? or do I need to? Does the evaluation version just recognize that I have a "good" install of SQL 2000 and thus license it?
I've been working on my first asp.net application and for the most part it's been pretty smooth. Right now I'm having trouble getting reporting services working under SQL Server 2005. I developed the site with Visual Studio 2010 and didn't think about any of the .Net 4.0 compatibility issues that have arisen. I'm having no problems with the site communicating with SQL Server 2005 for the regular database stuff. The only problem I'm having is with setting up Reporting Services. I have the .Net 4.0 framework installed on the server, however Reporting Services is still using 2.x. I'm not sure if this is a problem with SSRS or with IIS. When i go to localhost/Reports it's reading my web.config for my application and throwing an error: "Parser Error Message: Unrecognized attribute 'targetFramework'." This is referring to a line in my web.config where targetFramework is set to 4.0.
Software that I'm using:
how to get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services
Thanks in advance
Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.
MSDN Magazine October 2006
Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.
MSDN Magazine July 2006
Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both WindowsÃÂ® Forms and Web-based applications.
MSDN Magazine June 2006
The solution covered here includes a custom SharePoint Web service that accepts SQL Server-generated report files and, through the WSS object model, stores the file in the appropriate library for enhanced collaboration possibilities.
MSDN Magazine March 2006
SQL Server 2005 Reporting Servicesis a great tool that offers a centralized approach to storing and rendering reports. It also lets users view and download reports without installing additional software. Plus, reports can be saved in any number of different formats using custom report renderers. In this article, the author will develop one such report renderer that outputs HTML reports, but the skills you'll learn can easily be used to create a renderer for Microsoft Word documents or any other format of your choosing.
MSDN Magazine February 2005
SQL Server 2000 Reporting Services--a server-based reporting platform built on the .NET Framework and integrated with SQL Server 2000--lets you easily add reporting from diverse data sources. Using Visual Studio and Reporting Services you can integrate reports from any data source that has an OLE DB, ODBC, or ADO.NET provider into your Web applications. This article explains how it's done.
John C. Hancock
MSDN Magazine August 2004