VIDEOS BY CATEGORY
VIDEOS BY AUTHOR
VIDEOS BY YEAR
Microsoft training videos created in 2012 by Wise Owl (page 1 of 3)
Showing videos 1-20 (out of 45)
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.
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.
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.
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!
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.
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.
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.
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.
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.
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!
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.