Visual Data with MS SQL Server Reporting Service (SSRS)

Report Models

• Views of Data Sources, Creating a model, introducing the concepts of entities, attributes and roles

Tables

• Creating tables with sorting and floating headers

Grouping

• Inserting groups with group headers and group footers, creating group totals, Expanding and collapsing the groups

Expressions

• Introducing the expression builder, Report Items, Built-in fields and conditional formatting options and expressions

Page set-up

• Creating page names, numbers, headers, footers

Exporting reports

• Exporting the reports using various report formats, using RenderFormat.Name

Parameters

• What are report parameters, creating and editing report parameters, using the parameters to filter reports, creating parameter drop lists. and copying with empty tables

Matrices

• Row and column groups
• Sorting and filtering matrices
• Creating subtotals

Charts

• Creating charts
• The parts of a chart
• Formatting charts

Basic reports

• Text boxes and images
• Selecting report items
• Formatting parts of a report

Miniature charts

• Creating sparklines
• Creating data bars

Graphical indicators

• Creating and customising indicators
• Linear and radial gauges

Lists

• Page-per-record lists
• Dashboard lists
• Other list ideas

Subreports

• Creating a child report
• Creating the main report
• Linking the two reports

Report parts: Publishing report parts, using the part gallery and update report parts