Course Code: 1148

Creating Reports Using SQL Server 2012 Reporting Services

Class Dates:
3 Days
Class Time:
Instructor-Led Training, Virtual Instructor-Led Training


  • Course Overview
  • In this course, you’ll learn about using Data Tools with Reporting Services to create report server projects. I’ll start by looking at installing the tools, including how when you install them from the SQL Server installation you don’t really get what you expect. Next you’ll learn about the two report server project types, as well as the report development environment you get with the Report Designer. Then you’ll see what report project properties are available and how they work, as well as how to use them with Visual Studio project configurations. And we’ll run through building a report from the ground up without using the project wizard, which is how you’ll probably normally work once you’ve learned how to use Reporting Services.

  • Audience
  • This course assumes that you have a basic familiarity with the concept of relational databases and a basic understanding of what SQL Server is and the high-level tools in it, as well as how to create and manage objects using Management Studio. You should also have a basic understanding of how SQL Server implements security, including its authentication and authorization schemes, and how to assign permissions on securable objects to principals.


Course Details

  • Introducing Data Tools
  • Introduction
  • Installing Data Tools
  • Report Project Types
  • Demo: Data Tools Interface
  • Demo: Add Item
  • Summary
  • Configuring Report Projects
  • Introduction
  • Report Properties
  • Deployment Properties
  • TargetServerVersion
  • Project Configurations
  • Configurations
  • Summary
  • Creating a New Report
  • Introduction
  • The Report Designer
  • Steps to Building a Report
  • Demo: Report Designer
  • Data Sets
  • Sorting Data
  • Data Set Settings
  • Summary
  • Building the Report
  • Introduction
  • Adding Components
  • Adding Data Regions
  • Formatting a Report
  • Dates and Currencies
  • Grouping
  • More Report Design
  • Summary