PacktLib: Learning SQL Server 2008 Reporting Services

Learning SQL Server 2008 Reporting Services

Credits

About the Author

Acknowledgement

About the Reviewers

Preface

Overview of SQL Server Reporting Services 2008

Overview of enterprise reporting

Some highlights of SQL Server Reporting Services 2008

Installing SQL Server 2008

Hands-on exercise 1.1: Installing a named instance of SQL Server 2008

Hands-on exercise 1.2: Reviewing the installation

Hands-on exercise 1.3: Installing a test database

Hands-on exercise 1.4: Configuring the Report Services

Summary

Overview of SSRS 2008 Architecture and Tools

Architectural details and components

Report Server

Report Manager

Model designer

Report Builder

Extension components

Support for reporting in Visual Studio 2008

Reporting Server configuration file

Summary of Extensions

Summary

Report Integration with Microsoft ReportViewer Controls

ReportViewer features

Difference between web server and Windows forms versions

Hands-on 3.1: Using ReportViewer control for Windows

Hands-on 3.2: Modifying the previous report

Hands-on 3.3: Adding a graphic to the report

Hands-on 3.4: Using ReportViewer control for a web application

Summary

Visual Studio 2008 Business Intelligence Template Projects

Visual Studio 2008 Business Intelligence Projects

Report authoring

Hands-on exercise 4.1: Creating a Report Server project using the Report Server Wizard project

Deploying the report to the Report Server

Hands-on exercise 4.2: Deploying and viewing the report designed in Hands-on 4.1

Report Model

Using the Report Model project template

Hands-on exercise 4.3: Creating a Report Model using the Visual Studio 2008 template

Deploying the Report Model to the Report Server

Hands-on exercise 4.4: Deploying the Report Model

Hands-on exercise 4.5: Importing reports from MS Access 2003

Summary

Working with the Report Manager

Report Manager components

Hands-on exercise 5.1: Creating, deleting, and modifying folders

Report management

Hands-on exercise 5.2: Assigning users (or groups) to roles and permissions to access reports

Report viewing and printing

Hands-on exercise 5.3: View, print, and search

Hands-on exercise 5.4: Windows user access to a report on the Report Manager

Hands-on exercise 5.5 Deploying reports

Creating a new data source in Report Manager and generating a model from the data source

Hands-on exercise 5.6: Creating a new data source and generating a model using Report Manager

Modifying reports on a Report Server and creating linked reports with Report Manager

Hands-on exercise 5.7: Downloading a report definition file from the Report Serer

Hands-on Exercise 5.8: Working with the report cache

Hands-on exercise 5.9: Working with standard email, fileshare and data-driven subscriptions

Summary

Working with the Report Builder

Report Builder overview

Report Builder 2.0 user interface description

Hands-on exercise 6.1: Enabling and reviewing My Reports

Hands-on exercise 6.2: Modifying a basic report

Hands-on exercise 6.3: Creating reports with charts and gauges

Summary

Report Authoring with Report Builder 2.0

Report authoring

Hands-on exercise 7.1: Filtering data at source using a query parameter

Hands-on exercise 7.2: Working with a column group and setting up a document map

Hands-on exercise 7.3: Working with a subreport

Hands-on exercise 7.4: Creating a linked report

Hands-on exercise 7.5: Creating a drillthrough report

Hands-on exercise 7.6: Creating a report with XML data

Hands-on exercise 7.7: Ad hoc 1: Creating a tabular report with a Report Model

Hands-on exercise 7.8: Ad hoc 2: Creating a matrix report with a Report Model

Creating a report based on the Analysis Services cube

Summary

Programming Interfaces to Reporting Services

Overview of programming interfaces

Programming using URL access

Hands-on exercise 8.1: Displaying a report on the Report Server with an ASP.NET Web application using URL access

Hands-on exercise 8.2: Integrating a report on the Report Server with a Windows application using URL access

Programming the ReportViewer control

Hands-on exercise 8.3: Integrating a report on the Report Server with an ASP.NET Web application

Hands-on exercise 8.4: Displaying a report on the Report Server in a Windows application

Programming with the Report Server web services API

Hands-on exercise 8.5: Rendering a report on the Report Server with an ASP.NET Web application to other formats

Hands-on exercise 8.6: Rendering a report on the Report Server with an ASP.NET Web application to other formats.

Windows Management Instrumentation

Hands-on exercise 8.7: Identifying the Report Server instance and modifying some of the properties

Miscellaneous

Hands-on exercise 8.8: Creating a SQL Server Integration Services Package to display a report from the Report Server

Hands-on exercise 8.9: Using custom code in an expression

Summary

Crystal Reports 2008 in Visual Studio 2008

Crystal Reports 2008

Hands-on exercise 9.1: Integrating a saved Crystal Report into an ASP.NET application in Visual Studio 2008

Hands-on exercise 9.2: Creating a Crystal Report and integrating it into a Windows forms application

Hands-on exercise 9.3: Creating a Crystal Report and populating it with data at runtime

Hands-on exercise 9.4: Creating a Crystal Report and populating it with data from a stored procedure at run time

Hands-on exercise 9.5: Creating a Crystal Report and populating it with XML data.

Summary

On Programmatically Creating an SSRS Report

Introduction

The XMLTextWriter Class

Hands-on exercise 10.1: Generating a Report Definition Language file using Visual Studio 2008

Summary

Queries and Datasets in SSRS 2008

Queries and Datasets in SSRS 2008

Queries and Datasets in SSRS 2008

Queries and Datasets in SSRS 2008

Queries and Datasets in SSRS 2008

Converting Reports between RDL and RDLC

Converting Reports between RDL and RDLC

Converting Reports between RDL and RDLC

Converting Reports between RDL and RDLC

Converting Reports between RDL and RDLC

Converting Reports between RDL and RDLC

Command line utilities

Command line utilities

Command line utilities

Command line utilities

Notes and References

Notes and References

Notes and References

Notes and References

Notes and References

Notes and References

Notes and References

Notes and References

Notes and References

Notes and References

Notes and References

Notes and References

Notes and References

Notes and References

Notes and References

Index