Choose software▼
- .NET manuals
- Access manuals
- Business Intelligence manuals
- C# manuals
- Excel manuals
- Microsoft Office manuals
- Power Apps manuals
- Power Automate manuals
- Power BI manuals
- Programming manuals
- Python manuals
- Report Builder manuals
- SQL manuals
- SSAS manuals
- SSIS manuals
- SSRS manuals
- VBA manuals
- Visual Basic manuals
Report Builder courseware and training manuals
The course manual listed below is for Report Builder for SQL Server 2016 - we also have courseware for Report Builder 3.0 (available to license on demand):
You can see details of how to license our Report Builder courseware (including volume requirements) here.
Report Builder courseware
Here is a list of all of our Report Builder manual chapters (you can download the ones marked):
Chapter | Sections | Subsections |
---|---|---|
Getting Started (8 pages) | What is SQL Server Report Builder? | Related Software |
Installing Report Builder | Installing from the Microsoft Website ; Installing from the Reporting Services Web Portal | |
Running Report Builder | The Getting Started Dialog Box | |
The Report Builder Screen | Opening and Closing Windows ; The Main Windows | |
Using a Report Server | Connecting to a Report Server ; Setting a Default Report Server ; Finding the URL of the Report Server | |
Working with Reports (4 pages) | Creating Reports | Choosing to Create a New Report |
Opening and Closing Reports | Opening Existing Reports ; Closing a Report | |
Saving Reports | Saving a Report ; Saving a Report with a New Name | |
Running Reports | Design View and Report Preview | |
Basic Report Items (7 pages) | Report Items | Adding Items to a Report |
Selecting Report Items | Selecting Single Report Items ; Selecting Multiple Items | |
Manipulating Report Items | Moving Report Items ; Resizing Items ; Using the Properties Window ; Deleting Items ; Aligning Items | |
Images, Rectangles and Textboxes | Images ; Rectangles ; Textboxes | |
Formatting
(6 pages)
Download this chapter |
Three Ways to Format an Item | Ribbon ; The Properties Window ; The Properties Dialog Box |
Changing Colours | Choosing Basic Colours ; Custom Colours ; Colour Gradients and Patterns | |
Formatting Text | Formatting All or Part of a Textbox ; Basic Font Formatting Options ; Text Alignment | |
Formatting Borders | The Border Ribbon Group ; The Borders Dialog | |
Formatting Numbers and Dates | Using Built-In Formats ; Creating Custom Formats | |
Getting Data (6 pages) | Data Sources and Datasets | The Wise Owl Movies Database |
Data Sources | Shared and Embedded Data Sources ; Creating an Embedded Data Source ; Using a Shared Data Source | |
Datasets | Shared and Embedded Datasets ; Creating an Embedded Dataset ; Using a Shared Dataset | |
The Query Designer (7 pages) | Query Designer Basics | Selecting Fields ; Running a Query ; Editing a Query as Text |
Using Filters | Applying Basic Filters ; Removing Filters ; Text Filters and Wildcards ; Filtering Nulls | |
Grouping and Aggregating Data | Creating a Query with Grouping ; Changing Aggregate Column Names | |
Relationships | Using Automatic Detection ; Editing Relationships | |
Sorting Query Results | ||
The Reporting Services Web Portal (15 pages) | Overview of the Web Portal | |
Getting to the Web Portal | Finding the Web Portal URL ; Browsing to the Web Portal | |
Using the Web Portal | The Web Portal Menu ; Viewing Item Options ; Finding Items ; Using Favourites | |
Working with Reports | Viewing and Exporting Reports ; Moving and Deleting Reports ; Downloading Reports ; Editing Reports without Downloading ; Managing Reports | |
Shared Data Sources and Datasets | Viewing Shared Data Sources and Datasets | |
Managing Data Sources | Editing Data Sources ; Creating a New Data Source | |
Data Source Credentials | Viewing Credential Options ; Storing Credentials in a Data Source ; Prompting for Credentials | |
Managing Datasets | Creating a New Dataset ; Viewing a Dataset’s Data ; Editing a Dataset | |
Basic Tables (12 pages) | Creating Tables | Inserting a Table ; Tables and Datasets ; Using the Field Selector ; Dragging Fields into a Table |
Views of a Table | Tables in Design View ; Tables in Report View | |
Selecting in Tables | Selecting the Table ; Selecting Cells | |
Table Properties | The Tablix Properties Dialog Box ; The Text Box Properties Dialog Box | |
Rows and Columns | Selecting Rows and Columns ; Changing Column Widths ; Changing Row Heights ; Preventing Row Height Changes ; Inserting and Deleting Columns ; Inserting and Deleting Rows | |
Merging and Splitting Cells | Merging Cells ; Splitting Cells | |
Controlling Column Headers | How Not to Make Column Headers Repeat ; Repeating Column Headers on Each Page ; Making Column Headers Scroll | |
Sorting and Filtering (4 pages) | Sorting | Sorting in a Table ; Sorting in a Group ; Interactive Sorting |
Filtering | Filtering in the Dataset Properties Dialog Box ; Filtering a Table ; Filtering in a Group | |
Grouping in Tables (11 pages) | Grouping Basics | |
Grouping Rows in a Table | Step 1 – Build a Basic Table ; Step 2 – Apply Grouping to the Detail Row ; Step 3 – Choose Which Field to Group By ; The End Result | |
Removing Groups | Deleting Groups in the Grouping Pane ; Deleting Groups in a Table | |
Formatting a Grouped Table | Adding Group Headers and Footers ; Rearranging Group Titles ; Adding Group Totals | |
Multiple Groups | Adding a New Parent Group ; Adding a Child Group | |
Page Breaks | Inserting Page Breaks between Groups | |
Collapsible Groups | Step 1 - Hiding Detail Rows ; Step 2 - Setting Toggle Items | |
Expressions (17 pages) | Overview of Expressions | Choosing to Create an Expression ; The Expression Builder Dialog Box ; Referring to Dataset Fields ; Referring to Report Items ; Inserting Functions |
Ad-Hoc Table Columns | Creating an Ad-Hoc Column Expression | |
Calculated Fields | Adding a Calculated Field to a Dataset ; Using a Calculated Field ; Adding Calculated Fields to a Query | |
Working with Numbers | Basic Arithmetic ; Numeric Functions | |
Conditional Functions | The IIf Function ; The Switch Function ; Comparison Operators ; Logical Operators | |
Working with Text | Concatenating Text ; Text Functions | |
Working with Dates | Returning the Current Date ; Date Functions ; Intervals for Date Functions ; Formatting Dates | |
Aggregating Data | Aggregate Functions ; Adding Aggregates the Quick Way ; Changing the Aggregate Function ; Specifying the Scope | |
Lookup Functions | The Lookup Function ; The LookupSet Function | |
Built-In Fields | Built-In Fields in the Expression Builder ; Built-In Fields in the Report Data Window | |
Placeholders | Creating a Placeholder | |
Dynamic Formatting (5 pages) | Formatting with Expressions | Which Properties can be Calculated? |
Calculating Colours | Using Named Colours ; Using Custom Colours ; Converting RGB to Hexadecimal Values | |
Calculating Font Properties | Dynamic Font Sizes ; Decorating Text ; Other Font Properties | |
Dynamically Hiding Report Items | The Hidden Property ; Calculating the Visibility of Report Items | |
Printing and Exporting (7 pages) | Printing Reports | Print Layout View ; Choosing to Print a Report |
Page Setup | Page Setup Options in Preview ; Page Setup Options in Design View ; Controlling the Page Size | |
Headers and Footers | Adding and Removing Headers and Footers ; Adding Items to Headers and Footers ; Expressions for Headers and Footers ; Controlling Page Numbers in Groups | |
Exporting Reports | Choosing to Export a Report ; Creating Worksheet Names in Excel | |
Testing the Render Format | Displaying a Title Page in Excel Only ; A List of Render Formats | |
Parameters (17 pages) | Introduction to Parameters | Displaying the Parameters Pane |
Report Parameters | Creating a Report Parameter ; Using a Report Parameter in a Filter ; Parameter Data Types ; Dealing with No Rows ; Displaying Parameter Values in the Report | |
Query Parameters | Writing a Query using Parameters | |
Organising Parameters | Changing the Order of Parameters ; Using the Parameters Pane | |
Default Values | Typing in a Default Value ; Calculating Default Values ; Getting Default Values from a Dataset | |
Null Values | Allowing Null Values ; Dealing with Nulls in Filters | |
Drop Down Lists | Manually Entering Available Values ; Using a Dataset to Populate a List | |
Multi-Value Drop Down Lists | Allowing Multiple Values ; Using Multiple Values in Filters ; Using Multiple Values in Queries ; Displaying Multiple Values in a Report | |
Cascading Drop Down Lists | Creating Cascading Drop Down Lists ; Using Cascading Drop Down Lists | |
Conditional Formatting with Parameters | Parameters in Formatting Expressions | |
Indicators (6 pages) | Creating Indicators | Adding an Indicator to a Table ; Assigning a Field to an Indicator |
Editing Indicators | Changing the Indicator ; Changing the Indicator’s Field ; Changing the Aggregate Function | |
Formatting Indicators | Changing Indicator Colours and Icons ; Formatting the Background of an Indicator | |
Indicator Size and Position | Controlling the Size of an Indicator ; Preventing an Indicator from Stretching | |
Scaling and Measurement Units | Changing the Scope of Scaling ; Changing the Measurement Units ; Adding and Removing Bands | |
Gauges (12 pages) | What are Gauges? | Anatomy of a Gauge |
Creating Gauges | Inserting a Gauge into a Table ; Assigning a Field to a Gauge | |
Editing Gauges | Selecting Part of a Gauge ; Adding and Deleting Items in a Gauge | |
Editing a Scale | Changing the Limits of the Scale ; Formatting Tick Marks ; Changing the Scale’s Dimensions | |
Editing a Pointer | Changing the Pointer Type ; Setting the Pointer Size and Position ; Changing the Pointer Fill Colour | |
Editing a Range | Setting the Start and End Position ; Changing the Size and Position ; Changing the Fill Colour | |
Editing the Gauge | Choosing a Frame ; Formatting the Frame ; Setting the Size and Position | |
Editing a Label | Setting the Value Displayed ; Anchoring a Label | |
Multiple Items | Multiple Pointers ; Multiple Scales ; Multiple Gauges ; Creating Child Gauges | |
Charts (10 pages) | Creating Charts | Inserting a Chart into a Report ; Inserting a Chart into a Tablix Item ; Assigning Fields to a Chart ; Previewing a Chart |
Editing Charts | Parts of a Chart ; Changing Chart Properties ; Adding and Removing Elements in a Chart | |
Chart Colours | Choosing a Colour Palette ; Creating a Custom Palette ; Calculating Colours ; Synchronising Colours in a Table | |
Using Multiple Value Fields | Adding Multiple Value Fields to a Chart ; Multiple Value Axes ; Using Different Chart Types | |
Sparklines | Adding a Sparkline to a Report or Tablix Item ; Editing Sparklines | |
Databars | Adding a Data Bar to a Report or Tablix Item ; Editing Data Bars | |
Matrices (7 pages) | Overview of Matrices | Adding a Matrix to a Report ; Assigning Fields to a Matrix |
Editing a Matrix | Changing the Aggregate Function ; Replacing Empty Cells ; Displaying Row and Column Totals | |
Sorting a Matrix | Sorting by Row and Column Fields ; Sorting by Values | |
Matrix Headers and Titles | Inserting the Extra Row ; Controlling the Height of the Header Row | |
Repeating and Scrolling Headers | Making Row and Column Headers Repeat | |
Multiple Grouping Levels | Creating Multiple Grouping Levels | |
Lists (4 pages) | Introduction to Lists | What a List Really Is |
Creating a List | Inserting a List into a Report ; Adding Fields to a List ; Adding Labels to Fields | |
Grouped Lists | Adding a Group to a List | |
Subreports (6 pages) | An Overview of Subreports | |
Creating the Child Report | Step 1 - Create the Dataset ; Step 2 - Create a Parameter ; Step 3 - Filter the Dataset ; Step 4 - Design the Report | |
Creating the Parent Report | Step 1 - Create the Dataset ; Step 2 - Design the Report | |
Combining the Parent and Child Reports | Step 1 - Insert a Subreport into the Parent Report ; Step 2 – Assign a Report to the Subreport ; Step 3 - Pass a Value to the Child Report’s Parameter ; Running the Report | |
Drillthrough Reports
(6 pages)
Download this chapter |
Overview of Drillthrough Reports | The Example for this Chapter |
Creating the Child Report | Step 1 - Create the Dataset ; Step 2 - Hide the Parameter ; Step 3 - Design the Report | |
Creating the Parent Report | Step 1 - Create the Dataset ; Step 2 - Design the Report | |
Creating Report Actions | Step 1 - View the Action Properties ; Step 2 - Configure the Action to Open a Report | |
Using Drillthrough Reports | Running the Parent Report ; Returning to the Parent Report | |
Multiple Parameters | Creating Child Reports with Multiple Parameters ; Creating the Parent Report | |
Maps (8 pages) | Maps in SSRS | Map Data |
Creating a Map Report | Creating a Dataset ; Inserting a Map into a Report | |
The Map Wizard | Step 1 – Choosing a Map Source ; Step 2 – Cropping and Resizing the Map ; Step 3 – Choosing a Type of Visualisation ; Step 4 – Selecting a Dataset ; Step 5 – Linking the Dataset to the Map ; Step 6 – Choosing Which Field to Display | |
Editing Maps | Map Options and Properties ; Map Layers | |
Colour Rules | Controlling Colour Bands ; Types of Colour Rules | |
Schedules, Snapshots and Subscriptions (11 pages) | Alternative Ways to Run Reports | |
Schedules | Running the SQL Server Agent ; Managing Shared Schedules ; Configuring a Schedule | |
Caching Reports and Datasets | Enabling Caching ; Cache Expiration Settings ; Cache Refresh Plans ; Setting Parameter Values ; Running a Report from a Cache Snapshot | |
Report History Snapshots | Creating a History Snapshot Manually ; Creating Scheduled History Snapshots ; Retaining History Snapshots | |
Subscriptions | Types of Subscription ; Creating a Subscription ; Using a Windows File Share Destination ; Using an Email Destination ; Assigning Parameter Values ; Managing Subscriptions | |
KPIs and Mobile Reports (10 pages) | Other Types of Report | |
KPIs | An Example KPI ; Creating a KPI Dataset ; Creating a KPI ; Setting the Value Field ; Setting the Goal Field ; Setting the Status Field ; Setting the Trend Set Field ; Related Content | |
Mobile Reports | Choosing to Create a Mobile Report ; Adding and Editing Visualisations ; Formatting Visualisations ; Viewing a Visualisation’s Data ; Adding Data to a Mobile Report ; Changing Report Settings ; Saving a Mobile Report |
Notes:
- Since Wise Owl print courseware double-sided to save trees, the number of physical pages in each chapter is roughly half of the number of sides quoted.
- Downloads are provided as examples only, and should not be used or distributed in any way or form without the prior written permission of Wise Owl.
This page has 0 threads
Add post