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)

1/4