SQL Server Reporting Services (SSRS)

SSRS Basics and Advanced Concepts

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..