Using Microsoft SQL Server Reporting Services with Microsoft Dynamics GP 10.0 Is a one-day course, Using Microsoft® SQL Server® Reporting Services with Microsoft Dynamics™ GP that explores report design, creation, enhancement, and deployment.
Audience
The audience for this course includes people who plan to implement, configure, 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.
At Course Completion
The course completion objectives are:
-
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.
-
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.
Click Here for a full course syllabus.
Seating is limited and offered on a first-come, first-serve basis. In order to hold a class, minimum attendance requirements must be met.
Prerequisites
Before attending this course, students must have experience with SQL Server Reporting Services, experience with SQL Server Business Intelligence Development Studio or Visual Studio 2005 development environment and general knowledge of Microsoft Dynamics GP 10.0.