Book now
Session room

The Agenda

Agenda Home

SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.

2024 Training Days

Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.

  • 08:00 Registration opens and breakfast served.

  • All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
  • All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
  • No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.

SQL Server Reporting Services

Description

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

Learning Objectives

Previous Experience

Tech Covered

SSRS
Book now