• Authored Course

Reporting in Microsoft Dynamics 365

Learn via: Classroom / Attend from Anywhere

Price: £1440

Dates and Locations

About this Course

Special Notices

Please note: for Attend from Anywhere customers an additional screen is required. The additional screen must have a minimum screen size of 19 inch and minimum resolution of 1280x1024, with the vertical resolution (1024) being the most critical.

This one-day CRM Reporting course informs delegates how to deliver both simple and more complex reports to their the CRM system. Delegates will first learn how to use the basic report wizard to create reports, import and export reports. Delegates will then create reports using the more complex SQL Server Data Tools environment. Reports will be written using both T-SQL and FetchXML. This course is designed for both CRM On-premise users and CRM Online users.

Learn from the UK's leading Microsoft training provider

  • Comprehensive curriculum

    We deliver over 20,000 Microsoft training courses in the UK each year

  • Experienced experts

    Our first-class learning specialists all have a minimum of 5 years training experience

  • Superb satisfaction scores

    99% of our delegates are satisfied with their Microsoft course

  • Trusted training

    We are the largest Microsoft Gold Learning Partner in the UK

  • Microsoft Partner Gold Learning

Why people choose QA

Locations

There are over 20 QA learning centres and many other sites spread across the UK, providing a convenient choice of learning locations and ensuring that over 90% of the population is within 45 minutes of a training destination. Learn more

  • London

    London

    International House

  • Manchester

    Manchester

    Oxford Street

Delegate portal

Booking courses with QA has always been easy, but now we've made it even easier. With myQA you can book, administer and manage all your bookings online, in one place. Login / sign-up

Detailed Information

Module One – Introduction to Reporting

  • Objectives
  • Introduction
  • Useful background knowledge
  • The different reporting development environments
  • Overview of the different reporting tools

Module Two – Reporting within Dynamics 365

  • Objectives
  • Introduction
  • The report development process
  • The differences between SQL based and FetchXML based reports
  • What’s included within Dynamics 365 reporting
  • Creating reports using the Dynamics 365 Report Wizard
  • Using Excel Templates
  • Importing & Exporting .RDL Files

Module Three – Generating FetchXML

  • Objectives
  • Creating Basic FetchXML Queries through the Advanced Find
  • Lab A – Generating Simple FetchXMl
  • More Advanced queries using FetchXML
  • Lab B – Generating more advanced FetchXML

Module Four – Using SQL Server Data Tools Wizard for Reports

  • Objectives
  • Using the SSDT Report Wizard
  • Demonstration: Creating a Custom Report Using the Report Wizard
  • Lab A – Creating a Report using the Report Wizard

Module Five – Using SQL Server Data Tools for Reports

  • Objectives
  • How to create a Microsoft SQL Server Reporting Services (SSRS) Report
  • Creating a Report Server Project
  • Add a Report to the Project
  • Creating Data Sources
  • How to Define a Data Set
  • The Different Data Regions
  • Previewing a Report
  • Format a Report
  • Adding Subtotals
  • Lab A – Creating a Report Project Report

Module Six – Report Visualisations

  • Objectives
  • The Different types of Visualisations within the Report
  • Lab A – Creating an Estimated Value vs Budget Amount Chart

Module Seven – Advanced Reporting Features

  • Objectives
  • Grouping Data within Reports
  • Creating Report Parameters
  • Lab A – Adding Parameters and Groupings to the Report
  • Automatic Pre-filtering within Dynamics 365 Reporting
  • Creating Subreport
  • Other Controls
  • Lab B – Creating a Subreport

Module Eight – Formatting Reports

  • Objectives
  • Adding Headers & Footers
  • Using Expressions
  • Using Collections
  • Lab A – Formatting a Report

  • Delegates must have a working knowledge of Microsoft Dynamics CRM.
  • Some TSQL knowledge is advantageous if writing reports for CRM on-premise
  • Some previous knowledge of Visual Studio is advantageous

Please note: Before attending this class delegates must have a Microsoft account (signing up one is free). The instructions on how to set up a Microsoft account can be found here.

Please note: for Attend from Anywhere customers an additional screen is required. The additional screen must have a minimum screen size of 19 inch and minimum resolution of 1280x1024, with the vertical resolution (1024) being the most critical.

Microsoft
Microsoft Certifications

Take the next step in your career by achieving certification in Microsoft Technologies.

Microsoft Azure
Microsoft Azure

Master Azure with QA, the 2015 Microsoft Worldwide Learning Partner of the Year.

Windows Server
Windows Server 2016

Learn to efficiently manage corporate IT infrastructures with Windows Server 2016.

MOC on Demand

Delivers Microsoft Official Curriculum (MOC) courses online straight to your device.