SQL Server 2005 Reporting Services

Articles and Columns

• Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP
  

  Discover how to build an end-to-end ad hoc reporting solution for enterprise customers using Report Builder and Microsoft SQL Server 2005 Analysis Services OLAP with an example project based on a real-world implementation by Microsoft Business Intelligence Center of Excellence.

• Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services
  

  MSDN Magazine's Teo Lachev shows you how to take advantage of custom report items in SQL Server 2005 Reporting Services to transcend the limitations of traditional text-based reporting.

• Get More Out of SQL Server Reporting Services Charts
  

  This white paper presents general information, best practices, and tips for designing charts within Microsoft SQL Server Reporting Services reports.

• Designing and Delivering Rich Office Reports with SQL Server Reporting Services 2005 and SoftArtisans OfficeWriter
  

  This white paper explains how to use SQL Server Reporting Services 2005 and SoftArtisans OfficeWriter to design and deliver full fidelity, data-driven Microsoft Excel and Word reports.

• Reporting Services: Using XML and Web Service Data Sources
  

  This paper consolidates general information, best practices, and tips for designing Microsoft SQL Server Reporting Services (SSRS) reports. It is intended to provide a starting point for design questions and an overview of some of the capabilities of Reporting Services.

• Using Visual Studio 2005 to Perform Load Testing on a SQL Server 2005 Reporting Services Report Server
  

  Microsoft Visual Studio 2005 Team System includes a load-test tool that you can use for performance and stress testing of a Microsoft SQL Server 2005 Reporting Services deployment. The load-test tool runs the tests that you create, and optionally logs the data into a SQL Server 2005 database.

• Deliver SQL Server Reports To SharePoint To Enhance Team Collaboration
  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.
• SQL Server 2005 Reporting Services
  This document describes the new capabilities in SQL Server 2005 Reporting Services.
• Integrating Reporting Services into Your Application
  Discover the different ways that developers can integrate SQL Server 2005 Reporting Services capabilities in their applications.
• Report Design: Best Practices and Guidelines
  This paper consolidates general information, best practices, and tips for designing Reporting Services reports. It is intended to provide a starting point for design questions and an overview of some of the capabilities of Reporting Services.
• Planning for Scalability and Performance with Reporting Services
  This paper provides information about the scalability characteristics of different Reporting Services implementation architectures. It also offers guidelines, suggestions, and tips for running your own performance tests with Microsoft SQL Server Reporting Services.
• Report Definition Language Specification
  This document specifies the structure, semantics, and interpretation of the Report Definition Language (RDL), an XML-based schema for representing reports.