Learning SQL Server 2008 Reporting Services -- Table of Contents -- Learning SQL Server 2008 Reporting Services -- Credits -- About the Author -- Acknowledgement -- About the Reviewers -- Preface -- What this book covers -- What you need for this book -- Who is this book for -- Conventions -- Reader feedback -- Customer support -- Errata -- Piracy -- Questions -- 1. Overview of SQL Server Reporting Services 2008 -- Overview of enterprise reporting -- Some highlights of SQL Server Reporting Services 2008 -- Scalability -- New Tablix design feature -- Enhancement to Report Design -- Data visualization -- Installing SQL Server 2008 -- Version of SQL Server 2008 to be installed -- Hardware requirements -- System and software requirements -- Hardware and software used for working with the book -- Hands-on exercise 1.1: Installing a named instance of SQL Server 2008 -- Getting ready -- Follow the steps -- Installation choices and notes -- Hands-on exercise 1.2: Reviewing the installation -- Program shortcuts -- Reviewing installed services -- Starting/stopping Reporting Services -- Accessing installed services from the SQL Server Management Studio -- Post installation checks -- Hands-on exercise 1.3: Installing a test database -- Getting sample databases into the server -- Hands-on exercise 1.4: Configuring the Report Services -- Report Server configuration options -- Summary -- 2. Overview of SSRS 2008 Architecture and Tools -- Architectural details and components -- Report Server -- Report Server and HTTP -- Report processing -- Report Server backend -- Reporting Services and the database engine -- Report Manager -- Starting Report Manager -- Model designer -- Report Builder -- Report Builder 1.0 -- Report Builder 2.0 -- Report Builder features -- Extension components -- Data processing -- Rendering -- Scheduling and delivery.

Support for reporting in Visual Studio 2008 -- ReportViewer controls -- ReportViewer control for Windows applications -- ReportViewer control for Web applications -- Business intelligence support -- Reporting Server configuration file -- Summary of Extensions -- Summary -- 3. Report Integration with Microsoft ReportViewer Controls -- ReportViewer features -- Toolbar -- Difference between web server and Windows forms versions -- Hands-on 3.1: Using ReportViewer control for Windows -- Getting ready -- Follow the steps -- Create a Windows project -- Add a ReportViewer control -- Configure the report using the Report Wizard -- Configure the Data Source -- Design the report -- Preview the report -- Report details of the RDLC file -- Features of report binding to form -- Hands-on 3.2: Modifying the previous report -- Follow the steps -- Modifying an existing report -- Hands-on 3.3: Adding a graphic to the report -- Follow the steps -- Hands-on 3.4: Using ReportViewer control for a web application -- Getting ready -- Follow the steps -- Creating an ASP.NET web site project and adding a dataset using the Query Builder Tool -- Adding a report template -- Summary -- 4. Visual Studio 2008 Business Intelligence Template Projects -- Visual Studio 2008 Business Intelligence Projects -- Using the Report Server project template -- Using the Report Server wizard project template -- Using the Report Model project template -- Report authoring -- Data sources used in reports -- Embedded data sources -- Shared data sources -- Report Data and Query Designer -- Report designer -- Report items toolbox -- Expression builder -- Other design tools -- Hands-on exercise 4.1: Creating a Report Server project using the Report Server Wizard project -- Connecting to a data source -- Building a query -- Designing the report -- Deploying the report to the Report Server.

Methods of deploying reports 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 -- Getting ready -- Follow the steps -- Creating a new Report Model Project -- Defining a Data Source for the Report Model -- Defining a Data Source view for the Report Model -- Defining the Report Model -- 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 -- Getting ready -- Follow the steps -- Summary -- 5. Working with the Report Manager -- Report Manager components -- Folder structure and hierarchy -- Sub-items in folder hierarchy -- Hands-on exercise 5.1: Creating, deleting, and modifying folders -- Creating a folder -- Deleting a folder -- Moving a folder -- Modifying a folder -- Report management -- Permissions in Reporting Services -- Hands-on exercise 5.2: Assigning users (or groups) to roles and permissions to access reports -- Getting ready -- Hands-on 5.2.1: Assigning a Windows user to System Administrator role -- Creating a Windows user -- Assigning a user to the System Administrator role -- Hands-on 5.2.2: Assigning users to item-level roles -- Creating a Windows user -- Assigning users to roles -- Hands-on 5.2.3: Assigning a user to a custom role -- Hands-on 5.2.4: Creating a permission to a specific report -- Permitting only the user Navika to this report -- Report Data Sources -- Report viewing and printing -- Hands-on exercise 5.3: View, print, and search -- Viewing reports -- Printing reports -- Printing report from the Print button on report -- Changing report format for printing -- Search for reports -- Find text in a report.

Managing data source connections with Report Manager -- Connecting to report data sources -- Connect using user supplied credentials -- Connect using stored credentials -- Connect using Windows integrated security -- Connection that does not require credentials -- Hands-on exercise 5.4: Windows user access to a report on the Report Manager -- Getting ready -- Deploying reports -- Hands-on exercise 5.5 Deploying reports -- Deploying a single report -- Deploying a report with a shared data source -- Uploading a report using the Report Manager -- 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 -- Create new data source -- Generating a model using Report Manager -- Modifying reports on a Report Server and creating linked reports with Report Manager -- Modifying reports -- Linked reports -- Hands-on exercise 5.7: Downloading a report definition file from the Report Serer -- Report delivery (new or cached) -- On demand -- Report caching -- Hands-on Exercise 5.8: Working with the report cache -- Turn on cache and cache a report -- Schedule a report cache -- Create a cache from execution snapshot -- Report subscription -- Hands-on exercise 5.9: Working with standard email, fileshare and data-driven subscriptions -- Creating an email subscription -- Creating a file share subscription -- Creating a data-driven subscription -- Create a Subscriber database in SQL Server 2008 -- Populate a table in Subscribers database -- Creating the data-driven subscription and testing it -- Summary -- 6. Working with the Report Builder -- Report Builder overview -- Report Builder 2.0 user interface description -- The menu for file operations -- The ribbon -- Home -- Insert -- Data Regions -- Table -- Matrix -- List -- Chart -- Gauge.

Report Items -- Subreports -- Header and footer -- View -- Report Data, the Report Designer, and the properties -- Report Data -- Report Designer pane -- Properties -- Server status and tools -- Hands-on exercise 6.1: Enabling and reviewing My Reports -- Getting ready -- Hands-on exercise 6.2: Modifying a basic report -- Getting ready -- Follow the steps -- Open Report Builder and open the ByOrders.rdl report -- Review the imported MS Access report -- Hands-on exercise 6.3: Creating reports with charts and gauges -- Getting ready -- Follow on -- Creating a Microsoft Excel spreadsheet with some data -- Create an ODBC DSN to access the data -- Create a datasource using a DSN in Report Builder 2.0 -- Create a Dataset based on the data in the Excel file -- Design a report to display the data -- Format a column based on some criterion -- Create a chart to display the data -- Add gauges to display the data -- Add a report item to display the average value of a column -- Add a gauge to display this average -- Create a bookmark and jump to it -- Create a bookmark using the Bookmark property -- Jump to bookmark using the Action property -- Summary -- 7. Report Authoring with Report Builder 2.0 -- Report authoring -- Hands-on exercise 7.1: Filtering data at source using a query parameter -- Parameterized reports -- Follow on -- Creating a data source -- Query design -- Parameter design -- Viewing the Report -- Hands-on exercise 7.2: Working with a column group and setting up a document map -- Follow on -- Removing the parameter from the previous hands-on -- Group the results by "City" -- Adding a Document Map for the report -- Add interactive sort -- Hands-on exercise 7.3: Working with a subreport -- Follow on -- Create a data source for the subreport -- Add a dataset to the subreport -- Add a table to the subreport.

Changing background color of alternate rows.