Training: SQL Reporting Services (SSRS) Essentials Online Feb 6

Michael Parker
Tue Feb 5 04:33:00 GMT 2019

Learn SSRS from the experts.
Designed For Reporting and Data Professionals

Reporting Services Essentials  Online Feb 6
Special Pricing $425

Dear Bob
Thanks for all the hard work


The focus of this class is report writing by connecting to a database and manipulating the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, sorting and filtering data, charting data, and preparing reports for printing and exporting.

The primary audience for this course are persons who are new to reporting with Microsoft? SQL Server? Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. 

    Data Sources and Data Sets
    Create Report Data Sources
    Create Report Datasets
    Work with the Tablix Data Region
    Create a Table Report
    Create Queries Using the Report Builder Query Designer
    Create Table Relationships Using Query Designer
    Create a Table Report Using Multiple Tables
    Create report data sources.
    Create report datasets.

    Formatting Reports
    Sorting and Filtering Report Data
    Adding Data to a Dataset
    Creating Simple Expressions
    Creating Complex Expressions
    Format Tablix Columns 
    Format Data in a Tablix Cell Using Properties
    Format Data in a Tablix Cell Using Simple and Complex Expressions 
    Sort Data Using Expressions
    Use Simple and Complex Expressions to Display Data in a Tablix
    Format data in a report using the Report Builder Properties dialog boxes.
    Add data to a report and make changes to column names in the dataset query.
    Format data in a report using simple and complex expressions.
    Display data in a report using simple and complex expressions.

    Group Data in Reports
    Group Data Using an Expression
    Creating Subgroups and Group Aggregates
    Lab : Creating Reports with Groups and Aggregates
    Display Grouped Data in a Report
    Create a Group Hierarchy in a Report
    Group Data Using a Complex Expression
    Add Aggregates to Tablix Rows
    Configuring a Reference Image
    Group data in reports using fields
    Group data in reports using expressions.
    Create group hierarchies.
    Aggregate grouped data in a report.

    Modifying Matrix Data Regions
    Creating and Modifying Column Groups
    Create Matrix Reports
    Create Column Groups
    Use Expressions to Sort Group Data
    Use Expressions to Display Group Names
    Create Matrix Reports with Group Hierarchies
    Describe the key features of using a matrix in a report. 
    Create and modify matrix reports.
    Define column group hierarchies. 
    Use expressions to define matrix headings and sort orders.

    Create and Modify Chart Wizard Reports
    Add Charts to Existing Reports
    Modify Charts in Reports
    Create a Chart Wizard Report
    Add a Chart to an Existing Report
    Use Expressions in Charts
    Use Expressions in Charts
    Describe the key features of charts.
    Create charts using the Chart Wizard and the Ribbon.
    Modify chart data and the formatting of chart elements.
    Use expressions in charts

    Print Features and Print Options
    Export Reports
    Exploring Page Layout view, Report Formatting, and Page Setup Options
    Exporting Reports
    Describe the key features of electronic reporting vs. print reporting.
    Prepare a report for paper printing.
    Export reports in supported formats.

Click Here For More Info


More information about the Gcc mailing list