
IT EXPERT SYSTEM, INC
IT Training, Staffing and IT Services Provider
Empower Clients Through IT
Schaumburg | Des Plaines | Naperville IL, USA
Microsoft SQL Server Reporting Service
Overview
SQL Server Reporting Services is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS and SSIS. Administered via a Web interface, it can be used to prepare and deliver a variety of interactive and printed reports.
Course Content
-
Introduction and download SSRS
-
Preparing to create reports
-
Exploring data source
-
Creating first report
-
Standard Number Formatting
-
Custom Number Formatting
-
Date Formatting
-
Sort and Group
-
Visibility and Tables Headers
-
More advanced techniques (Indicator, Gauges, Adding totals)
-
Creating a categorized report
-
Creating hyperlinks
-
Adding a parameter
-
Adding a subreport
-
Graphical Reports (Pie chart, Bar chart, Mapping data, Matrix)
-
Object Properties
-
Functions (Program Flow Functions, Aggregate function, Math functions, Text functions)



