SQL Server 2005 Reporting Services
White Papers
Performance Recommendations for Storage Planning and Monitoring
This paper provides key recommendations and best practices to help administrators of Microsoft Office SharePoint Server 2007 plan and monitor their SQL Server storage requirements to support optimal performance and operation of their server farms.
SQL Server 2005 Integration with Microsoft SharePoint Products and Technologies
Microsoft SQL Server 2005 SP2 introduced tight integration between SQL Server Reporting Services and Microsoft SharePoint Products and Technologies to provide a single-user environment with which to manage and execute reports. This paper shows how to configure the integration of Reporting Services and SharePoint Products and Technologies. It also shows how to manage reports and publish them to a SharePoint site.
Troubleshooting Integration with SQL Server 2005 and Microsoft SharePoint Technologies
Microsoft SQL Server 2005 SP2 introduces tight integration between Reporting Services and Microsoft SharePoint Products and Technologies to enable a single user environment with which to manage and execute reports. This white paper shows how to administer the integration between Reporting Services and SharePoint Products and Technologies and provides troubleshooting tips in the event that problems arise.
Report Design Tips and Tricks
This white paper covers best practices on report design and helps you avoid common mistakes when choosing a report layout and output format. Take advantage of existing product features to achieve the results you want. The paper includes report and code examples that implement functionality that is frequently asked for.
Using SQL Server 2005 Reporting Services with SAP NetWeaver Business Intelligence
Through a rich extensibility model, the report authoring and report deployment features of SQL Server Reporting Services 2005 can integrate with any number of business intelligence data sources. To answer the strong need for a rich reporting tool for SAP NetWeaver BI and to bridge the gap between these two powerful business intelligence platforms, Microsoft has developed a new .NET Data Provider and Query Designer for SAP NetWeaver Business Intelligence. SAP BW users can now take advantage of the flexible, yet easy-to-use reporting capabilities of Reporting Services without migrating their data to another platform. Report authoring is performed in the familiar and easy-to-use Business Intelligence Development Studio, using a custom-built query designer, and deployment is a simple one-step process that targets the Web as the reporting platform. Report distribution is now as simple as distributing a hyperlink. It has never been easier to get your important SAP business intelligence to the people who need it.
SQL Server 2005 Reporting Services - Planning for Scalability and Performance
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.
Using SQL Server 2005 Reporting Services with SQL Server 2005 Express Edition
This paper introduces using SQL Server 2005 Reporting Services with SQL Server 2005 Express Edition. It discusses key scenarios for using each product and how to design and develop Reporting Services solutions.
Guide to Migrating from Oracle to SQL Server 2005
This white paper explains the entire migration process using SQL Server Migration Assistant for Oracle (SSMA Oracle) in depth, with a special focus on converting database objects and PL/SQL code.
Guide to Migrating from Sybase ASE to SQL Server 2005
This paper describes how SQL Server Migration Assistant, the best tool for this type of migration, can help resolve various migration issues. It also includes instructions for handling the differences between the two platforms.
Using SQL Server 2005 Reporting Services with Hyperion Essbase
This paper discusses the integration of Hyperion Essbase with SQL Server 2005 Reporting Services Service Pack 2, and provides an overview of how Reporting Services can be used to build high-quality reports against Hyperion Essbase sources. Hyperion-specific terms that may be unfamiliar are briefly explained. A number of useful tips and tricks for working with the two systems are presented. A brief troubleshooting section helps users overcome some of the more common problems that may be encountered. Overall, this paper is intended to serve as a guide to help users benefit from the integration of these two products.
Integrating Reporting Services into Your Application
This paper summarizes the different ways that developers can integrate SQL Server 2005 Reporting Services capabilities in their applications.
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.
Building a Localized Report on a SQL Server 2005 Analysis Service Cube Data Source
Learn how to use an Analysis Services cube as a data source by using parameterized MDX queries, as well as how to localize label strings in a report, in SQL Server 2005.
Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP
This paper introduces SQL Server 2005 Report Builder and demonstrates how to build an end-to-end ad hoc reporting solution for enterprise customers using Report Builder and SQL Server 2005 Analysis Services OLAP. We also highlighted a few product limitations as well as enterprise considerations. It is based on a real world implementation by Microsoft Business Intelligence Center of Excellence.
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. OfficeWriter consists of a designer component that turns Excel and Word into a powerful tool for designing Reporting Services reports, and custom rendering extensions that deliver real binary Excel and Word documents. The paper also covers the process by which these reports are created, previewed, deployed, and delivered.
Developing Report Navigation and Drilldown
This article presents an excerpt from the book, Microsoft SQL Server 2005 Reporting Services for Dummies, by Mark Robinson. Learn how to produce interesting navigation and drill down reporting using the basic tools provided within SQL Server 2005 Reporting Services.
Extending SQL Server Reporting Services with SQL CLR Table-Valued Functions
This article describes how to take advantage of SQL CLR table-valued functions to combine different types of data sources to create rich and exciting SQL Server Reporting Services reports.
Migrating from Business Objects Crystal Reports to SQL Server 2005 Reporting Services
This document assists Crystal Report designers with migrating to Microsoft SQL Server 2005 Reporting Services using a step-by-step migration strategy.
Monitoring Report Execution Performance with Execution Logs
This article presents an excerpt from the book, Microsoft SQL Server 2005 Reporting Services Step by Step, by Stacia Misner and Hitachi Consulting. Learn how to monitor reporting services by implementing an execution logging database and reviewing reports that query that database.
Reporting Services: Using XML and Web Service Data Sources
This white 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. You can monitor tests as they progress, review performance data after the tests are completed, and precisely determine what the threshold is for a specific report-server deployment. This article contains step-by-step instructions for creating a Web page load test, and sample code and instructions for creating a unit test. Also, instructions are provided for setting up the load test that you use to specify load patterns. The article assumes that you have the AdventureWorks sample database and reports, so that you can try these steps on your computer.
