Wise Owl - Reporting Services training videos (page 1 of 2)

Showing videos 1-20 (out of 26)

Controlling the number of rows on a page

Posted by Andrew Gould on 11 May 2012

Learn how to use control the number of records displayed on each page in a Reporting Services report. This video teaches you how to use grouping and expressions in Microsoft SQL Server Reporting Services to specify an exact number of rows per page.

Keeping column headings visible on each page

Posted by Andrew Gould on 14 May 2012

Learn how to make table headers appear on each page in a Reporting Services report. This video teaches you how to use the Properties window in Microsoft SQL Server Reporting Services to make sure that table headers remain visible on each page of a report, and even when you scroll down the page.

Getting started with a new report project

Posted by Andrew Gould on 24 July 2012

Learn how to get started with Microsoft SQL Server Reporting Services. This video teaches you how to create your first Reporting Services project using either Business Intelligence Development Studio with SQL 2008 R2, or SQL Server Data Tools with SQL Server 2012. You'll see how to work in the Visual Studio environment, how to create simple reports and how to insert and work with basic report items such as text boxes.

Data Sources and Datasets

Posted by Andrew Gould on 24 July 2012

Learn how to create data sources and datasets in Microsoft SQL Server Reporting Services. This video teaches you how to link your Report Server project to a database by creating a data source and how to create datasets to extract specific information from the database. We'll teach you the difference between shared and embedded data sources and datasets and show you how to use the Query Designer tool to make your life simple when it comes to building queries.

Working with tables

Posted by Andrew Gould on 24 July 2012

You won't get far in Reporting Services without learn how to use tables properly - this video teaches you how to create tables and link them to a dataset. You'll see how to insert tables into a report and how to manipulate and format the table. After the basics we'll show you some of the more advanced features of tables such as filtering and interactive sorting. We'll even show you how to solve one of the most annoying features of tables: making sure the column headers appear on each page of your report!

Grouping in tables

Posted by Andrew Gould on 09 August 2012

Adding grouping to a table in Reporting Services allows you to display data in much more interesting ways than in just a boring old table! This video teaches you how to add parent groups to tables, how to apply subtotals to numerical fields and, as a final flourish, how to create collapsible groups that your users can display or hide as they choose!

Creating calculated fields

Posted by Andrew Gould on 10 August 2012

This video teaches you how to add calculated fields to a dataset in Reporting Services. You'll learn how to work in the Expression Builder dialog box, how to create simple arithmetic expressions, and how to use a variety of functions to perform more elaborate calculations.

Conditional formatting

Posted by Andrew Gould on 20 August 2012

Ever wanted to apply conditional formatting to a table in Reporting Services? This video teaches you how! You'll learn how to use the IIF function to calculate a format for rows in a table, how to use the SWITCH function to test multiple conditions, and how to create alternating row colours.

Indicators

Posted by Andrew Gould on 20 August 2012

Bored of looking a list of numbers in Reporting Services reports? This video teaches you how to visualise a range of numbers using graphical indicators. You'll learn how to add indicators to a table, how to link indicators to fields in a dataset and how to control exactly which values your indicators represent.

Gauges

Posted by Andrew Gould on 22 August 2012

Gauges represent the single most over-the-top method of graphically representing a set of numbers! This video teaches you all about radial and linear gauges, including how to work with scales, ranges, pointers and labels, how to apply conditional formatting to a gauge, and, trickiest of all, how to position items in a gauge.

Basic parameters

Posted by Andrew Gould on 22 August 2012

Adding parameters to a report is a great way to give your users the ability to filter and format a report. This video teaches you how to add basic parameters to a report and how to use those parameters to apply filters to tables and add conditional formatting to rows of data.

Drop down list parameters

Posted by Andrew Gould on 13 September 2012

Drop down list parameters provide a convenient way for your users to filter and format a report. This video teaches you how to create drop down lists first by typing in a list of entries and then by creating a dataset to populate the list.

Cascading parameters

Posted by Andrew Gould on 13 September 2012

In a previous video we've shown you how to create a single drop down list parameter to filter a report. In this video we'll show you how to create a sequence of cascading parameters to drill down into the detail of your data.

Matrices

Posted by Andrew Gould on 17 September 2012

A matrix in Reporting Services allows you to create basic crosstab or pivot table style reports that you might be familiar with from Excel. This video teaches you how to use a matrix in a report, including how to select fields, how to add row and column totals, how to add multiple grouping levels and how to create multiple aggregates in the same matrix.

Lists

Posted by Andrew Gould on 05 October 2012

A List in Reporting Services allows you to create a much more flexible layout for your data than a simple table. This video teaches you how to create basic lists, shows you how to use rectangles to arrange items neatly, and how to create grouped lists so that you can include graphical items such as charts in a list.

Linked reports

Posted by Andrew Gould on 08 October 2012

Creating linked reports in Reporting Services allows your user to navigate between reports by clicking items on the page. This video teaches you how to add actions to report items such as tables, charts and maps, as well as how to use parameters to pass information to reports and apply filters to the results.

Charts

Posted by Andrew Gould on 09 October 2012

If you've worked with charts in Microsoft Excel you might be thinking that you know what to expect from Reporting Services charts. What you won't be prepared for, however, are the little differences that can easily trip you up! This video teaches you how to get started with charts in Reporting Services, including how to assign fields to the correct parts of a chart, how to format charts effectively, and even how to apply conditional formatting to a chart to pick out important values.

Subreports

Posted by Andrew Gould on 10 October 2012

A Subreport is simply an entire report nested within another one. It's a simple idea that allows you to separate the different sections of complex reports to make designing and formatting them easier. This video teaches you how to construct separate main reports and subreports, how to add parameters and filters to a subreport to ensure they display the correct data, and, of course, how to insert a subreport into a main report and connect the two reports together.

Basic Maps

Posted by Andrew Gould on 29 October 2012

Maps in reporting services, as in real life, are the perfect way to present geographical data. This video starts by teaching you how to insert a map into a report, including how to find maps for the strange and unfamiliar world beyond the USA. Importantly, you'll learn how to connect a map to a dataset followed by how to visualise the data using a combination of colours and markers. You'll also learn a few geeky geographical tweaks you can make to your maps, including how to add longitude and latitude lines and how to change the projection type. Ever wondered what the difference is between Mercator and Hammer-Aitoff projections? Watch this video to find out!

Pivot Table / Dynamic Matrix

Posted by Andrew Gould on 04 December 2012

In Reporting Services a normal matrix is quite boring and static. In this video we'll teach you to create a much more exciting dynamic matrix, which behaves a lot like a pivot table in Excel.