Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Server Reporting Services Part 1 (SSRS)
Highest Rated
Rating: 4.6 out of 5(2,480 ratings)
10,966 students

What you'll learn

  • Install SQL Server 2016, Microsoft Visual Studio 2015, create from scratch simple to complex reports that allow the upper management and end users to make important business decisions based on the reports generated

Course content

1 section • 32 lectures • 6h 3m total length

  • Table of Contents for SQL Server Reporting Services (SSRS)6:37
  • What is SQL Server Reporting Services8:24
  • Download site for SQL 2016 Server13:49
  • Correction of next Video1:12
  • Download and install SQL Server Data Tools8:28
  • Download and attach database AdverntureWorks201612:19
  • Creating a first simple SSRS report19:22
  • The basics of formatting a simple report18:37

    Format a simple SSRS report by applying color, fonts, alignment, and backgrounds in design view, using a shared data source and the wizard, then preview to refine presentation.

  • Freezing the header columns of report15:43
  • Creating a table using the table item object part 110:29
  • Creating a table using the table item object part 210:21

    Format dates and currency in a SSRS table, adjust column widths, and merge cells for a clean layout. Enable interactive sorting on name and standard cost with repeating headers.

  • Create a Header and a Footer17:12
  • How to group columns and use drill down14:37
  • Grouping and creating subtotal and totals13:08

    Group data by continent in SSRS and add subtotals and totals for population in millions. Build a report from scratch by importing continents data and creating a world database.

  • Creating Grand Totals for numbers4:52
  • Creating multiple drill down on columns part 113:13
  • Creating multiple drill down on columns part 27:34
  • Importing images9:15
  • What is a matrix report9:22
  • Creating charts12:09
  • What are indicators13:16
  • Using and creating a powerful list report16:01
  • What are parameters9:03
  • Creating a parameter19:53
  • Creating a cascading parameter part 110:01
  • Creating a cascading parameter part 210:59
  • Using conditional formatting on a report11:50
  • Creating and using templates10:00
  • Creating and using templates part 210:08

    Create and reuse an ssrs template with header, footer, and a data source driven table linked to a dataset to streamline new report creation and formatting.

  • Creating sub reports14:41
  • Creating an embedded sub report5:15

    Learn how to embed a sub report into a main report and include a chart, using design view, sub report properties, and population chart to visualize continent data.

  • What is the benefit of a bookmark5:53

Requirements

  • All material, applications, documents, SQL scripts will be provided by the instructor via a zip file that is requested. Student need to take Learn T-SQL course before taking this course (and or SQL Admin part 1, 2, 3 not mandatory but helpful)

Description

After completing this course, the student will be able to install SQL Server 2016, install Microsoft Visual Studio and create from scratch reports from simple to complex reports that aid in upper management in making important business decisions; and at the same time, aid the end user to view, interact with, and distribute reports in various platforms.  He will be versed in creating, formatting, designing, and submitting reports that the users will benefit from each business day.  The student will learn how to navigate through Microsoft visual Studio, learn how to to save .rdl files, create templates, render reports in various format, apply different methods of creating rich reports, help the end user with avoiding redundant input of data, examine ways to insure end user has aggregates for reports and be able to communicate the needs of the company via reports.  This knowledge will make the student become well versed in the ability to help the organization in moving forward with summary visual data.

Who this course is for:

  • Any student that want to learn about creating, configuring, and managing reports for their business needs and those responsible for creating reports for upper management that make important business decisions
  • Any student that want to learn about creating, configuring, and managing reports for their business needs and those responsible for creating reports for upper management that make important business decisions. Students will need Learn T-SQL course created by me to help understand the T-SQL scripts created for each report.

Report abuse