Home Add to Favorite Contact Submit  
             09 June, 2023

Category:  Articles » Computers » Software


Microsoft Dynamics Gp 10.0 Reporting - Traditional And New Tools

         Views: 1956
2007-08-02 11:45:56     
Article by Andrew Karasev

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 don't 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

Specialized in: Microsoft Dynamics Gp - Reporting - Traditional - New Tools
URL: http://www.albaspectrum.com
Print article      Bookmark this page
Related Articles 
Industrial-grade disk sanitation for enterprises (Popularity: ): One of the most overlooked areas of information security is secure IT asset disposal (SITAD), which governs the processes around retiring things like old hard drives securely. Deprecated hardware poses an enormous and often underrepresented security threat. Things like old hard drives and any other digital storage device often contain sensitive information. In the business environment, this might include regulated customer data, information about financial transactions, trade secrets, and intellectual ...
Acronis True Image 2020 - 12 Critical Online Backup Features (Popularity: ): Cloud backup software comes in all shapes and sizes. Some providers simply offer online backup while other providers both online and local but you must purchase separate products. Not only does hybrid backup guarantee protection of your data, it also simplifies data recovery. For example, if you only need to recover one file that you accidentally deleted, it may be faster to recover that file from the cloud rather than ...
Automate FTP workflows and save valuable time and money (Popularity: ): These days, no business leader wants to be paying to get routine work done that can easily be automated. Most employees would rather focus on their major skills and grow their careers as well, rather than work with regular, monotonous processes. Yet those routine and repetitive processes are also critical in any functioning business. Transferring and synchronizing files between a local computer and a remote FTP or SFTP server is ...
Protect your online security with GlassWire Free Firewall (Popularity: ): A firewall is an essential component for protecting any home or business network, but a conventional solution, such as the one provided by default in modern Windows operating systems, falls short in a variety of ways. It doesn't give you any insights into your internet traffic, and there aren't many controls to help you optimize the user experience. While the complete lack of user interaction might make it an attractive ...
Automate FTP Downloads and Uploads with FTPGetter Professional (Popularity: ): For those who work with web development, accessing and using files stored on remote FTP or SFT servers is often a daily part of the routine. Whether you're manually installing a theme or plugin for WordPress or synchronizing files between a local and remote server, using a basic FTP client provides an instantly familiar environment. Unfortunately, these clients are also severely limited when it comes to speed, responsiveness and features ...

Related Business 
Microsoft Dynamics Partner (Popularity: ): Founded in 2006, I-NET Dynamics is a certified Microsoft Dynamics Partner providing Microsoft Dynamics Business Solutions and IT Managed Services for companies in ASEAN. We commit to the mission of helping our customers to advance beyond their challenges and achieve their business objectives by empowering with the right solutions.
Dynamics CRM Partner in UAE (Popularity: ): Microsoft Dynamics CRM 2011 and Microsoft Dynamics CRM Online unlock new opportunities and provide a single development environment for cloud-based and on-premises deployments. Partners, including independent software vendors, global system integrators, and value-added resellers, can quickly create, package, and distribute Microsoft Dynamics CRM extensions and custom solutions.
Microsoft RMS Supported Webshop Solution (Popularity: ): 24SevenCart offers a collection of all standard features required to run a successful online retail store along with robust interfaces for product and shipping management, sales processing, payment processing, promotion and marketing tools, reporting, multi-layered security and so on. 24SevenCart can easily be integrated with Microsoft Dynamics RMS and various other POS systems for seamless synchronization of data at the physical store and the online storefront.
CEM Business Solutions (Popularity: ): CEM Business Solutions is a Microsoft Gold Certified Partner specializing in Dynamics Implementation, CRM, AX payroll, ERP and SharePoint Services, Dynamics AX Implementation, Dynamics AX Upgrade, Dynamics AX for construction and ERP Implementation services. CEM was established with the clear focus on Microsoft Dynamics practices. With a combined experience of over 150+ man years, 250 customers across 19 industries, CEM has discovered ways to help ambitious companies in achieving the ...
Microsoft Dynamics NAV (Popularity: ): Microsoft dynamics NAV is an enterprise resource planning (ERP) software which allows you to control over your core business processes, which is easy to implement, configure and use.
Dynamics Australia (Popularity: ): Dynamics Australia gives high quality Microsoft Dynamics ERP solutions to businesses in Australia at a cost effective rate.
AccentSoft Utilities (Popularity: ): Password recovery tools for Microsoft Access, Microsoft Excel, Microsoft Word, and Microsoft Money.
Microsoft Dynamics Consultants (Popularity: ): RAPTT offers Microsoft Dynamics NAV, AX, GP and CRM services to customers who are seeking a people oriented service provider. Our number one objective is to provide the highest level of customer service through the timely provision of certified people. We value our people who can work from home, on site, or alternative locations at times that suit their lifestyle. This promotes productivity and an optimal work-life balance.
Microsoft Dynamics Partners (Popularity: ): Search right Microsoft partners from our Microsoft Directory to meet your enterprise technology needs. Search by country, competency, partner level, certified partner type, and more.
TrackerOffice (Popularity: ): TrackerOffice provides applications for project management, time and expense reporting, purchasing, invoicing, personnel management and business reports through Microsoft Outlook and Microsoft Exchange or Microsoft Back Office.