|
SQL Server Reporting Services 2014/2012 - Extensions and Programming
Course: SSRSXP
Duration: 3 Days
Level: II
Course Summary
During this course, you?ll learn how to extend the functionality of Reporting Services (SSRS). In the first part of the course with the help of creating custom .NET code, then with the help of creating custom reporting components. Next, you?ll get to know how to create, extend and combine new and existing rendering extensions.
The course will also make you familiar with other options for SSRS authentication, other methods for automatic delivery of reports from subscriptions, and how to hack some functionality of SSRS. The course covers various practical problems occurring by deploying such solutions, as well as automation of SSRS functionality through its APIs.
« Hide The Details
Topics Covered In This Course
Programming in Reports
- Programming custom functions
- Reusing code from custom DLL files
- Custom reporting components
- Extending and adding functionality into existing components
- Custom properties for reporting components
- Adding JavaScript to reports
Extending Reporting Services
- Custom rendering extensions
- Extending the existing rendering extensions
- Subrenderers ? e.g. adding watermark to PDF renderer, adding missing features into Word renderer, automatic zipping of rendered reports and returning a ZIP file, returning single report rendered in multiple formats within a single ZIP file, ...
- Custom delivery providers (FTP, SSH, ...)
- Custom authentication providers ? e.g. logon using own usernames / passwords from an external database, logon using Facebook or Windows Live, two-factor authentication via SMS, ...
- Custom in-process transformation of RDL template before rendering it using RDCE
- Custom data processing extension - a custom driver for accessing exotic data sources, e.g. FoxPro
- Restrictions for individual types of extensions
- Deployment and configuration of the extensions on the SSRS server
- Security of extensions
- Debugging and troubleshooting extensions
Automation of Reporting Services
- Rendering reports via API
- Generating reports via API
- Managing reports via API
- Adding custom buttons to the Report Viewer
- Localization of Report Viewer interface to another languages
What You Can Expect
Upon successful completion of this course, students will be able to:
- Extend reports by their own .NET code
- Create custom reporting components, renderers, data sources, authentication and delivery providers
- Correctly deploy, debug and troubleshoot all their extensions
- Translate RDLs automatically using RDCE
- Use SSRS server APIs
Who Should Take This Course
BI developers who need to extend all parts of Reporting Services with their own features, or who just need to customize some of its parts.
Recommended Prerequisites
Basic knowledge of reporting, with experience using SQL Server Reporting Services.
Training Style
Instructor led, including hands-on workshops.
« Hide The Details
Related Courses
| Code |
Course Title |
Duration |
Level |
|
SSQFD |
Microsoft SQL Server: Querying Data for Report Developers |
3 Days |
I |
Details |
SSRS1 |
SQL Server Reporting Services with BI Tools Part 1 - Report Builder, Data Tools, Cubes, and Tabular Reporting |
5 Days |
I |
Details |
MSBI |
Accelerated Microsoft Business Intelligence: From SQL 2008 through SharePoint and Office 2007 |
4 Days |
I |
Details |
SSIS16 |
SQL Server 2016 Integration Services (SSIS) |
5 Days |
I |
Details |
SSRSAR |
SQL Server Reporting Services 2014/2012 - Advanced Reporting |
3 Days |
II |
Details |
SSRS2 |
SQL Server Reporting Services with BI Tools Part 2 - Report Server Admin, Extensive Tabular Modeling/Reporting, and C#/VB Extensions |
5 Days |
II |
Details |
SSRSJM |
SQL Server Reporting Services 2014/2012 - Jedi Master Level |
2 Days |
III |
Details |
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.
|
|
Notify me the next time this course is confirmed!
|
