The Agenda

This precon will explore the creation of reports, through to the deployment and management of reports into production. The following content will be covered

Creating Reports

• Explore the Reporting Services Interface
• Describe Data Sources
• Create a shared data source
• Describe data sets type
• Create a data set
• Describe Data regions

Working with the Tablix Data region

• Describe the Tablix data region
• Create a simple Tablix report
• Describe how to create groups
• Describe headers and footers
• Describe how to format a report

Enhancing Reports

• Using Calculated Values
• Create custom fields
• Describing Global collections
• Use Aggregate functions
• Use conditional formatting
• Use collections to enhance report
• Describe Dynamic Visibility
• Use document map
• Use Actions

Parameters and Filters

• Using Parameters and Filters
• Describe the difference between parameters and filters
• Describe Report Parameters
• Create report parameters
• Describe Report filters
• Create a filter

Manipulating Report Parameters

• Describe parameter list options
• Create a multi value parameter list
• Create a dynamic parameter list
• Create a custom item in a parameter list

Adding Visualisations

• Creating Visual Reports
• Describe the chart data region
• Use the Chart data region
• Describe the gauge data region
• Use the gauge data region
• Using Sparkline’s and Data Bars

Publishing and Viewing Reports

• Describe deployment options
• View reports in Report Manager
• Export a Report to Microsoft Word

Managing Reports

• Describe Report Manager properties tab
• Work with the general properties page
• Create a linked report
• Work with the data sources page
• Work with the parameters page

Managing Report Execution

• Describe the difference between a cache and a snapshot
• Describe Parameter and filter effects on cache and snapshots
• Create cached and snapshot reports
• Configure report execution timeout