|
Microsoft Dynamics GP 10.0 Reporting: traditional and new tools Alba Spectrum
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains version 10.0 was released in Summer 2007. If you support GP ERP in your organization, the question of GP version upgrade is probably the one you have to face in foreseeable future. Reports upgrade is also required step in the whole upgrade planning and implementation. Good news for you should be the fact, that Microsoft Dexterity remains the base for Microsoft Dynamics GP architecture, as it was for earlier versions of Great Plains: 9.0, 8.0, 7.5, etc. Microsoft also mentioned old and formerly traditional reporting tool Crystal Reports as one of the reporting options for GP 10.0; if you remember the introduction of GP 9.0, when Microsoft recommended SQL Server Reporting Services or SRS as the replacement to Crystal Reports. Below we will try to give you reporting tools highlights:
1. ReportWriter this is as you know Dexterity module, which came all the long way with Great Plains since the earliest versions of the product in earlier 1990th. Traditionally MBS gives you the list of RW reports, which are not upgradeable and should be redesigned in new version from scratch. We know that it is possible to upgrade the reports from this list by comparing calculated fields in the new and old version of the each report. Sometimes we see the situation, when Reports.dic becomes corrupt and the cure is import all reports into new version of Reports.dic in Report Writer import functionality
2. SRS & Crystal Reports. If you plan to deploy complex tables linking in these tools, meaning the creation of really complex report, then we would wish you good luck, however we recommend different approach base your reports on SQL Stored Procedure or SQL view. In this case you control your reporting logic in SQL, which is always a way more powerful, versus any reporting tool. Considering SQL stored procedure based reports both tools are somewhat similar to provide parameters entry form and group the results. Typically CR and SRS are easy to upgrade, as GP tables structure changes in the way of adding new fields and very rarely in renaming or removing fields. We see more and more SRS reports designed for GP one of the reasons might be free licensing versus required CR license
3. Smart List and Excel. Especially considering such tool as SmartList Builder, where you can use smart list to display the results from custom view this makes smart list very powerful for end user, who is not comfortable to do ad hoc SQL queries in Query Analyzer. Plus, for version 10.0 Microsoft recommended Excel reporting, where you do direct connection via ODBC to GP databases
4. Custom Dexterity Reports. Dexterity reporting was very popular, when Great Plains was available for Ctree and Pervasive SQL, and when Crystal Reports were not yet common reporting option for GP in the second half of 1990th. The advantage of Dex reports is tight integration with GP security and you dont have to pay for additional licensing (Crystal Reports). One of the minuses is the necessity to upgrade Dex code for the new version
Andrew Karasev, Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving GP customers in Illinois: Naperville, Aurora, Plainfield, Niles, Elgin, Batavia, Chicago downtown, Joliet, Villa Park, Addison, Schaumburg, Downers Grove, Lisle, Wheaton. Remote support is available to USA and Canada customers: California, Florida, Texas (we have office in Houston), New Mexico, Colorado, Washington, New York, Quebec, Ontario, British Columbia, Arizona. International support is available for Australia, New Zealand, UK, South Africa, Pacific.
Company: Alba Spectrum
|
| Related press releases |
Alba Spectrum, Dynamics GP Technology Partner Announces its Participation in Con... [2009-03-03 18:09:34]
Chicago, IL – March 3, 2009 – Alba Spectrum announced today its participation in Convergence 2009, the premier Microsoft Dynamics event that brings together customers, partners, Microsoft team mem...
|
|
Microsoft Dynamics GP 10.0 Reporting: traditional and new tools Alba Spectrum [2007-07-28 03:48:40]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains version 10.0 was released in Summer 2007. If you support GP ERP in your ...
|
|
Microsoft Great Plains Boca Raton, FL Alba Spectrum Group [2007-12-23 04:52:45]
Microsoft Business Solutions Great Plains is gaining market share as we write these lines. Alba Spectrum Group is announcing its Florida GP consultants headcount increase. If you have concerns about...
|
|
Ecommerce design for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-18 03:29:33]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains backed ecommerce websites are very popular and considering Alba Spectrum ...
|
|
Microsoft Dynamics GP 10.0 Project Green Advances or future ERP trends Alba Sp... [2007-08-23 04:21:37]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
In around 2003 Microsoft stated about Project Green that it will be merging several Microsoft j...
|
|
Planning upgrade for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-08 04:56:42]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are on the way to upgrade GP versions 7.5, 8.0, 9.0 to GP 10.0, then you should read thi...
|
|
Microsoft Dynamics GP 10.0 Implementation in Chicagoland Alba Spectrum [2007-09-03 03:29:31]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are business owner or IT director, you are probably in charge of ERP selection, licenses...
|
|
Microsoft Great Plains Implementation Service in Chicagoland Alba Spectrum [2007-09-06 06:13:43]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP software sales, business processes mapping and modules selection, data mi...
|
|
Microsoft Dynamics GP 10.0 Great Plains: Renaissance of GP Dexterity Alba Spec... [2007-07-30 04:56:04]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP Great Plains version 10.0 is now released and available to GP customers a...
|
|
Old Great Plains Dynamics versions support, recovery and upgrade Alba Spectrum [2007-08-29 05:31:43]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 10630-961-5918
In best case scenario you as Microsoft Dynamics GP customer who is following the recommended ve...
|
|
|
|
| Capture Professional |
Captures images and video from anywhere on your screen. Its assistant guides you through the capture process. Its built-in editor uses 60+ effects and operations, drawing tools (w/ colors, textures, gradients, effects) and macros. |
|
| WebSite X5 Evolution 8 |
WebSite X5 is the outstanding tool that helps turn your website dreams into reality. It's packed with advanced tools to help you create professional websites with all of the eye-catching features you see on the web's very best sites. |
|
| VinylStudio |
VinylStudio makes it easy to convert your vinyl albums and cassette tapes to CD and MP3. It provides all the tools you need, including a full set of sound cleaning filters. |
|
| Dutch Duck Cache and History Reader |
Dutch Duck Cache and History Reader shows Microsoft Internet Explorer's History, Cache, Cookies, and Favorites in a very accessible, spreadsheet-like format. You can selectively remove items, and sort, group, search, print, and export everything. |
|
| WinTools.net Professional |
A suite of tools for increasing MS Windows operating system performance. WinTools.net Pro contains tools: Clean Uninstaller, Scan Files, Scan Registry, Start Up, Tweak UI, Net Tweaker, The Privacy, File Shredder, Invisible Man. Site: www.wintools.net |
|
| Filedoyen |
Filedoyen is a single or dual-pane file and archive (zip) manager with integrated text, code and hex editors, file and folder compare and search. By combining these separate tools into one, Filedoyen makes file management both convenient and easy. |
|
| Hex Workshop |
Hex Workshop is a set of hexadecimal development tools for Windows that combines advanced binary editing with the ease and flexibility of a word processor. |
|
|