SQL Server Reporting Services (SSRS)

This course covers basic to advanced SSRS topics

SSRS Installation and Setup

How to create report , develop and deploy the complex reports

How to troubleshoot the reports if any error

Data Sources , Data sets, performance improvements , Report Manager Setup, Report Server configuration

Graphical Reports, Table Reports, Matrix Reports, Guage reports, SSRS with API interaction

SSRS with dot net code integration

Page numbers setup

SSRS Parameters configuration

SSRS Interview questions with answers

SSRS Log files

SSRS User Statistics

SSRS Reports delivery

SSRS:

It’s a reporting platform; it’s used to generate the reports from any data source (any RDBMS).Provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports

SSRS Dev Roles:

· Understanding the database structure.

· Writing the queries, views, stored procedures and UDF’s.

· Authoring reports

Defining Data sources.

Designing reports.

· Customizing the reports.

SSRS expression

Scripting (.net languages)

SSRS Admin Roles:

· Installation

· Configuration

· Managing Reports

Development

Security

· Delivering reports

Subscriptions

Rendering formats

· Monitoring and troubleshooting the ssrs environment.

Enterprise reports:

Complete business standards and rules followed.

Formatting and other requirements collected.

Report developers will prepare these reports with complexity.

Shared among the business users in the enterprise.

Standard data analysis and decision making purpose.

Ad-hoc reports:

No business standard and no rules followed.

No formatted and other requirements.

Non-technical business managers will prepare these reports.

Not shared among business users in the enterprise.

Ad-hoc data analysis purpose.

Embedded Reports:

Embedding the report to any third party application such as Java,.Net etc..

Rating Distribution

• 1 stars: 4 votes
• 2 stars: 6 votes
• 3 stars: 13 votes
• 4 stars: 28 votes
• 5 stars: 51 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!