How to: Create and Consume a Microsoft SQL Server Reporting Services Report

1
How to Create and Consume a Microsoft SQL Server
Reporting Services Report

• James HippoliteSenior .NET DeveloperTelecom New
  Zealand Limited

2
Agenda

• Reporting Methodology Overview
• Ad hoc
• Pre-defined
• Create and Deploy a Report
• Report Designer
• Consume a Report
• Report Viewer
• Questions?

3
Report Methodology Overview

• Ad hoc
• Information worker
• Knows what info required
• Doesnt have technical skill
• Requires
• Making physical data source schemas easier to
  understand
• Simplifying the overall report-authoring
  experience
• Objectives met through
• Report Models
• Report Builder

• Pre-defined
• IT staffer
• Has technical skills
• Not available on demand
• Requires
• Hosting application
• Defined data source
• Report Designer
• Hosting server
• Objectives met through
• VS2008 web project
• SQL2005 BIDS
• SSRS2005

4
Create a Report

• Report Designer
• Set of graphical tools and windows that run
  within Visual Studio 2005
• Tool for creating and publishing report
  definitions
• Installed through SS2005

• Steps
• Configure the Data Source
• Create a Report with the Report Wizard
• Edit a Generated Report

5
Demo Creating a Report
6
Deploy a Report

• Same process for test and production
• Must have Publisher role-based permission on
  report server
• Select appropriate configuration DebugLocal,
  Debug, Production
• Set properties
• Overwrite Data Sources
• Target Data Source Folder
• Target Report Folder
• Target Server URL
• Build and Deploy (F5)

7
Demo Deploy a Report
8
Consume a Report

• Report Viewer
• .NET Server Control
• Renders either
• Local Report
• Report Server

• Steps
• Embedded on page
• Use code behind to set parameters

9
Demo Consume a Report
10
QA

• http//www.geekzone.co.nz/JamesHip/
• SQL Server Books Online