SQL Server Reporting Services 2014/2012 - Jedi Master Level
Course: SSRSJM
Duration: 2 Days
Level: III
Course Summary
The course focuses on extremely heavy reporting problems whose solutions will save authors months of reporting time. It teaches how to avoid re-creating the same reports that differ only in different columns, groupings and measures. You?ll overcome SSRS limits and learn how to implement things that SSRS does support or officially doesn?t allow to do, even without the need for programming.
After completing this course, you?ll forget the phrase ?It?s impossible? and you?ll join the elite ranks of reporting masters. You?ll squeeze much more from the reports than is officially possible.
« Hide The Details
Topics Covered In This Course
Jedi Master Reporting Techniques
- Displaying results of dynamic SELECT statements with variable number of columns
- Displaying dynamic reporting elements in a table
- Universal, generic reports
- Universal OLAP cube browser, where the users can choose by themselves while running the report, what they want to see in rows and columns and what they want to see at their intersections
- Working with layers of maps
- Geographic drilldown within a single report
- Developing interactive games in reports (yes, you?re reading that right ? games in reports)
Interactive Reporting
- Creating buttons, checkboxes and other UI elements
- Adding JavaScript to reports ? for custom error messages, custom code, custom actions, ...
- Modification of data in databases using the reports
- Integrating reporting actions with external systems
Other Secrets of Jedi Masters
- Reporting over large amounts of data
- Introduction to Reporting Services Extensions API
- Automatic translation of reports ? multilingual reports, multilingual report templates, automatic translation of content
Reusing the same reports for multiple types of users
- Advanced usage of collections
- Advanced parameter binding, dynamic binding, and work with it
Problem Solving
- SSRS utilization reports
- Performance tuning of SSRS
- Monitoring SSRS
- Debugging internal SSRS bugs and errors
- Solving problems with SSRS and reports
What You Can Expect
Upon successful completion of this course, students will be able to:
- Report like a Jedi Master
- Create reusable, universal reports
- Create interactive reports for enhanced user experience
- Avoid repetitive work when creating similar reports
- Use secret Jedi Master techniques
- Overcome SSRS limits
- Solve problems with SSRS itself
Who Should Take This Course
Report authors and BI developers, who want to master the creation of the most advanced reports, regardless of the limitations of SSRS.
Recommended Prerequisites
Advanced knowledge of reporting, at the level of our SQL Server Reporting Services - Advanced Reporting course.
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 |
SSRSXP |
SQL Server Reporting Services 2014/2012 - Extensions and Programming |
3 Days |
II |
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 |
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.
|
