sing Microsoft SQL Server Reporting Services with Microsoft Dynamics GP 10.0

-Retired (no longer available)


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


At the completion of this course, participants 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.
  • 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.

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: 8917-Retired
  • Duration: 1 day
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend