Education: SSRS Beginners - Live Training

Interested in the SSRS (SQL Server Reporting Services)? Fill out this training request form.

Objectives

• Learn how to create a database connection and open report builder via different methods

Standard Agenda

• Access Report Builder
• Create Data Source connection to Oracle Database
• Create a shared Data Source
• Add a folder on the Report Server
• Create a Dataset
• Report Builder Layout
• Add a Table Report Item
• Formatting and conditional formatting
• Sort, Group and Filter
• Parameters
• Totals
• Expand Collapse
• Matrix reports

Outcomes

• Create report on Data from the MRI Education database
• Set up a connection – set up a connection to the MRI Education system
• Extract data from the system
• Restrict data being returned in the query
• Format data to make dates display correctly or change font/style or colour
• Simple aggregates – aggregating data to show totals and counts
• Built in Fields – add data extract dates to reports
• Publish reports – publish a report to the server for others to view