Report Builder (online)

Course

Online

£ 625 + VAT

Description

  • Type

    Workshop

  • Level

    Beginner

  • Methodology

    Online

  • Class hours

    12h

  • Duration

    2 Days

  • Start date

    Different dates available

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Personal tutor

    Yes

  • Virtual classes

    Yes

Report Builder is almost identical to Reporting Services (the difference is that Report Builder allows you to create reports without having to download or learn Visual Studio).

This two-day course explains how to create reports in Report Builder: creating tables, lists and matrices, formatting reports so that they look beautiful and adding fancy devices like indicators and gauges!

There is no difference that we know of between Report Builder 3.0 and Report Builder for SQL Server 2012 (this course teaches either - or both).

Important information

Documents

  • Report Builder course outline.pdf

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Data sources and datasets
  • Tables
  • Grouping
  • Expressions
  • Page setup
  • Exporting reports
  • Parameters
  • Matrices
  • Charts
  • Basic reports
  • Graphical Indicators
  • Lists
  • The SSRS web portal

Teachers and trainers (1)

Shaun Wantling

Shaun Wantling

Trainer

Course programme

Data sources and datasets
  • Data sources
  • Datasets
  • Using query designer
Tables
  • Creating tables
  • Interactive sorting
  • Floating headers
Grouping
  • Inserting groups
  • Group headers/footers
  • Displaying group totals
  • Expanding and collapsing
Expressions
  • The expression builder
  • The ReportItems collection
  • Built-in fields
  • Conditional formatting expressions
Page set-up
  • Page headers and footers
  • Page names and numbers
Exporting reports
  • The various report formats
  • Using RenderFormat.Name
Parameters
  • Creating parameters
  • Filtering using parameters
  • Drop list parameters
  • Coping 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

If time

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

If time

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

If time

Drill-through reports
  • Parent and child reports
  • Creating actions
  • Passing values to a child report
The SSRS web portal
  • Browsing to the web portal
  • Viewing reports
  • Managing reports

If time

KPIs and mobile reports
  • Creating a KPI
  • Installing mobile report publisher
  • Creating a mobile report

Additional information

This course can also be provided as tailored training at your venue.

Report Builder (online)

£ 625 + VAT