Microsoft Data & Power BI
55128 Writing Reports with Report Builder and SSRS Level 2
Build richer reports with Report Builder and SQL Server Reporting Services.
2 daysIntermediate6 modules
About this course
Build richer reports with Report Builder and SQL Server Reporting Services. Over two days you will create parameter reports and list data regions, write complex expressions, add images and subreports, build drilldown and drillthrough reports, and add sparklines, data bars and indicators.
Curriculum
6 modules
- Parameterized Reporting
- Create Report Parameters
- Modify Report Parameters
- Provide Default Parameter Values
- Provide Available Values for Parameters
- Lab: Creating Parameterized Reports
- Introducing the List Data Region
- Create Reports Using List Data Regions
- Modify Reports Which Use List Data Regions
- Lab: Creating List Reports
- Formatting Reports
- Top N Reports
- Running Values
- Lab: Enhancing Reports with Complex Expressions
- Add Images to Reports
- Retrieve Images from a Database
- Introducing SSRS (SQL Server Reporting Services) Report Server
- Add Subreports to Reports
- Lab: Working With Images and Subreports
- Add and Configure Drilldown Reporting
- Add and Configure Drillthrough Reporting
- Lab: Add Drilldown and Drillthrough Functionality to Reports
- Sparklines
- Data Bars
- Indicators
- Lab: Adding Sparklines, Data Bars, and Indicators to Reports
Who it's for
Report writers who know the basics of Report Builder.
Before you start
- 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; Course 55123: Writing Reports with Report Builder and SSRS Level 1
Related courses
More in Microsoft Data & Power BI →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →Foundation
55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →Intermediate55353
Administering a SQL Database Infrastructure (55353)
Microsoft Data & Power BI
View course →IntermediateDP-300 Exam Prep/DP-300T00
Administering Microsoft Azure SQL Solutions (DP-300 Exam Prep/DP-300T00)
Microsoft Data & Power BI
View course →Foundation
Data Analysis using Power BI Desktop - Level 1: Report Builder
Microsoft Data & Power BI
View course →IntermediateDP-203/DP-203T00
Data Engineering on Microsoft Azure (DP-203/DP-203T00)
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.