Advanced Tablix

• Nesting and docking reporting elements, e.g. a table in a list (a master-detail list)
• Creating stepped tables
• Adjacent groups in tables and matrices
• Dynamic grouping data using parameters
• Dynamic hiding of rows and columns
• Calendar-like and horizontal reports
• Switching rows and columns while displaying the report
• Changing a table to the matrix and vice versa

Advanced Reporting From Analysis Services OLAP Cubes

• Reusing fonts, formatting, etc. from SSAS measures settings
• Asymmetrical queries
• The Aggregate, RunningValue and Previous functions
• Parametric MDX queries
• Adding calculated members and sets to the reports from OLAP cubes

Advanced Charting

• Charts, nested charts and chart pies
• Charts from data calculated on the report level
• Nested charts and reporting multiple derived series in one chart ? e.g. moving averages, trend curves, Pareto curves, etc.
• Dynamic coloring of elements in charts
• Advanced stylistics of charts and chart elements

Advanced Reporting Techniques

• Dynamic resize of reporting elements
• Recursive tables (reporting from parent-child data, e.g. a company or product hierarchy)
• Using data from different data sources in a single table (e.g. Oracle DB + OLAP cube)
• Advanced working with data ranges
• Formatting and reporting using HTML and CSS
• Using variables
• Cumulative totals and custom aggregate functions
• Using already calculated values from report fields to calculate another fields
• Export to Excel and slicing data into multiple sheets
• Multilevel drillthrough (click to another report) and displaying navigation / history of clicks in reports (breadcrumbs)
• Securing data in reports - display only the data that the users are allowed to see
• Creating address labels for envelopes, packages, ...
• Reporting in multiple currencies
• Multilingual reports and automatic displaying of the reports in users language
• Controlling the displaying of content when exporting the report to various formats
• Influencing the style of XML file when exporting to XML format
• Calculated fields in datasets

Advanced Usage of Parameters

• Reporting with a large number of available values for parameters
• Selection of parameter values using a report and support of hierarchical code lists
• Dynamic parameterization - flexible WHERE clause and its conditions depending on the (un-) selection of parameters
• ALL parameters
• Use multivalued parameters with stored procedures and report subscriptions

Programming in SSRS

• Using .NET code and functions from DLL libraries
• Custom aggregation functions (e.g. concatenation of string values into a list)
• Advanced SSRS expressions