SQL Server Reporting Services Part 1 (SSRS)

Name: SQL Server Reporting Services Part 1 (SSRS)
Rating: 4.5 (2490 reviews)

Learn how to create from simple to complex reports for your business decision making needs

Highest Rated

Created byRaphael Asghar

Last updated 3/2017

English

English [Auto],

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
Learn to create high-functioning sql server reporting services reports in part 1, covering report creation, formatting, charts, conditional formatting, templates, and cascading parameters.
What is SQL Server Reporting Services8:24
Explore what SQL Server Reporting Services is and how SSR turns raw database data into interactive, secure reports accessible via a web interface, with formats like HTML and PDF.
Download site for SQL 2016 Server13:49
Learn how to install SQL Server 2016 and set up SQL Server Reporting Services (SSRS), including hardware and software prerequisites, SQL Server data tools, and native mode reporting configuration.
Correction of next Video1:12
Download the Community Free edition of Visual Studio instead of the Enterprise trial to access the same reporting features and complete the course.
Download and install SQL Server Data Tools8:28
Learn to download and install SQL Server data tools, including prerequisites like Visual Studio 2015, install SQL Server 2016 and SSMS, and perform required reboots to enable SSRS development.
Download and attach database AdverntureWorks201612:19
Download and attach the AdventureWorks 2016 database, perform backup and restore, and configure SQL Server 2016 reporting services to build SSRS reports in Visual Studio.
Creating a first simple SSRS report19:22
Set up the Visual Studio ssrs environment, create a World database and the World Capital table, then build a first simple ssrs report with a tabular layout using the wizard.
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
Learn how to format SSRS reports by freezing header rows, centering the World Report title, expanding columns, applying borders, and enabling single-page scrolling for seamless data viewing.
Creating a table using the table item object part 110:29
Create a report table in SSRS using the toolbox, a shared data source and embedded dataset, format numbers, dates and currency, merge header cells, and enable interactive sorting.
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
Learn to create a header and a footer in SSRS reports, use text boxes and global variables for page numbers and total pages, and apply formatting across pages.
How to group columns and use drill down14:37
Learn to create grouped tabular reports in SSRS and enable drill down, using an actors dataset imported from Excel into SQL, with parent and child groups.
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
Create grand totals for overall population in millions and implement continent-level drilldown with subtotals in ssrs, using design view to set row visibility and highlight formatting.
Creating multiple drill down on columns part 113:13
Create a nested drill down in SSRS by building category, subcategory, and product hierarchies with standard cost totals. Group, subtotal, and fix headers for expandable reports.
Creating multiple drill down on columns part 27:34
Explore nested drilldown in SQL Server Reporting Services to reveal category, subcategory, and product totals with collapsible details and clear visual cues.
Importing images9:15
Explore importing images into SSRS reports by linking car photos stored as varbinary max in the database, or via file system paths, and configuring image properties and sizing.
What is a matrix report9:22
Demonstrates building a matrix report in SSRS, using year and quarter as columns and category and subcategory as rows, with drill-down on both axes to reveal sales details.
Creating charts12:09
Build a simple population-by-continent chart in SSRS, configure the data source and dataset, sum populations by continent, and add titles, legends, axis labels, and data labels.
What are indicators13:16
Learn how indicators in SSRS visualize performance, using key performance indicators to flag sales below thresholds with red indicators, and create expressions to show status.
Using and creating a powerful list report16:01
Explore creating powerful list reports in sql server reporting services, turning lists into free-form, data-driven layouts with rectangles, images, page breaks, headers and footers for invoices.
What are parameters9:03
Learn how to use parameters in SSRS to filter reports, create dropdown lists for continents and other fields, and build drill-down and multi-select parameters to simplify end-user data exploration.
Creating a parameter19:53
Create a continent parameter to filter the Countries of the World table, implement a dropdown with values from a second dataset, enable multiple selections, and preview filtered results.
Creating a cascading parameter part 110:01
Explore cascading parameters in SQL Server Reporting Services to filter data by category and subcategory with multi-select options. Follow a step-by-step workflow from raw data to a fully filtered report.
Creating a cascading parameter part 210:59
Create cascading parameters in ssrs by wiring three data sets: products, category, and subcategory, adding where clauses, and enabling multi-value selections to filter product data.
Using conditional formatting on a report11:50
Apply conditional formatting in SSRS reports using an if statement expression to color code standard cost above 500 in red, and enable interactive sorting for quick data analysis.
Creating and using templates10:00
Learn to create and apply SSRS templates, place them in a directory, and reuse a standardized layout with different data sets while preserving formatting.
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
Create a main report and a linked sub report to show detailed data such as continents, countries, capitals, and populations, connected by a continent id parameter and supported by templates.
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
Learn how to create and use bookmarks in SQL Server Reporting Services to quickly navigate to data, such as total cost, by linking a bookmark to a text box.

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.