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