Report Builder (online)
Course
Online
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
Start date
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
Trainer
Course programme
- Data sources
- Datasets
- Using query designer
- Creating tables
- Interactive sorting
- Floating headers
- Inserting groups
- Group headers/footers
- Displaying group totals
- Expanding and collapsing
- The expression builder
- The ReportItems collection
- Built-in fields
- Conditional formatting expressions
- Page headers and footers
- Page names and numbers
- The various report formats
- Using RenderFormat.Name
- Creating parameters
- Filtering using parameters
- Drop list parameters
- Coping with empty tables
- Row and column groups
- Sorting and filtering matrices
- Creating subtotals
- Creating charts
- The parts of a chart
- Formatting charts
- Text boxes and images
- Selecting report items
- Formatting parts of a report
If time
Miniature charts- Creating sparklines
- Creating data bars
- Creating and customising indicators
- Linear and radial gauges
- 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
- 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
Report Builder (online)