Cisco Training Courses

Insoft has been serving IT community with official Cisco training offering since 2010. Find all the relevant information on Cisco training on this page.

View More

Cisco Certifications

Experience a blended learning approach that combines the best of instructor-led training and self-paced e-learning to help you prepare for your certification exam.

View More

Cisco Learning Credits

Cisco Learning Credits (CLCs) are prepaid training vouchers redeemed directly with Cisco that make planning for your success easier when purchasing Cisco products and services.

Have CLCs and want to redeem them?

Cisco Continuing Education

The Cisco Continuing Education Program offers all active certification holders flexible options to recertify by completing a variety of eligible training items.

View More

Cisco Digital Learning

Certified employees are VALUED assets. Explore Cisco official Digital Learning Library to educate yourself through recorded sessions.

Browse CDLL Catalogue

Cisco Business Enablement

The Cisco Business Enablement Partner Program focuses on sharpening the business skills of Cisco Channel Partners and customers.

View More

Fortinet Technical Certifications

The Fortinet Network Security Expert (NSE) program is an eight-level training and certification program to teach engineers of their network security for Fortinet FW skills and experience.

View More

Fortinet Technical Courses

Insoft is recognised as Fortinet Authorized Training Center in selected locations across EMEA.

View More

Official ATC Status

Check our ATC Status across selected countries in Europe.

View More

Fortinet Services Packages

Insoft Services has developed a specific solution to streamline and simplify the process of installing or migrating to Fortinet Products.

Browse Packages

Prepforce Bootcamp

The only comprehensive source available today to prepare for Fortinet NSE 8 certification globally.

View More

Microsoft Training

Insoft Services provides Microsoft training in EMEAR. We offer Microsoft technical training and certification courses that are led by world-class instructors.

View More

Technical Training

The evolution of Extreme Networks Technical Training provides a comprehensive progressive pathway from Associate to Professional accreditation.

View More

ATP Accreditation

As an authorised training partner (ATP), Insoft Services ensures that you receive the highest standards of education available.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

Our Mission: Provide an expert set of modern & leading edge Network Automation skills to the market through professional services.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

 

We help organisations to deploy Software-Defined Networking (SDN) solutions, such as Cisco DNA. Besides, our team has extensive experience in integrating Cisco DNA Center with third-party systems.

View More

 

In a world where technologies are evolving rapidly, every company - business needs a partner to rely on and trust for the smooth and secure operation of its network infrastructure.

View More

About Us

Our training portfolio includes a wide range of IT training from IP providers, including Cisco, Extreme Networks, Fortinet, Microsoft, to name a few, in EMEA.

View More

Writing Reports with Report Builder and SSRS Level 1

X

Contact Us

We would love to hear from you. Please complete this form to pre-book or request further information about our delivery options.

Subscribe

I'd like to receive emails with the latest updates and promotions from Insoft.

Data Protection & Privacy

I hereby allow Insoft Ltd. to contact me on this topic. Further, I authorise Insoft Ltd. processing, using collecting and storing my personal data for the purpose of these activities. All your data will be protected and secured as outlined in our privacy policy.


Writing Reports with Report Builder and SSRS Level 1

Enroll Now
Writing Reports with Report Builder and SSRS Level 1
Duration
2 Days
Delivery
(Online and onsite)
Price
Price Upon Request

In this 2-day course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on 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.

Report Builder 3.0 is available for Microsoft® SQL Server® versions 2014, 2012, and 2008 R2.

  • Navigate the Report Builder Environment.
  • Create table reports.
  • Format reports.
  • Create basic and complex expressions.
  • Group report data.
  • Create matrix reports.
  • Sort and filter data.
  • Summarize data with charts.
  • Print and export reports.

Module 1: Exploring the Report Builder Environment

This module introduces the Report Builder application and its features. You will explore the Ribbon and its Tabs, Command groups, and Commands, the available Window panes for creating and manipulating reports, and the report design surface using Design and Run modes.

Lessons

  • Introducing the Report Builder Environment
  • Working with Existing Reports

Lab 1: Exploring the Report Builder Application

  • Navigating the Ribbon and Window panes
  • View Existing Reports in Design and Run modes

After completing this module, students will be able to:

  • Describe and navigate the graphical elements of the Report Builder application.
  • Work with existing reports and navigate between Design and Run modes.

 

Module 2: Adding Data to Table Reports

This module introduces how to populate a report with data and display that data in a table data region on the report. We will begin with defining the data source and continue with query building through data sets to bring data into the report. Next, we will explore the elements of the tablix data region including rows, columns, cells, handles, and field choosers, you will use in displaying your data.

Lessons

  • Create Report Data Sources
  • Create Report Datasets
  • Work with the Tablix Data Region
  • Create a Table Report

Lab 1: Creating Table Reports

  • Create Queries Using the Report Builder Query Designer
  • Create a Table Report Using a Single Table
  • Create Table Relationships Using Query Designer
  • Create a Table Report Using Multiple Tables

After completing this module, students will be able to:

  • Create report data sources.
  • Create report datasets.
  • Work with the tablix data region.
  • Create a table report

 

Module 3: Formatting Data and Creating Expressions in Reports

This module introduces report formatting techniques which allow a report writer to control how and where data displays in the report. Additional data may also be required and this can be accomplished by adding data from a source or adding a calculated field to the dataset. Simple and complex epressions will also be introduced in this topic.

Lessons

  • Formatting Reports
  • Sorting and Filtering Report Data
  • Adding Data to a Dataset
  • Creating Simple Expressions
  • Creating Complex Expressions

Lab 1: Formatting Reports

  • 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

After completing this module, students will be able to:

  • 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.

 

Module 4: Grouping Report Data

This module introduces data groupings in reports using dataset fields and using expressions. This module also discusses group hierarchies and adding aggregates to summarize grouped data.

Lessons

  • Group Data in Reports
  • Group Data Using an Expression
  • Creating Subgroups and Group Aggregates

Lab 1: 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

After completing this module, students will be able to:

  • Group data in reports using fields.
  • Group data in reports using expressions.
  • Create group hierarchies.
  • Aggregate grouped data in a report.

 

Module 5: Matrix Reports

This module introduces matrix data regions which are used in reports to control how crosstabular data can be used. While table reports rely on rows and columns, matrix reports rely on row groupings, column groupings, and aggregated values.

Lessons

  • Creating and Modifying Matrix Data Regions
  • Creating and Modifying Column Groups

Lab 1: Creating Matrix Reports

  • Create Matrix Reports
  • Create Column Groups
  • Use Expressions to Sort Group Data
  • Use Expressions to Display Group Names
  • Create Matrix Reports with Group Hierarchies

After completing this module, students will be able to:

  • 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.

 

Module 6: Charts

This module introduces the ability to create and add charts to reports. Whether through wizard or individual effort, chart reports or charts as report components allow us to visualize data with or without the details.

Lessons

  • Create and Modify Chart Wizard Reports
  • Add Charts to Existing Reports
  • Modify Charts in Reports

Lab 1: Creating Charts and Chart Reports

  • Create a Chart Wizard Report
  • Add a Chart to an Existing Report
  • Format Chart Elements
  • Use Expressions in Charts

After completing this module, students will be able to:

  • 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.

 

Module 7: Printing and Exporting Reports

This module introduces report printing and exporting. Reports can be created for electronic display, paper display, or display in another application. This module covers the basics of those three scenarios.

Lessons

  • Print Features and Print Options
  • Export Reports

Lab 1: Printing and Exporting Reports

  • Exploring Page Layout view, Report Formatting, and Page Setup Options
  • Exporting Reports

After completing this module, students will be able to:

  • Describe the key features of electronic reporting vs. print reporting.
  • Prepare a report for paper printing.
  • Export reports in supported formats.

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.

The secondary audience for this course are persons who are using Report Designer (SSRS).

Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft® SQL Server® Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.

  • Familiarity with Windows.
  • Creating and navigating folders.
  • Opening programs.
  • Manipulating windows.
  • Copying and pasting objects.
  • Formatting text.
  • Saving files.
  • Microsoft® Office Access 2013: Level 1 or have equivalent experience with basic database concepts.

In this 2-day course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on 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.

Report Builder 3.0 is available for Microsoft® SQL Server® versions 2014, 2012, and 2008 R2.

  • Navigate the Report Builder Environment.
  • Create table reports.
  • Format reports.
  • Create basic and complex expressions.
  • Group report data.
  • Create matrix reports.
  • Sort and filter data.
  • Summarize data with charts.
  • Print and export reports.

Module 1: Exploring the Report Builder Environment

This module introduces the Report Builder application and its features. You will explore the Ribbon and its Tabs, Command groups, and Commands, the available Window panes for creating and manipulating reports, and the report design surface using Design and Run modes.

Lessons

  • Introducing the Report Builder Environment
  • Working with Existing Reports

Lab 1: Exploring the Report Builder Application

  • Navigating the Ribbon and Window panes
  • View Existing Reports in Design and Run modes

After completing this module, students will be able to:

  • Describe and navigate the graphical elements of the Report Builder application.
  • Work with existing reports and navigate between Design and Run modes.

 

Module 2: Adding Data to Table Reports

This module introduces how to populate a report with data and display that data in a table data region on the report. We will begin with defining the data source and continue with query building through data sets to bring data into the report. Next, we will explore the elements of the tablix data region including rows, columns, cells, handles, and field choosers, you will use in displaying your data.

Lessons

  • Create Report Data Sources
  • Create Report Datasets
  • Work with the Tablix Data Region
  • Create a Table Report

Lab 1: Creating Table Reports

  • Create Queries Using the Report Builder Query Designer
  • Create a Table Report Using a Single Table
  • Create Table Relationships Using Query Designer
  • Create a Table Report Using Multiple Tables

After completing this module, students will be able to:

  • Create report data sources.
  • Create report datasets.
  • Work with the tablix data region.
  • Create a table report

 

Module 3: Formatting Data and Creating Expressions in Reports

This module introduces report formatting techniques which allow a report writer to control how and where data displays in the report. Additional data may also be required and this can be accomplished by adding data from a source or adding a calculated field to the dataset. Simple and complex epressions will also be introduced in this topic.

Lessons

  • Formatting Reports
  • Sorting and Filtering Report Data
  • Adding Data to a Dataset
  • Creating Simple Expressions
  • Creating Complex Expressions

Lab 1: Formatting Reports

  • 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

After completing this module, students will be able to:

  • 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.

 

Module 4: Grouping Report Data

This module introduces data groupings in reports using dataset fields and using expressions. This module also discusses group hierarchies and adding aggregates to summarize grouped data.

Lessons

  • Group Data in Reports
  • Group Data Using an Expression
  • Creating Subgroups and Group Aggregates

Lab 1: 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

After completing this module, students will be able to:

  • Group data in reports using fields.
  • Group data in reports using expressions.
  • Create group hierarchies.
  • Aggregate grouped data in a report.

 

Module 5: Matrix Reports

This module introduces matrix data regions which are used in reports to control how crosstabular data can be used. While table reports rely on rows and columns, matrix reports rely on row groupings, column groupings, and aggregated values.

Lessons

  • Creating and Modifying Matrix Data Regions
  • Creating and Modifying Column Groups

Lab 1: Creating Matrix Reports

  • Create Matrix Reports
  • Create Column Groups
  • Use Expressions to Sort Group Data
  • Use Expressions to Display Group Names
  • Create Matrix Reports with Group Hierarchies

After completing this module, students will be able to:

  • 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.

 

Module 6: Charts

This module introduces the ability to create and add charts to reports. Whether through wizard or individual effort, chart reports or charts as report components allow us to visualize data with or without the details.

Lessons

  • Create and Modify Chart Wizard Reports
  • Add Charts to Existing Reports
  • Modify Charts in Reports

Lab 1: Creating Charts and Chart Reports

  • Create a Chart Wizard Report
  • Add a Chart to an Existing Report
  • Format Chart Elements
  • Use Expressions in Charts

After completing this module, students will be able to:

  • 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.

 

Module 7: Printing and Exporting Reports

This module introduces report printing and exporting. Reports can be created for electronic display, paper display, or display in another application. This module covers the basics of those three scenarios.

Lessons

  • Print Features and Print Options
  • Export Reports

Lab 1: Printing and Exporting Reports

  • Exploring Page Layout view, Report Formatting, and Page Setup Options
  • Exporting Reports

After completing this module, students will be able to:

  • Describe the key features of electronic reporting vs. print reporting.
  • Prepare a report for paper printing.
  • Export reports in supported formats.

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.

The secondary audience for this course are persons who are using Report Designer (SSRS).

Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft® SQL Server® Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience.

  • Familiarity with Windows.
  • Creating and navigating folders.
  • Opening programs.
  • Manipulating windows.
  • Copying and pasting objects.
  • Formatting text.
  • Saving files.
  • Microsoft® Office Access 2013: Level 1 or have equivalent experience with basic database concepts.
    Upcoming Dates
  • ` Feb 13 - Feb 14, 2023
  • ` Mar 13 - Mar 14, 2023
  • ` Apr 10 - Apr 11, 2023
  • ` May 8 - May 9, 2023
  • ` Jun 5 - Jun 6, 2023
  • ` Jul 3 - Jul 4, 2023