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
Microsoft SQL Server: Querying Data for Report Developers
3 Days
SQL Server Reporting Services with BI Tools Part 1 - Report Builder, Data Tools, Cubes, and Tabular Reporting
5 Days
Accelerated Microsoft Business Intelligence: From SQL 2008 through SharePoint and Office 2007
4 Days
SQL Server 2016 Integration Services (SSIS)
5 Days
SQL Server Reporting Services 2014/2012 - Extensions and Programming
3 Days
SQL Server Reporting Services 2014/2012 - Advanced Reporting
3 Days
SQL Server Reporting Services with BI Tools Part 2 - Report Server Admin, Extensive Tabular Modeling/Reporting, and C#/VB Extensions
5 Days

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.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]