Microsoft Dynamics GP 2010 Reporting
Meeting the Reporting Challenge
Challenges in developing and writing reports
Where Is My Data and How Do I Get to It?
DYNAMICS database versus company database
Dynamics GP table naming/numbering conventions
Accessing data at the table level using SQL Management Studio
Locating Dynamics GP data with additional tools
Working with the Builders: SmartList and Excel Reports
Satisfying basic reporting needs with canned SmartLists
Extending SmartList data to Excel by deploying Excel reports
Creating and publishing new SmartLists by using SmartList Builder
Creating and publishing new Excel Report formats using Excel Report Builder
Additional tips and tricks for using the Builders
Understanding the reports dictionaries and how Dynamics GP treats original versus modified reports
Opening and navigating the Report Writer windows
Modifying all reports in the application by using global modifications
Modifying an existing Dynamics GP report
Importing and exporting customized reports
Rendering reports in Microsoft Word by utilizing the new Dynamics GP 2010 Word template feature
Getting started with SQL Server Reporting Services
Deploying SQL Reporting Services reports and metrics
Modifying the canned reports with Visual Studio
Creating a new reporting metric via Report Builder
Designing Your Analysis Cubes for Excel Environment
Understanding the components of the Analysis Cubes environment
Exploring the Analysis Services database
Modifying our Analysis Cubes environment
Utilizing Analysis Cubes for Excel for Dynamic Reporting
Using an OLAP viewer to connect to the SSAS database
Creating a connection to the cubes
Excel Pivot Table-Analysis Cubes Interface
Utilizing the Excel cube formulas
Creating dashboards from Analysis Cubes data—a few thoughts
Designing Financial Reports in Management Reporter
Management Reporter architecture
Installing and configuring Management Reporter
Navigating the Management Reporter report designer interface
Working with the Management Reporter building blocks
Tools for reducing building block sprawl
Management Reporter Feature Pack 1
Viewing Financial Reports in Management Reporter
Overview of Report Viewer for Management Reporter
Generating reports to the Report Library via Report Designer
Navigating the Report Viewer for Management Reporter interface
Differences between Management Reporter and FRx
Looking back at what we've covered
Viewing our reporting tools in light of reporting challenges
The future of reporting for Dynamics GP
Comparing the Dynamics GP Reporting Tools Against Different Reporting Challenges
Comparing the Dynamics GP Reporting Tools Against Different Reporting Challenges
Comparing the Dynamics GP Reporting Tools Against Different Reporting Challenges