Play all

Start

Introduction

Introduction to Reporting Services

Reporting Services Components

Reporting Services Tools for Report Authoring

Tools for Report Server Admin - Native Mode

Tools for Report Server Admin - SharePoint Integrated Mode

Tools for Report Content Management

Software Requirements

Introduction to Reporting Services Data Sources

Data Sources

Connecting to SQL Server Management Studio

Restoring the WideWorldImporters Database

Importing Queries for the Class into SSMS

Accessing the Web Portal from RSCM

Creating a Shared Data Source in SSRS

Accessing Report Builder from SSRS

Creating a Dataset in Report Builder

Adding Extensions in Visual Studio

Creating a Project in Visual Studio

Creating a Shared Data Source in Visual Basic

Creating a Shared Dataset in Visual Studio

Reporting Services Data Sources Recap

Introduction to Paginated Reports

Creating Paginated Reports with Report Wizard

Modifying Values and Date Formats

Adjusting Columns and Repeating Items

Creating a Paginated Report from Scratch in Visual Studio

Adjusting Column Headings and Widths

Manually Setting Row Grouping

Changing Date and Number Formats

Grouping Rows and More Adjustments to Columns

Adding and Repeating Report Headers Across All Pages

Using the Wizard to Create a Table Report

Publishing Reports

Setting Target URL and Deploying Solution

Paginated Reports Recap

Conclusion

Description:

Dive into a comprehensive beginner tutorial on SQL Server Reporting Services (SSRS) for data analysis. Learn the fundamentals of this powerful SQL Server-based tool used for creating, testing, and deploying various reports. Explore SSRS components, tools, and supported data sources. Gain hands-on experience configuring SSRS to interact with source data systems, creating data sources with appropriate connection strings, and building datasets. Master the art of crafting paginated reports using both Report Builder and Report Designer in Visual Studio. Conclude by learning how to publish and deploy reports to the report server. Perfect for SQL Server users with Administrator access looking to expand their reporting capabilities.

SQL Server Reporting Services - Data Analysis Beginner Tutorial

Learnit Training

Add to list

#Computer Science #Information Technology #Windows Systems Administration #Windows Server #Microsoft SQL Server #Data Science #Data Analysis #Programming #Software Development #Microsoft Visual Studio

0:00 / 0:00