Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
IT & Software Other IT & Software SSRS Reporting

Microsoft SQL Server Reporting Services (SSRS)

Build reports in SQL Server Reporting Services (SSRS): Implement report layouts, add interactivity. Exam 70-466
Bestseller
Rating: 4.4 out of 54.4 (1,948 ratings)
11,376 students
Created by Phillip Burton
Last updated 2/2021
English
English [Auto], Italian [Auto]
30-Day Money-Back Guarantee

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.
Curated for the Udemy for Business collection

Requirements

  • You don't need any prior knowledge prior to taking this course.
  • A couple of the bonus lectures will require some knowledge of T-SQL, but these lectures are optional.
  • You don't need any form of SQL Server to already be installed on your computer; I will show you have to download it and install it - for free.
  • It is not necessary to have SharePoint on your computer.
  • If you want to know enough T-SQL to assist you with your SSRS work, please have a look at the first two sessions of my 70-461 courses.

Description

Reviews:

"Brilliant! This tutorial will definitely save you hours of figuring out things yourself." -- Koos ten Bras

"Excellent course, well presented and clear examples." - Peter Cawthorne

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.

It will assist with the "Build a report with SQL Server Reporting Services (SSRS)" section of Microsoft exam 70-766 "Implementing Data Models and Reports with Microsoft SQL Server".

Who this course is for:

  • This course is for you if you want to know how to create reports in SSRS.
  • No prior experience with T-SQL is required, although the more knowledge you have it, the better.
  • Having SharePoint on your computer is not necessary; we will use the stand-alone version of SQL Server. However, I will show the differences and similarities between Report Builder (SharePoint) and SSDT (the stand-alone version).
  • In this course we will cover several aspects which are tested in Microsoft's 70-466 exam "Implementing Data Models and Reports with Microsoft SQL Server".
  • This course is not for you if you only want to know about managing your existing SSRS reports in SharePoint.

Featured review

Mukesh Lekhrajani
Mukesh Lekhrajani
13 courses
3 reviews
Rating: 5.0 out of 59 months ago
Good. But all is happening on SQL 2012 And Visual Studio 2012/15.. While I have SQL Server & Visual Studio Both == 2019.. -- Its all a bit different there. Can we upgrade the course content to meet latest technologies.

Course content

9 sections • 76 lectures • 6h 6m total length

  • Preview02:18
  • Welcome to Udemy
    00:35
  • Introduction to Udemy
    02:00
  • Should I install Visual Studio? If so, what version?
    01:25
  • Preview03:08
  • Do you need to install SSRS?
    00:28

  • Opening SSRS
    04:03
  • Where is AdventureWorks?
    00:11
  • Downloading and Installing AdventureWorks
    08:47
  • Exploring data source
    02:09
  • Creating shared dataset
    12:28

  • Problems with Report Wizard?
    00:13
  • Creating a report using Report Wizard
    08:03
  • Troubleshooting your display
    01:05
  • Practice Activity Number 1
    00:24
  • Practice Activity Number 1 - The Solution
    04:14
  • Problems adding an item?
    00:19
  • Recreating our report, not using the Report Wizard
    06:04
  • Properties pane
    Preview08:40
  • Practice Activity Number 2
    00:32
  • Practice Activity Number 2 - The Solution
    05:35
  • Standard Number Formatting
    08:53
  • Custom Number Formatting
    04:44
  • Date Formatting
    10:02
  • Sort and Group
    04:24
  • Visibility and Table Headers
    05:47
  • Practice Activity Number 3
    00:22
  • Practice Activity Number 3 - The Solution
    05:49

  • Creating a Categorised report
    04:16
  • Creating hyperlinks
    02:10
  • Adding a parameter
    12:17
  • Practice Activity Number 4
    00:42
  • Practice Activity Number 4 - The Solution
    07:52
  • Adding a subreport
    02:49
  • Page Headers and Footers
    05:15
  • Preview02:30
  • Allow multiple values to select in parameters
    02:23
  • Practice Activity Number 5
    00:23
  • Practice Activity Number 5 - Solution
    05:34
  • Bonus: Allowing NULLs in parameters
    04:07
  • Conditional Formatting
    05:54
  • Indicators
    08:04
  • Gauges
    06:54
  • Adding totals
    05:41
  • Interactive Sorting and Document Map
    Preview05:39
  • Practice Activity Number 6
    00:13
  • Practice Activity Number 6 - Solution
    03:59

  • Creating a pie chart
    04:25
  • Expanding the pie chart
    06:42
  • Creating a bar chart
    11:33
  • Expanding the chart
    02:55
  • Preview02:34
  • Mapping data
    07:03

  • Creating a new Employee Report
    04:32
  • Alignment Properties
    06:07
  • Border and Fill Properties
    06:11
  • Other Text Box Properties
    10:11
  • Group and Tablix Properties
    08:36
  • Chart Properties
    05:36

  • Program Flow Functions (IIF, CHOOSE, SWITCH)
    08:45
  • Aggregate functions
    09:53
  • Math functions
    05:28
  • Text functions
    08:26

  • Bonus Lecture
    02:55
  • Recap
    01:36

  • Downloading SQL Server back engine - the Developer edition - for free!
    06:09
  • Installing SQL Server back engine
    09:45
  • Installing SQL Server Front Engine
    05:16
  • Installing Visual Studio 2019
    04:52
  • Installing SSRS in Visual Studio 2019
    03:00
  • Is your Visual Studio a trial version? No!
    01:36
  • The next step
    00:06
  • Different Types of SSRS, including Report Builder's integration with SharePoint.
    Preview11:16
  • Installing SSRS in Visual Studio 2017
    03:12
  • Installing Visual Studio and SSDT (SQL Server Data Tools)
    06:59
  • Is your VIsual Studio a trial version? No!
    01:25

Instructor

Phillip Burton
Best Selling Instructor - over 250,000 students so far
Phillip Burton
  • 4.5 Instructor Rating
  • 42,163 Reviews
  • 295,338 Students
  • 46 Courses

Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.

He enjoys investigating data, which allows him to maintain up to date and pro-active systems to help control and monitor day-to-day activities. He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.

He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.

His interests are working with data, including Microsoft Excel, Access and SQL Server.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.