Training videos for learning REPORT BUILDER 2016

Report Builder 2016 - 18 videos

Report Builder 2016 Pt 1 - Installing Report Builder 2016

Posted by Andrew Gould on 07 February 2017

This video takes you through the basics of installing Report Builder 2016, including a short introduction to what Report Builder is designed to do!

Report Builder 2016 Pt 2 - Creating Your First Report

Posted by Andrew Gould on 20 February 2017

This video shows you the basics of creating a report in Report Builder. You'll start with a blank report and learn how to create a data source to connect to a database, followed by a dataset to retrieve the results of a query. Next, you'll learn how to add a table to display the results, including how to assign dataset fields to table columns, how to sort and filter the table, along with how to use a variety of formatting options. The final part of the video explains how to save, close and reopen report files.

Report Builder 2016 Pt 3 - Saving to a Report Server

Posted by Andrew Gould on 20 February 2017

To allow others to view your Report Builder reports, you'll need to deploy them to a report server - this video explains how to do precisely that. You'll learn where to find your report server URL, how to connect Report Builder to a report server, how to deploy a report and how to view it in a web browser using the Reporting Services Web Portal application. You'll also learn a little about managing deployed reports, including how to download the report definition file, how to make changes to reports and re-upload them, and how to organise them on the report server using folders.

Report Builder 2016 Pt 4.1 - Embedded Data Sources and Datasets

Posted by Andrew Gould on 08 May 2017

You can't do much in Report Builder without some data to work with. This video explains how to get data from a SQL Server database using embedded data sources and datasets. You'll learn how to use the Query Designer to build a query, including how to choose which columns are included and apply filters to the rows. You'll also see how the Query Designer automatically detects relationships between database tables and what to do if this doesn't work!

Report Builder 2016 Pt 4.2 - Shared Data Sources and Datasets

Posted by Andrew Gould on 07 May 2019

Creating shared data sources and shared datasets means that you don't have to create new ones every time you begin a new report. Clearly, this can be a huge time-saver! This video explains how to create and use shared data sources and datasets for Report Builder.

Report Builder 2016 Pt 5.1 - Basic Tables

Posted by Andrew Gould on 07 May 2019

Tables are one of the simplest and perhaps most common items you'll add to a report in Report Builder. This video covers a variety of basic techniques for working with tables, including assigning fields and datasets, selecting cells, applying formatting and controlling column widths and row heights.

Report Builder 2016 Pt 5.2 - Sorting and Interactive Sorting in Tables

Posted by Andrew Gould on 07 May 2019

This video teaches you a variety of techniques to apply sorting to a Report Builder table. You'll learn how to write a simple ORDER BY clause in an SQL query, how to apply a sort to a table column and perhaps most usefully, how to create interactive sorting to allow your end users to control the order of the rows in a table.

Report Builder 2016 Pt 5.3 - Table Headers, Footers and Totals

Posted by Andrew Gould on 20 May 2019

This video teaches you how to add headers and footers to a table in Report Builder. You'll learn how to create aggregate values using functions such as SUM and AVERAGE and how to format decimal places and large numbers to make them readable!

Report Builder 2016 Pt 5.4 - Repeating and Scrolling Table Headers

Posted by Andrew Gould on 20 May 2019

This Report Builder video teaches you how to create table headers which appear on each page in a report and which follow you as you scroll down a page.

Report Builder 2016 Pt 5.5 - Filtering Tables and Datasets

Posted by Andrew Gould on 20 May 2019

This Report Builder video explains how to apply filters to tables and datasets in a report. You'll learn how to apply basic number filters, text filters using wildcard characters and filters using dates.

Report Builder 2016 Pt 5.6 - Creating Or Filters in Datasets and Tables

Posted by Andrew Gould on 20 May 2019

This Report Builder video explains how to combine filters using the Or operator in a dataset query and in a report table.

Report Builder 2016 Pt 6.1 - Grouping Rows in the Query Designer

Posted by Andrew Gould on 20 May 2019

This video teaches you how to create groups and aggregates in the Query Builder tool in Report Builder so that you can display them in a table in the report. You'll learn how to write aggregate functions in SQL and how to use the CAST function to control the data type of a value.

Report Builder 2016 Pt 6.2 - Grouping and Aggregating in a Table

Posted by Andrew Gould on 20 May 2019

This video explains how to group the rows in a Report Builder table so that you can apply aggregate functions to fields in the table. You'll learn how to create a group expression, how to choose an aggregate function for a field and how to apply sorting and interactive sorting to groups and aggregated values.

Report Builder 2016 Pt 6.3 - Creating Nested Parent and Child Groups

Posted by Andrew Gould on 20 May 2019

This Report Builder video teaches you how to create nested parent and child groups in a table. You'll learn about applying groups, how to include a group header and footer, how to use aggregate functions to create totals and subtotals, how to insert page breaks between groups and how to create multiple levels of nesting.

Report Builder 2016 Pt 6.4 - Table Groups with Detail Rows

Posted by Andrew Gould on 20 May 2019

In this video you'll learn how to create a grouped table with detail rows in Report Builder. You'll learn how to use a details-first or group-first approach, how to create group headers and footers and apply aggregate functions and see a few suggestions for altering the layout and format of a grouped table.

Report Builder 2016 Pt 6.5 - Page Breaks and Headers in Table Groups

Posted by Andrew Gould on 20 May 2019

In this Report Builder video you'll learn how to create headers and footers for grouped tables in a report. You'll see how to make the headers repeat on each page of the report, as well as how to insert page breaks between each group in the table. Finally, you'll learn how to export the results of the report to Excel, including how to create automatic worksheet names in the workbook.

Report Builder 2016 Pt 6.6 - Collapsible and Expandable Table Groups

Posted by Andrew Gould on 20 May 2019

This Report Builder video teaches you how to create table groups which your users can expand and collapse using basic interactive controls. You'll learn how to alter the visibility of rows and tablix items and how to assign a toggle item so that your users can show and hide the grouped data. You'll also see how to create nested interactive groups and discover how to export the same interactivity to an Excel workbook.

Report Builder 2016 Pt 6.7 - Recursive Table Groups

Posted by Andrew Gould on 03 June 2019

In this video you'll learn how to create recursive groups in a Report Builder table. You'll see how to structure your data to allow recursive grouping, followed by how to assign a recursive parent field to a group in a table. You'll learn several functions you can use to apply formatting to different levels of the hierarchy and how to create collapsible and expandable groups so that you can drill down into the group details.

This page has 0 threads Add post