Introduction
This one-day course, Using Microsoft SQL Server Reporting Services with Microsoft Dynamics NAV 2009 explores report design, transition from NAV Report Writer and deployment of final reports.
Audience
The audience for this course includes people who plan to implement, configure, consult or support Microsoft Dynamics NAV and want to modify existing reports or create their own custom reports using Microsoft SQL Server Reporting Services (SSRS). The class is targeted toward administrators, implementers and end users of the reports who need to understand the technical aspects of using Microsoft SSRS together with Microsoft Dynamics NAV.
At Course Completion
The course objectives are:
-
Install the SQL Server Reporting Services Wizard.
-
List available reports, models, and data sources.
-
Demonstrate how to deploy data connections and reports.
-
Demonstrate how to make reports available in Microsoft Dynamics NAV.
-
Explain the various 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 NAV.
-
Determine where information exists in Microsoft Dynamics NAV.
-
Identify main tables, sorting and restricting requirements.
-
Identify table relationships to assist in creating SQL statements or stored procedures.
-
Create a report, data source, and data set.
-
Modify a report’s layout.
-
Describe and use parameters.
-
Publish reports to Microsoft Dynamics NAV
-
Use Report Builder to view and publish reports.
-
Transition a report from Dynamics NAV report writer to Microsoft Dynamics SQL Server Reporting Services.