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, individuals must have:

·          Experience with SQL Server Reporting Services

o    Suggested course - 2793A: Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services

o    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:

o    2787: Designing Security for Microsoft SQL Server 2005

o    2779: Implementing a Microsoft SQL Server 2005 Database

o    2780: Maintaining a Microsoft SQL Server 2005 Database

o    2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL

Student Materials:

The student kit includes a comprehensive manual with lab exercises consistent with the installed sample company data.

(Internal Note: The software used for this class needs to be validated to be consistent with the new Virtual Images that Microsoft will deploy per the court decision – alternate VM image can be supplied by Aztec)

The following software is provided for using in the class:

·          Microsoft Windows ® 2003 Server Enterprise Edition with SP2

·          Microsoft SQL Server 2005 Enterprise Edition with SP2

·          Microsoft Dynamics GP 10.0 with SP3

·          Microsoft FRx Software 6.7 with SP10

·          Microsoft FRx Drilldown Viewer 6.7

·          Microsoft Office 2007

Click Here for the Course Outline:

Course Outline