This one-day course, Using Microsoft SQL Server Reporting Services with Microsoft Dynamics GP explores report design, creation, enhancement, and deployment.
8917
Using Microsoft SQL Server Reporting Services with
Microsoft Dynamics GP 10.0
Single: $795
Group: $9,995
Group: $9,995
1 day
About this Course
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.
Course Outline
Courses are often revised between versions. Please contact us for the most up-to-date course outline.
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.
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.
Course Outline
Courses are often revised between versions. Please contact us for the most up-to-date course outline.
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.
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.
Course Outline
Courses are often revised between versions. Please contact us for the most up-to-date course outline.
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.
Courses are often revised between versions. Please contact us for the most up-to-date course outline.
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.
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.
Microsoft Training
Follow Us
