Online SSRS Training |SQL Server Reporting Services Online Training

Course Modules

1. Introduction 1 Videos

Videos

SSRS Introduction
Preview 33 Mins : 0

Documents

SSRS Inroduction Course Material

2. Creating Reports 1 Videos

Videos

Creating Reports
Mirror 1 | Mirror 2 27 Mins : 0

Documents

Creating Reports Course Material

3. Working with tablix 4 Videos

Videos

Using Table
Mirror 1 | Mirror 2 67 Mins : 0
Exploring Table
Mirror 1 | Mirror 2 18 Mins : 0
Using Matrix
Mirror 1 | Mirror 2 31 Mins : 0
Using List
Mirror 1 | Mirror 2 25 Mins : 0

4. Working with Parameters 6 Videos

Videos

Single Valued Static Parameter
Mirror 1 | Mirror 2 20 Mins : 0
Multi Valued Static And Dynamic Parameter
Mirror 1 | Mirror 2 19 Mins : 0
Uses of Parameter
Mirror 1 | Mirror 2 16 Mins : 0
Cascading Parameter
Mirror 1 | Mirror 2 24 Mins : 0
Parameter As Filter
Mirror 1 | Mirror 2 18 Mins : 0
Drill Through And Sub Report
Mirror 1 | Mirror 2 16 Mins : 0

Documents

Working with Parameters Course Material

5. Data Visualization 5 Videos

Videos

Chart
Mirror 1 | Mirror 2 42 Mins : 0
Data Bar
Mirror 1 | Mirror 2 15 Mins : 0
Sparkline
Mirror 1 | Mirror 2 14 Mins : 0
Guage
Mirror 1 | Mirror 2 35 Mins : 0
Indicator
Mirror 1 | Mirror 2 24 Mins : 0

Documents

Data Visualization Course Material

6. Other Features 5 Videos

Videos

Interactive Sorting
Mirror 1 | Mirror 2 25 Mins : 0
Document Map
Mirror 1 | Mirror 2 10 Mins : 0
Page Layout
Mirror 1 | Mirror 2 52 Mins : 0
Lookup Function
Mirror 1 | Mirror 2 7 Mins : 0
Custom Function
Mirror 1 | Mirror 2 7 Mins : 0

Documents

Other Features Course Material
Sales By Territory And Product Category Sample Code

7. Report Managment 5 Videos

Videos

Report Management
Mirror 1 | Mirror 2 46 Mins : 0
Processing Option
Mirror 1 | Mirror 2 55 Mins : 0
Security
Mirror 1 | Mirror 2 24 Mins : 0
Security Query and Filter
Mirror 1 | Mirror 2 17 Mins : 0
Report Builder and Report Part
Mirror 1 | Mirror 2 16 Mins : 0

Documents

Report Managment Course Material

8. Sample Project with Complete Source Code 0 Videos

Videos

Documents

SSRS Demo App Sample Code

What is SSRS?

SQL Server Reporting Services (SSRS) is a reporting software that allows you to produce formatted reports with tables in the form of data, graph, images, and charts. These reports are hosted on a server that can be executed any time using parameters defined by the users. It is part of Microsoft SQL Server Services suite.

Why choose SSRS?

SSRS is an enhanced tool compared to Crystal Reports
Faster processing of reports on both relational and multidimensional data
Allows better and more accurate Decision-making mechanism for the users
Allows users to interact with information without involving IT professionals
It provides a World Wide Web-based connection for deploying reports. Hence, reports can be accessed over the internet
SSRS allows reports to be exported in different formats. You can deliver SSRS reports using emails
SSRS provides a host of security features, which helps you to control, who can access which report

Features of SSRS?

Offers a Simple Object Access Protocol (SOAP) application and pluggable architecture
Retrieve data from managed, OLE ODBC, and DB connections
Allows you to create adhoc reports and save them to the server
Display data in a variety of formats which includes tabular, free-form, and charts
Create custom controls by using report-processing extension
Embed graphics, images to the reports. You can also integrate with external content using SharePoint
You can store and manage custom reports
Chart and Gauge control feature allows you to display KPI data

Advantages of SSRS

It is faster and cheaper
Efficient reporting access to information that is residing in both MS SQL Server database or Oracle
No need for expensive specialist skills
In SSRS the default report designer is integrated with Visual Studio .NET. This allows us to create an application and reports in the same environment
The security is managed in a role-based method which can be applied to folders and reports
Subscription-based reports are automatically sent to the users
Faster production of reports on both relational and cube data
Real time information to the business, providing better decision support

Course Objectives

To gain an understanding of how to develop, format and manage reports.
To understand the Complete SSRS lifecycle.
To create reports using Wizard, Report Designer and Report Builder.
To understand and use different report items like Table, Matrix, List, Image, Textbox, Line etc.
To enhance the report with formatting Grouping and summarizing the data.
To understand and use Data visualization items like Chart, Gauge, Sparkline, Databar etc.
To use expression, Collections, Global Collection.
To use single valued, Multi-valued, cascading parameters.
To use sub report and Dill down report, Drill through a report.
To use interactive Sorting, Documentmap, Custom function.
To Deploy, publish the reports and configure report server and report manager Url and Report server database.
To work with report Manager for managing folders, Configuring Data Source, DataSet properties and Security.
To learn Caching, Reportsnapshot, Reporthistory, Site setting, Subscription, Reportpart.

Mrs. Vandana Soni is a Microsoft Certified Trainer, Azure Data Engineer Associate, and a Software and Corporate Trainer. With 18 years of IT experience, she is adept Corporate Training, Live Training, and Online Webinars.

She has trained 50,000+ individuals all over the world and delivered 50+ Corporate Training all over India and abroad in the following technologies. She specializes in Data Analytics, SQL Server Training, and giving Certification Guidance to Corporates. As an Azure Data Engineer, she has the confidence in teaching from basics to advanced level topics, covering every aspect in detail.

Know more about Vandana Soni - https://www.bestdotnettraining.com/Vandanasoni

Follow her on LinkedIn -https://www.linkedin.com/in/vandana-soni-85a29475/

Pre-requisites:

Before opting this course the student should have general familiarity with relational database concepts and writing basic SQL SELECT statement.

Frequently Asked Questions:

Does BestDotNetTraining offer any Live Projects?

Yes. With every course, you will be given a sample project document which contains complete source code. We also have a special course on Developing Live Project which will help you to learn the process involved in all the stages of application development. For more details, please check page, Live Project Training.

What do I get when I take this subscription?

You will be able to do following things for each of the module -

Video Access for the time period mentioned in the subscription.
Course material in PDF format - You can download and save them for future reference.
Assignments - Every module has assignment for you to practice. We also provide solutions for most of the assignments.
Interview Questions - In every module, we provide you with a set of interview questions, both descriptive and multiple choice.
Online Exam - You can evaluate where you stand in the subject with our online exams.
Tech Support - There are SMEs for any kind of questions you may have while practicing the subject.

What are the software requirements for online classes?

You need to have the latest version of Visual Studio .NET i.e., VS.NET 2019 installed on your machine. You can download the trial version from the links below.