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.
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.
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!
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.
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.
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!
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.
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.
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.
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 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 21 May 2013
Parameters allow your users to filter reports by typing in values or selecting from drop down lists. But what if they want to leave a parameter blank and still see results in the report? This video teaches you how to handle Null values in parameters to make this possible. You'll learn how to allow a null value in a parameter and how to write a WHERE clause to handle the null properly. We'll also look at how you can create drop down list parameters which allow null values, including how to append a null value to a dataset, how to mask the null value with descriptive text and how to sort the drop down list to make sure the null appears at the top.
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 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 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 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 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 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 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 26 July 2024
Use a menu option to quickly reset the layout of the windows in Visual Studio.
