Microsoft SQL Server Reporting Services (SSRS)

Microsoft SQL Server Reporting Services (SSRS)

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 6h 14m | 1.92 GB

Build reports in MS SQL Server Reporting Services (SSRS): Implement report layouts, add interactivity.

This course is all about creating reports in SQL Server Reporting Services (SSRS). No prior knowledge is needed, but some knowledge of T-SQL would be useful.

We will download a version of SQL Server which includes SSRS – for free. We’ll also download a database called AdventureWorks, which we will use in our reports.

We’ll create various reports, developing our skills bit by bit. As part of designing a report, we will:

  • Select report components (matrix, table, chart and other data visualisation component),
  • Identify the data source and parameters,
  • Design a grouping structure,
  • Create drilldown reports and drillthrough reports.

As part of implementing a report layout, we will:

  • Find out how to format, including formatting colours, dates and numbers;
  • Configure the page;
  • Implement headers and footers;
  • Implement matrices, tables, chart, images, indicators, maps and groupings in reports;
  • Create a range of reports using different data regions;
  • Define custom fields;
  • Implement global collections;
  • Define expressions; and
  • Implement data visualisation components.

As part of implementing interactivity in a report, we will:

  • Create drilldown reports;
  • Create drillthrough reports;
  • Add interactive sorting;
  • Investigate parameters, including multi-value parameters;
  • Create dynamic reports in SSRS using parameters;
  • Implement show/hide property;
  • Add actions (jump to report and URL);
  • Add Fixed headers and a document map.

By the end of this course, you should be confident in creating your own reports in SSRS.

What you’ll learn

  • Create reports in SQL Server Reporting Services (SSRS).
  • We will develop your skills, bit by bit.
  • You can also download a free version of SQL Server which will allow you to practice creating reports on your own.
  • We will design a report, implementing report layouts and add interactivity into your reports.
Table of Contents

Introduction, and download SSRS
1 Introduction
2 Welcome to Udemy
3 Introduction to Udemy
4 Do you want auto-translated subtitles in more languages
5 Should I install Visual Studio If so, what version
6 Objectives
7 Do you need to install SSRS

Preparing to create reports
8 Opening SSRS
9 Where is AdventureWorks
10 Downloading and Installing AdventureWorks
11 Exploring data source
12 Creating shared dataset

Creating our first report
13 Problems with Report Wizard
14 Creating a report using Report Wizard
15 Troubleshooting your display
16 Practice Activity Number 1
17 Practice Activity Number 1 – The Solution
18 Problems adding an item
19 Recreating our report, not using the Report Wizard
20 Properties pane
21 Practice Activity Number 2
22 Practice Activity Number 2 – The Solution
23 Standard Number Formatting
24 Custom Number Formatting
25 Date Formatting
26 Sort and Group
27 Visibility and Table Headers
28 Practice Activity Number 3
29 Practice Activity Number 3 – The Solution

More advanced techniques
30 Creating a Categorised report
31 Creating hyperlinks
32 Adding a parameter
33 Practice Activity Number 4
34 Practice Activity Number 4 – The Solution
35 Adding a subreport
36 Page Headers and Footers
37 Adding drop-down list to parameters
38 Allow multiple values to select in parameters
39 Practice Activity Number 5
40 Practice Activity Number 5 – Solution
41 Bonus Allowing NULLs in parameters
42 Conditional Formatting
43 Indicators
44 Gauges
45 Adding totals
46 Interactive Sorting and Document Map
47 Practice Activity Number 6
48 Practice Activity Number 6 – Solution

Graphical reports
49 Creating a pie chart
50 Expanding the pie chart
51 Creating a bar chart
52 Expanding the chart
53 Enter the Matrix
54 Mapping data

Object Properties
55 Creating a new Employee Report
56 Alignment Properties
57 Border and Fill Properties
58 Other Text Box Properties
59 Group and Tablix Properties
60 Chart Properties

61 Program Flow Functions (IIF, CHOOSE, SWITCH)
62 Aggregate functions
63 Math functions
64 Text functions
65 Date and time functions
66 Other functions

67 Recap

Bonus – Installing SQL Server 2017 Developer Edition
68 Downloading SQL Server Developer E9
69 Installing SQL Server Developer E9
70 Installing SQL Server Management Studio (SSMS)
71 Installing Visual Studio E9
72 Installing SSRS in Visual Studio E9
73 Is your Visual Studio a trial version No
74 The next step
75 Different Types of SSRS, including Report Builder’s integration with SharePoint
76 Installing SSRS in Visual Studio E7
77 Installing Visual Studio and SSDT (SQL Server Data Tools)
78 Is your VIsual Studio a trial version No

Bonus Lecture
79 Bonus Lecture