This 2 day course is an introduction to creating reports using Report Builder 3.0. It is designed for experienced Excel or Access users wanting to create reports for use with Microsoft Reporting Services, which is a component of Microsoft SQL Server.

Download the course details

Knowledge of SQL or querying SQL server databases using T-SQL. Familiarity with data processing techniques and concepts and the ability to use a graphical user interface.

  • SSRS Architecture and key components
  • Reporting life cycle in Reporting services
  • About Report Builder 3.0
  • Report Builder environment
  • Demo: Creating basic report with report builder 3.0
  • About data sources and datasets
  • Creating embedded/shared data sources and datasets
  • Applying basic formatting in report – hands-on
  • Understanding Expressions
  • Functions
  • String, date time and decision functions
  • Printing, Exporting and saving reports
  • About Data Regions available in Report Builder
  • About Table, Matrix, and List data regions
  • Gauge and chart data visualization regions
  • Using Indicators in Table region
  • Creating Sparklines/Data bars in a Report
  • Grouping Data in a Report
  • Aggregating/ Summarising data in a Report
  • Report Parameters
  • Report Vs Query parameters
  • Creating Cascading Parameters
  • Applying filters on the report
  • Filters at report and data region level
  • Sorting data in the report
  • Implementing Document maps
  • Implementing Interactive sorting
  • Creating Subreports
  • Creating Drill-through reports
  • Report management fundamentals
  • About Report Manager
  • Security in reporting services
  • Item level and system level security
  • Understanding subscriptions
  • Prerequisites for standard subscription
  • Email and file-share subscriptions
  • Creating Data Source and Data sets
  • Formatting Text Report
  • Saving, Exporting and Printing Reports
  • Creating a Basic Tabular and Matrix Report
  • Creating a Basic Chart, Pie Chart and Bar Chart Report
  • Adding Sparkline and KPI to your Report
  • Creating parameters and filtering data in the Report
  • Implementing drill-down, drill through and Interactive sorting in Reports
  • Setting up report permissions and subscriptions in Report Manager
Dates & Prices

This course is run by arrangement for private groups and 1-2-1 sessions.

Please contact us for more information

01483 688488

Contact us

Have a question?

We're here to answer them

01483 688488

Contact us
We’re trusted by