SQL Report Builder 3.0 Training

Description

• Type

  Course

• Location

  London

• Duration

  2 Days

Description

This 2 day course is an introduction to creating reports using Report Builder 3.0. It is designed for experienced Excel or Access users wanting to create reports for use with Microsoft Reporting Services, which is a component of Microsoft SQL Server.

Facilities

Location

Start date

London

See map

99 Bishopsgate, EC2M 3XD

Start date

Different dates availableEnrolment now closed

About this course

Requirements

Knowledge of SQL or querying SQL server databases using T-SQL. Familiarity with data processing techniques and concepts and the ability to use a graphical user interface.

Questions & Answers

Add your question

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

Fill in your details to get a reply

Send

We will only publish your name and question

Request information

We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.

Thank you!

We are reviewing your question. We will publish it shortly.

Or do you prefer the center to contact you?

Request information

Reviews

Have you taken this course? Share your opinion

This centre's achievements

2019

How do you get the CUM LAUDE seal?

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 10 years

Subjects

• Report Writing
• SQL
• SQLite
• SQL Database
• Builder
• SQL Server
• Reporting
• SSRS
• Sql training
• Reports and Databases
• SQLOS
• SQL Server Scheduling
• Report Builder
• SSRS Architecture

Course programme

TopicsSSRS and Report Builder 3.0 Overview

• SSRS Architecture and key components
• Reporting life cycle in Reporting services
• About Report Builder 3.0
• Report Builder environment
• Demo: Creating basic report with report builder 3.0

Report Authoring with Report Builder

• About data sources and datasets
• Creating embedded/shared data sources and datasets
• Applying basic formatting in report – hands-on
• Understanding Expressions
• Functions
• String, date time and decision functions
• Printing, Exporting and saving reports

Understanding data regions

• About Data Regions available in Report Builder
• About Table, Matrix, and List data regions
• Gauge and chart data visualization regions
• Using Indicators in Table region
• Creating Sparklines/Data bars in a Report

Grouping and Summarising Data

• Grouping Data in a Report
• Aggregating/ Summarising data in a Report

Report Parameters, Filters and Subreports

• Report Parameters
• Report Vs Query parameters
• Creating Cascading Parameters
• Applying filters on the report
• Filters at report and data region level
• Sorting data in the report
• Implementing Document maps
• Implementing Interactive sorting
• Creating Subreports
• Creating Drill-through reports

Report Management

• Report management fundamentals
• About Report Manager
• Security in reporting services
• Item level and system level security
• Understanding subscriptions
• Prerequisites for standard subscription
• Email and file-share subscriptions

Hands-On Exercises for delegates

• Creating Data Source and Data sets
• Formatting Text Report
• Saving, Exporting and Printing Reports
• Creating a Basic Tabular and Matrix Report
• Creating a Basic Chart, Pie Chart and Bar Chart Report
• Adding Sparkline and KPI to your Report
• Creating parameters and filtering data in the Report
• Implementing drill-down, drill through and Interactive sorting in Reports
• Setting up report permissions and subscriptions in Report Manager

See related categories

• SQL courses
• Distance learning SQL courses
• SQL courses London
• SQLite courses
• Distance learning SQLite courses
• Report Writing courses
• Distance learning Report Writing courses
• Courses in England
• Technical writing courses
• Speed writing courses
• Bid writing courses
• Oracle sql courses
• Technical report writing courses
• Medical writing courses
• Travel writing courses
• Legal writing courses
• Science writing courses
• Scientific writing courses
• Academic writing courses
• Freelance writing courses
• Business report writing courses
• Food writing courses
• SQL Server courses
• Distance learning SQL Server courses
• Distance learning Course
• Courses in London
• Acuity Training London courses