Free Sample
+ Collection
Code Files

Learning SQL Server 2008 Reporting Services

Jayaram Krishnaswamy

A step-by-step book and eBook to getting the most of Microsoft SQL Server Reporting Services 2008
RRP $29.99
RRP $49.99
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781847196187
Paperback512 pages

About This Book

  • Everything you need to create and deliver data-rich reports with SQL Server 2008 Reporting Services as quickly as possible
  • Packed with hands-on-examples to learn and improve your skills
  • Connect and report from databases, spreadsheets, XML Data, and more
  • No experience of SQL Server Reporting Services required

Who This Book Is For

This book is for anyone who is new to SQL Server 2008 Reporting Services and needs to create and deploy reports. The book is suitable for report developers, data analysts, and report server database administrators.

You will need to know the basic concepts of SQL Server, but not necessarily be very familiar with SQL Server 2008.

Table of Contents

Chapter 1: 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
Chapter 2: 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
Chapter 3: 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
Chapter 4: 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
Chapter 5: 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
Chapter 6: 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
Chapter 7: 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
Chapter 8: 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
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
Chapter 9: 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.
Chapter 10: On Programmatically Creating an SSRS Report
The XMLTextWriter Class
Hands-on exercise 10.1: Generating a Report Definition Language file using Visual Studio 2008

What You Will Learn

  • Install SQL Server 2008 and configure the SQL Server Reporting Services
  • Learn the various components and tools that enable end-to-end support for all reporting activities
  • Use the report viewer control to get started with the essentials of retrieving and displaying data
  • Create a Report Model using the Visual Studio 2008 Template
  • Learn to modify reports on a report server and create linked files with report manager
  • Embed Microsoft Report Viewer Controls in web and Windows applications
  • Create interactive reports with charts and gauges using Report Builder
  • Create several kinds of reports with Report Builder 2.0
  • Create server reports and report models and deploy them
  • Get the full details of available programming interfaces and their usage
  • Learn to work with Crystal Reports 2008
  • Import reports created using MS Access
  • Learn how to use the Programming API, convert Report file types, use command-line utilities and more

Chapter 1 – An overview detailing the requirements and major highlights of the Reporting Services.

Chapter 2 – Presents the salient architectural details and describes the details of how the different elements of the reporting services fit together to deliver end-to-end support for reporting.

Chapter 3 – Discusses details regarding the usage of Report Viewer Controls, covering both web and Windows forms applications.

Chapter 4 – Discusses the built-in features in Visual Studio 2008 to generate server-based reports and report models. It also describes importing MS Access reports.

Chapter 5 – Describes Report Manager and some of the basic tasks that can be carried out with this tool as well as Email, File Share, and Data Driven subscriptions.

Chapter 6 – This chapter describes the Report Builder 2.0 interface together with the new features that are incorporated into this version. It also describes charts and gauges and their inclusion in reports.

Chapter 7 – This chapter describes the various kinds of reports that one can build using the standalone tool Report Builder 2.0. It also describes data originating in SQL Server, SQL Analysis Server and Report Models.

Chapter 8 – This chapter describes a number of programming interfaces available to work with the SQL Server Reporting Services. Using these interfaces facilitates integration and maintenance of reports into web and Windows applications and configuring reporting services.

Chapter 9 – This chapter describes Crystal Report 2008 and its integration with SQL Server Reporting Services 2008 using a number of examples.

Chapter 10 – Programmatic generation of reports is always a very useful feature as it draws upon the complete API. This chapter deals with creating a report using code that calls the API procedures and also presents an introduction to the.

Appendix A – This appendix describes the different sources of data that are used in Reporting Services. It also describes the differences between SQL Queries, MDX, and Semantic queries and presents how each of them is supported in the Query Designer.

Appendix B – This appendix describes the conversion of RDL to RDLC and RDLC to RDL. Presently this is limited to only RDLC to RDL conversion.

Appendix C – This appendix describes the rs.exe command-line and also describes the tools rsconfig and rskeymgmt.

Appendix D – This appendix details some of the major references and links to online references.

In Detail

Microsoft SQL Server Reporting Services 2008 is the third generation Microsoft reporting software that is more tightly integrated with SQL Server 2008 than ever before. It provides a complete server-based platform that is designed to support a wide variety of reporting needs, including managed enterprise reporting, special purpose reporting, embedded reporting, and web-based reporting.

Ideal for beginners who need to create reports as quickly as possible, this book will lead you through practical examples to teach you a full range of skills for reporting with SQL Server 2008 Reporting Services. A series of carefully picked exercises help you practice the most important aspects of report creation. By the end of the book, you will have the confidence to take on the most complex of reports, and be producing reports that will make you the envy of your organization.


Read More