SQL Reporting Services

In this class you will learn how to create, deploy and run high quality information packed reports using the SQL Server Reporting Services tools.

Course Overview: SQL Server Reporting Services provides a collection of tools that allows for reporting on data and extracting data to tools such as Microsoft Excel. Table reports, charts, graphs, gauges, indicators and a number of other tools can take thousands of transactions and reduce them to easily seen trends. Executive dashboards showing open orders, orders invoiced today, purchase orders outstanding, PO’s received today, inventory dollar values, transactions per month compared to last month or this same month last year are all easy to build. 

  • Introduction
    • General Development Flow
    • Data Sources/Datasets
    • Building and Testing Reports
    • Deploying Reports
    • Launching Reports
    • Projects
    • Our Approach
    • Describe how data is stored in Microsoft Dynamics GP
    • Determine where information exists in Microsoft Dynamics GP
  • SQL Server Report Builder
    •    Overview
    • Starting the Report Builder
    • That First Report
    • Multi-Table Report with Groups
    • Formatting Options
  • Reporting With Visual Studio
    • That First Report
    • Projects
    • Panes and Views
  • Accessing Data
    • Defining Data Sources
    • Datasets
    • Query Designer Options
    • The Expression Builder Window
    • Accessing Data Other Than SQL
    • Applying Parameters to Datasets
  • Basic Report Creation
    • A Tour of the Desktops
    • Creating a Report – Overview
    • Creating a Table Report
    • Creating a Matrix Report
    • Creating a List Report
    • General Report Formatting
  • Formatting Text and Data
    • Common Property Screens
    • Toolbox Items
    • Body Properties
    • Header Properties
    • Footer Properties
    • Group Properties
    • Row/Column Visibility
  • Sub-Reports, Charts, etc
    • Subreports
    • Charts
    • Gauges
    • Maps
    • Data Bars
    • Sparkline
    • Indicators
  • The Report Manager
    • Overview
    • Deploying Report Objects
    • Navigating the Report Manager
    • Folders
    • Report Management Menu
    • Launching Report Builder
    • Manage Data Sources
    • Dataset Management
    • Report Manager Security
    • Site Settings
    • List available reports, models, and data sources
    • Demonstrate how to deploy data connections and reports, and make reports available in Microsoft Dynamics GP.
    • Make reports available on the My Reports list.
  • Report prep and Planning
    • Designing the Report
    • Report Specifications
    • Getting Spec Approvals
    • Generating Sample Reports
    • Making a Report Look Good

View our other Dynamics GP course offerings here.

Registration Request