Creating Reports Using SQL Server 2012 Reporting Services
CLASS DATE(s):
Request a Class

COURSE LENGTH: 3 Days

COURSE COST: $1495

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print

COURSE OVERVIEW

In this course, you値l learn about using Data Tools with Reporting Services to create report server projects. I値l start by looking at installing the tools, including how when you install them from the SQL Server installation you don稚 really get what you expect. Next you値l learn about the two report server project types, as well as the report development environment you get with the Report Designer. Then you値l 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値l run through building a report from the ground up without using the project wizard, which is how you値l probably normally work once you致e learned how to use Reporting Services.

AUDIENCE AND PREREQUISITES

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 Cost listed does not include the cost of courseware or lunch, required in your registration. Please refer to your Enrollment Sales Order or Invoice for the additional cost. If you have any questions, please contact us (learn@vtec.org or 207-775-0244). Course subject to minimum enrollment. This course does not use Office Micorsoft cirriculum. This course is not considered a MOC class; it is not a certification-centered course.

COURSE TOPICS:


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