8917 Using Microsoft SQL Server Reporting Services with Microsoft Dynamics GP 10.0

Code: 8917
Course duration: 1 days
Price: $895

8917 Using Microsoft SQL Server Reporting Services with Microsoft Dynamics GP 10.0 (1 Day)

About this Course

This one-day course, Using Microsoft SQL Server Reporting Services with Microsoft Dynamics GP explores report design, creation, enhancement, and deployment.

Audience Profile

The audience for this course includes people who plan to implement, configure, consult, or support Microsoft Dynamics GP and want to modify existing reports or create their own custom reports using Microsoft SQL Server Reporting Services. The class is targeted toward application administrators, implementers, and end users of the reports who need to understand technical aspects of using Microsoft SQL Server Reporting Services together with Microsoft Dynamics GP and gain foundational knowledge of the application functionality and capabilities.

Prerequisites

Before attending this course, students must have:

  • Experience with SQL Server Reporting Services
  • Suggested course - 2793A: Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
  • Suggested Exam - 70-445: TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance
  • Experience with SQL Server Business Intelligence Development Studio or Visual Studio 2005 development environment
  • General knowledge of Microsoft Dynamics GP 10.0
  • Knowledge of Microsoft SQL Server 2005 - Suggested courses:
  • 2787: Designing Security for Microsoft SQL Server 2005
  • 2779: Implementing a Microsoft SQL Server 2005 Database
  • 2780: Maintaining a Microsoft SQL Server 2005 Database
  • 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

At Course Completion

The course completion objectives are:

  • List the benefits of using SQL Server Reporting Services together with Microsoft Dynamics GP.
  • Install the SQL Server Reporting Services Wizard.
  • 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.
  • Explain the components of SQL Server Reporting Services.
  • Explain data regions available on reports and how they can be used.
  • Determine the needs for a report.
  • Describe how data is stored in Microsoft Dynamics GP.
  • Determine where information exists in Microsoft Dynamics GP.
  • Identify main tables, sorting and restricting requirements.
  • Identify table relationships to assist in creating SQL statements or stored procedures.
  • Describe global collections that can be used on a report.
  • Create a report, data source, and data set.
  • Enhance a report by making modifications to the layout.
  • Show how to modify properties of items on a report.
  • Describe and use parameters.
  • Publish reports with Report Designer and view them in Report Manager.
  • Describe subscriptions and when to use them.
  • Describe and create a report model.
  • Use Report Builder to work with entities and folders, group, sort, and filter data, and view and publish a report.

Course Outline

Module 1: Overview and Administration
This chapter provides a general overview of the features and benefits of using SQL Server Reporting Services together with Microsoft Dynamics GP. Steps to install the SQL Server Reporting Services Wizard, to install the Microsoft Dynamics GP SQL Server Reporting Services reports, and make the reports available in Microsoft Dynamics GP are included. This chapter contains a list of SQL Server Reporting Service reports available in Microsoft Dynamics GP, and also provides an overview of SQL Server Reporting Services components.

Lessons

  • Overview and Benefits
  • Available Reports, Report Models, and Data Sources
  • Deploy Data Connections and Reports
  • Add Reports to My Reports List
  • SQL Server Reporting Services
  • Data Regions
  • Connect to the Web Services

After completing this chapter, students will be able to:

  • List the benefits of using SQL Server Reporting Services together with Microsoft Dynamics GP.
  • Install the SQL Server Reporting Services Wizard.
  • 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.
  • Explain the components of SQL Server Reporting Services.
  • Explain data regions available on reports and how they can be used.

Module 2: Plan a Report
This chapter provides report planning guidance and includes a planning checklist. Data storage in Microsoft Dynamics GP is investigated including the terminology, table names, types and groups. Direction is given in determining where information is located in Microsoft Dynamics GP, what the structure of returned data looks like, and relationships between tables.

Lessons

  • Planning a Report
  • Data Storage
  • Determine Where Information Exists in Microsoft Dynamics GP
  • Identify the Data Structure Returned to the Data Set
  • Table Relationships

Lab : Lab

  • Report Planning

After completing this chapter, students will be able to:

  • Determine the needs for a report.
  • Describe how data is stored in Microsoft Dynamics GP.
  • Determine where information exists in Microsoft Dynamics GP.
  • Identify main tables, sorting and restricting requirements.
  • Identify table relationships to assist in creating SQL statements or stored procedures.

Module 3: Author, Enhance, and Deploy Reports
This chapter focuses on report creation and modification in the SQL Server Reporting Services Report Designer. Step-by-step instructions to create a new report are provided and common report enhancements are discussed. Deploying the report to the report server and using subscriptions to distribute reports are also discussed.

Lessons

  • Collections
  • Report Creation
  • Report Layout
  • Use Properties to Enhance a Report
  • Parameters and Filtering
  • Publish and Execute Reports
  • Use Subscriptions to Distribute Reports

After completing this chapter, students will be able to:

  • Describe global collections that can be used on a report.
  • Create a report, data source, and data set.
  • Enhance a report by making modifications to the layout.
  • Show how to modify properties of items on a report.
  • Describe and use parameters.
  • Publish reports with Report Designer and view them in Report Manager.
  • Describe subscriptions and when to use them.

Module 4: Report Models and Report Builder
This chapter discusses using report models as the basis for a new report. Create the new report by using the report wizard in Report Designer or by using Report Builder. Common terminology and concepts are defined.

Lessons

  • Report Models
  • Report Builder

After completing this chapter, students will be able to:

  • Describe and create a report model.
  • Use Report Builder to work with entities and folders, group, sort, and filter data, and view and publish a report.

E-Tek is an authorized Prometric testing center, offering official Microsoft certification exams at its Secaucus, New Jersey (NJ) location.

Course Reviews

No reviews found for this course.

Be the first to write a review