Wise Owl's Channel

Wise Owl's Channel

UPLOADED VIDEOS

  • 1
    Reporting Services - Subreports 07:11

    Reporting Services - Subreports

    by Wise Owl (10/10/12) 49 views

    http://www.wiseowl.co.uk - 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. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

  • 2
    Reporting Services - Charts 21:56

    Reporting Services - Charts

    by Wise Owl (10/9/12) 27 views

    http://www.wiseowl.co.uk - 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. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

  • 3
    Reporting Services - Linked Reports 14:34

    Reporting Services - Linked Reports

    by Wise Owl (10/8/12) 18 views

    http://www.wiseowl.co.uk - 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. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

  • 4
    Reporting Services - Lists 20:03

    Reporting Services - Lists

    by Wise Owl (10/8/12) 3 views

    http://www.wiseowl.co.uk - 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. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

  • 5
    Reporting Services - Matrix 14:02

    Reporting Services - Matrix

    by Wise Owl (9/17/12) 36 views

    http://www.wiseowl.co.uk - 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. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

  • 6
    Reporting Services - Cascading Parameters 11:33

    Reporting Services - Cascading Parameters

    by Wise Owl (9/13/12) 15 views

    http://www.wiseowl.co.uk - 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. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

  • 7
    Reporting Services - Drop Down List Parameters 17:35

    Reporting Services - Drop Down List Parameters

    by Wise Owl (9/13/12) 11 views

    http://www.wiseowl.co.uk - 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. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

  • 8
    Reporting Services - Basic Parameters 23:12

    Reporting Services - Basic Parameters

    by Wise Owl (9/13/12) 8 views

    http://www.wiseowl.co.uk - 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. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

  • 9
    SQL Server - Subqueries 08:51

    SQL Server - Subqueries

    by Wise Owl (9/13/12) 7 views

    http://www.wiseowl.co.uk - The idea of a subquery is pretty simple: it's just one query nested inside another. If that doesn't sound particularly useful then you should watch this video to find out why it is! You'll learn how to place a subquery in a SELECT list or a WHERE clause, how to add criteria to a subquery, and how to handle subqueries which return multiple values. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

  • 10
    Reporting Services - Gauges 27:01

    Reporting Services - Gauges

    by Wise Owl (9/13/12) 19 views

    http://www.wiseowl.co.uk - 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. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

  • Load More