Microsoft training videos created in 2012 by Wise Owl (page 1 of 3)

Showing videos 1-20 (out of 45)

SSRS Part 22 - Document Maps

Posted by Andrew Gould on 12 December 2012

Adding a Document Map to your Reporting Services reports provides a neat and easy way to navigate around large and complex reports. This video teaches you how to add Document Maps to reports, including how to create Document Maps for grouped tables, how to add Document Map Labels for individual items, and what happens when you export a report containing a Document Map.

SQL Programming Part 6 - WHILE Loops

Posted by Andrew Gould on 05 December 2012

In SQL Server there is only one type of loop: a WHILE loop. This video teaches you how to use them, from the basic syntax of the WHILE statement, through how to use a SELECT statement within a loop. We'll also cover how to use the BREAK command to exit from a loop, what to do when you inevitably find yourself in an endless loop and, finally, a quick introduction to using loops with cursors.

SSRS Part 21 - 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.

SQL Programming Part 5 - IF Statements in SQL

Posted by Andrew Gould on 03 December 2012

IF statements in SQL allow you to check if a condition has been met and, if so, to perform a sequence of actions. This video teaches you everything from the basic syntax of IF statements, including how to use the ELSE clause and perform multiple actions using a BEGIN and END block. We'll also teach you how to nest your IF statements, including a few useful tips on how to make your nested IFs readable!

SQL Programming Part 4 - Output Parameters and Return Values

Posted by Andrew Gould on 28 November 2012

Output parameters and return values are two methods in SQL for getting information out of a stored procedure. This video teaches you how to use both methods, including how to define output parameters and set their values within a procedure, how to add a return statement to a stored procedure, and how to capture the output of a procedure when you execute it.

SQL Programming Part 3 - Variables in SQL

Posted by Andrew Gould on 21 November 2012

Using variables allows you to give your SQL procedures a memory. You can store a value in a variable and then retrieve and reuse that value at any point later in the same procedure. This video teaches you how to declare variables, assign values to them and make use of those values in a query. You'll also see how to store the result of a SELECT statement in a variable, as well as how to accumulate the value of a variable. You'll see a couple of methods of displaying the value stored in a variable and we'll end with a quick overview of the global variables in SQL Server.

SQL Programming Part 2 - Stored Procedure Parameters

Posted by Andrew Gould on 20 November 2012

Stored Procedures are extremely useful tools in SQL Server, and they become even more powerful when you use parameters to pass information to them. This video teaches you how to define a list of parameters for a stored procedure and how to call a parameterised procedure and pass information to it. You'll also learn how to create optional parameters with default values, how to handle NULLs passed to a procedure and, finally, how to use your procedure in other applications such as Reporting Services.

SQL Programming Part 1 - Stored Procedure Basics

Posted by Andrew Gould on 19 November 2012

If you ever find yourself writing the same SQL query over and over again, a Stored Procedure could be just the time-saving tool you're looking for. This video introduces you to the concept of stored procedures and will show you how to create, execute and modify these useful elements of SQL Server.

SQL Queries Part 12 - Correlated Subqueries

Posted by Andrew Gould on 31 October 2012

A correlated subquery is a subquery which depends on an outer query for its values. If that doesn't make much sense, this video attempts to explain exactly what that means. You'll see how to build simple correlated subqueries, including why it's necessary to use table aliases, along with an explanation of what happens when you execute the query.

SSRS Part 20 - 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!

SSRS Part 19 - 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.

SSRS Part 18 - 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.

SSRS Part 17 - 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.

SSRS Part 16 - 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.

SSRS Part 15 - 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.

SSRS Part 12 - 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.

SSRS Part 14 - 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.

SSRS Part 10 - 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.

SSRS Part 11 - 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.

SSRS Part 8 - 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.

This page has 0 threads Add post