This 1 day class will provide participants with a fundamental understanding of the functionality available in Microsoft SQL Server Report Builder 3.0. This instructor-led course shows participants report building techniques using relational data models, and ways of enhancing, customizing and managing professional reports.
Attendees will participate in hands-on demos and workshops that illustrate key concepts, while learning how to use the product.
Who should attend?
This course is intended for business users who wish to author basic or ad-hoc reports using Microsoft SQL Server Report Builder 3.0.
Some exposure to relational database concepts including queries written in SQL or a query designer.
In this session we aim to familiarize users with
Microsoft SQL Server Report Builder 3.0 and create a simple report, topics include:
What it looks like
Where everything is
How easy it is to create reports
2. Connecting to Data
In this session we will look at the options there are for connecting to a database or source of data to retrieve data for reports, topics include:
Types of data sources
Shared Data Sources
Report specific data sources
Data source credentials
3. Retrieving Data
In this session we will discuss how to retrieve data for reports and demonstrate how we can write queries to retrieve data for reports, topics include:
Query Designer (SQL / MDX if required)
4. Designing Reports
In this session we will discuss both the layout options for reports and the various ways in which data can be displayed within reports; we will also cover how to format report items, topics include:
Report and page properties
Headers & Footers
Other Report Items
Formatting report items
5. Manipulating Data Sets
In this session we will concentrate on extending the capabilities of reports by manipulating the data retrieved and describe how to sort, filter, parameterize and create calculations within the data.
Using parameters with your data
Creating and using parameters in your data
Setting default values for parameters
Creating parameter lists
6. Enhancing Basic Reports
In this session we will describe some of the extended functionality that can be added to reports to enhance their usability and visual appeal, topics include:
Report item visibility
To display report information & parameters values
To highlight exceptions in data
To stripe data rows
7. Saving, Sharing and Printing Reports
In this session we will describe how reports can be shared either within a report server or from within a SharePoint site and explains some of the benefits of this shared approach,topics include:
Saving local reports
To a report server
To a SharePoint site
Viewing, printing and exporting reports from a report
server or SharePoint
Creating report subscriptions (optional)
To Hire an Microsoft Report Builder 3.0 Subject Matter Expert and Instructor who also teaches this class, call us today at 800-798-3901!