Microsoft Dynamics GP 10.0 Reporting: traditional and new tools
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:
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 functionalitySRS & 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 licenseSmart 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 databasesCustom 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 versionSource: Free Articles from ArticlesFactory.com
Related Tags: new, microsoft, tools, and, traditional, reporting, dynamics, gp, 100
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.
Your Article Search Directory : Find in Articles
Recent articles in this category:
- Fix Printer, Keyboard, Speaker and Monitor Cables With Funky Organizers
There are different types of cables that are used when you have a desktop computer at home. Most of - The Growing Trend of Asterisk Phone Systems
Truly, businesses are doing everything they can in the economy and competitive world of today to rem - The Future of Business Intelligence: Innovations in Location Intelligence
In the coming years, many business analysts are predicting that Business Intelligence (BI) will play - Adobe Photoshop Album Starter Edition and What Happened to the Unlock Codes
Adobe has long been known as a star in the digital image editing world and the Adobe Photoshop Album - Choosing the Best Computer For Graphic Design
In the 1980s, desktop publishing came out and graphic designers began to utilize computers for all k - Versatility of Pocket HD Camcorders
In the era of the do-everything handheld gadget, high def camcorders family seems almost passee. The - Contemporary Office Furniture
When considering Contemporary Office Furniture there are a few things that you really should conside - Professional Web Design, Professional Web Designer
There is a lot to consider if you are looking for a Professional Web Design. So let's get to it. Fir - Cell Phone Protection and Safety For Kids
If your like the millions of parents giving your children a cell phone for safety when their away fr - Looking For That Smart Pc Workstation And Desk
Do you need a work area at home. Maybe it is just for doing bills. It may be for a community work ar
Most viewed articles in this category:
- Voip Residential Comparison Guide: Evaluating Packet8, Lingo, And Vonage
Voice over internet protocol [internet telephony] is a rapidly growing technological alternative to - What's The Difference In The Ionic Breeze Quadra?
The Ionic Breeze Quadra is the newer line of ionic breeze units offered by The Sharper Image. These - Selling World of Warcraft Accounts
Everybody knows that WoW is one of the most exciting MMORPGs ever created. This makes selling WoW ac - Film Cameras
Film cameras are simple cameras, which could be used by all easily. People prefer to use film camera - Salesboom SLA-MS Competition
Oh, the irony. Online CRM Services shy away from offering customers a Service Level Agreement. Why t - How To Improve Your Computer Speed Almost Instantly
Probably your computer, even though you bought it last year its no longer that much fast. Like any o - The Mosquito Ringtone - The Tone Adults Can't Hear
Without a doubt, the mosquito ringtone is one of the most popular ringtones ever. Good luck trying - Auto Navigation Systems And Gps Technology While Traveling
If you have managed to do any research on auto navigation systems I'm sure you've come across countl - Do Cheap iPods Really Exist?
If you know anything about music trends, you know that iPods are the hottest portable music device t - Online Mobile Phone Offers: Take 10 Minutes To Save £360 On Your Next Mobile Phone Contract
Cash Is Falling Out Of Your Pocket If you live in the UK, you're probably paying line rental on a m