Reporting
New integrations with Microsoft Excel, and Microsoft SQL Server Reporting Services provide you with more reporting opportunities than before.
Data connections
Microsoft Dynamics GP and Microsoft Office provide an integration method, called an Office Data Connection (ODC) that allows you to view Microsoft Dynamics GP data in an Excel form. You can use the data connection to create new reports or view existing reports. Microsoft Dynamics GP also provides some predefined reports that display the same data that’s displayed in SmartList default favorites in an Excel form. You can deploy data connections from within Microsoft Dynamics GP, if you aren’t using Microsoft Office SharePoint server. To deploy data connections to Microsoft Office SharePoint server, use the Microsoft Office SharePoint Server Deployment wizard.
You also can set up the Microsoft Dynamics GP report list to display your data connections alongside your standard Microsoft Dynamics GP reports in your report list.
Report lists
Report lists are integrated with Microsoft SQL Server Reporting Services and Microsoft Office SharePoint Server. Now all file types can be included in the report list, such as data connections, and Microsoft Excel reports.
Microsoft Excel
Default Excel reports have been created for you based on existing SmartList favorites. You can deploy these reports to a network location or a Microsoft Office SharePoint server library, where you can open the reports and view live Microsoft Dynamics GP data. You can deploy reports from within Microsoft Dynamics GP if you aren’t using Microsoft Office SharePoint server. To deploy reports to Microsoft Office SharePoint server, use the Microsoft Office SharePoint Server Deployment wizard.
You also can set up the Microsoft Dynamics GP report list to recognize the stored location of these reports so that you can see your Microsoft Excel reports among your standard Microsoft Dynamics GP reports in your report list.
Microsoft SQL Server Reporting Services
A number of new SQL Server Reporting Services reports have been created for you to use in conjunction with Microsoft Dynamics GP 10.0. You can use a new wizard to deploy these reports to your Report Manager, where you currently store your SQL Server Reporting Services reports.
Further integration with Microsoft Dynamics GP allows you to view the SQL Server Reporting Services reports alongside your standard Microsoft Dynamics GP reports in the report list if you have set up Microsoft Dynamics GP to recognize the location of your SQL Server Reporting Services reports. Your reports are easily accessible to both internal and external users.
Excel Report Builder
The Excel Report Builder allows you to create new Excel reports from within Microsoft Dynamics GP. The new reports are have a connection to the Dynamics GP databases, which allows them to be refreshable. This feature is a part of SmartList Builder. (Added in Feature Pack 1.)
