Tel: 1300 TO TRAIN

Email: info@advancedtraining.com.au

IT Training with Advanced Training



sing Microsoft SQL Server Reporting Services with Microsoft Dynamics GP 10.0


-Retired (no longer available)

Introduction 

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

Outcomes

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