SQL Server Magazine August Update Service
* Reporting Services
SQL Server Reporting Services, set for release by the end of the
year, will fill the only hole in the SQL Server product--the lack of a
built-in reporting component. Here are Reporting Services' seven most
important features.
--Michael Otey

*** From Michael Otey's SQL SERVER MAGAZINE ARTICLE

SQLServer 2000 Reporting Services promises to fill the only real hole in the SQL Server product—the lack of a built-in reporting component. Once scheduled for release with the Yukon version of SQL Server, this new reporting functionality will now be available as a download by the end of the year. Here are Reporting Services' seven most important features.

7. Support for SQL Server and Analysis Services
Reporting Services can create reports for relational databases such as SQL Server and for Analysis Services. This flexibility lets users generate reports from SQL Server databases or Analysis Services cubes without using Office or other external applications.

6. Multiple Reporting Options
Reporting Services supports a variety of reporting formats, including Web-based, XML, email, and standard printed reports. In addition to these basic options, Reporting Services supports several more-sophisticated formats including Excel, PDF, and custom formats.

5. Multiple Data-Source Options
Reporting Services isn't limited to using data from Analysis Services and SQL Server databases. The new product is compatible with other databases, including Oracle. Data-source options include ODBC, OLE DB, XML for Analysis, and Web services. Reporting Services can use multiple data sources for a single report and can even use reports as sources for other reports.

4. Flexible Report Delivery
With support for both push- and pull-style report delivery, Reporting Services provides a flexible mechanism for generating reports. In pull-style report delivery, users can run previously created reports on demand. Users can also automate push-style report delivery so that the reporting server generates reports based on predetermined events, for example. Or, an administrator might set the server to generate a report every day at noon, then push the report to users.

3. Report Management
With Reporting Services, SQL Server uses a central catalog to publish and manage report definitions. The central catalog lets users subscribe to personalized reports and lets administrators limit who can run individual reports.

3. .NET Integration
Reporting Services provides a managed-code API that you can use to execute existing report definitions and produce custom report formats and renderings for multiple output devices. You can render reports for various printers, Windows graphical forms, Web-based HTML forms, and even handheld PC devices.

1. Graphical Report Authoring
Reporting Services has a powerful graphical report designer that lets users create report definitions by dragging and dropping design and data elements. Users can also preview reports and make changes before generating final report definitions.

SQL SERVER MAGAZINE ARTICLE

>Ref your comment on the SQL Server Reporting Engine...I believe this won't ship for some time as it is intended to part of Yukon. There was a suggestion that it would come out like Notification Services for 2000, but nothing definite.
>
>My employers here in New Zealand developed their own printing mechainsm using the Windows API and products from AmyUni to create all output as RTF documents. The reason is that there is a fundamental requirement to have an intermediate output stage where the reports can be edited and then those changed documents printed out.
>
>Regards
>Simon