Microsoft Great Plains is main accounting / ERP application from Microsoft Business Solutions, targeted to the US market.� It serves the whole of vertical and horizontal market: most of the industries and company sizes.� Crystal Reports on the other hand is the leader in the reporting software industry and Microsoft is willing to use Crystal as main reporting tool for Great Plains, Solomon, Microsoft CRM, .Net platform, etc.

If you are developer who is asked: how do we extend Great Plains ReportWriter with somewhat more sophisticated - read this and you will have the clues on where to look further.

• Great Plains Tables Structure - first of all you need to know the tables to link.� Launch Great Plains and go to Tools->Resource Description->Tables.� Find the table in the proper series.� If you are looking for the customers - it should be RM00101 - customer master file.� If you need historical Sales Order Processing documents - they are in SOP30200 - Sales History Header file, etc.
• Create ODBC connection to GP Company database.� Use the same technique as when you create standard ODBC connection for GP workstation - but change default database to targeted company database.
• Consider SQL Views - if you don't want complex links in Crystal Report itself or if you need unionization from several companies - SQL view is the answer.
• Consider SQL Stored Procedures.� Sometimes you can not pull the data in one view - you need temporary tables to be created and the final query should be based on these temp tables - this is when you need stored procedure.
• Call Crystal Report from GP Screens via VBA/Modifier - if the user wants to call Crystal report for example - printing Invoices in GP and do it from SOP Entry window - you can use Modifier and VBA to call Crystal Reports engine.
• Create SQL Query to probe the data - we always recommend tuning your query and see that you are getting adequate results - in any case - Crystal Report is just a nice tool to show the results of your query.

Happy customizing, querying and designing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

RELATED ARTICLES Free Software - Powerful Alternatives to Budget-Busting Software When you buy a computer, it most likely comes with Microsoft Windows preinstalled. And when you need a word processor, spreadsheet, or other software, you probably buy it from a computer store. Beware of Spyware One day, you suddenly realize that your computer started to worknoticeably slower than it used to. You decide to run de-fragmentation of your hard drive and add more virtual memory to the system. Backing Up And Restoring Your MySQL Database If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. ERP System of the Future: Database, Business Logic and Interface We will base our prognosis on our Microsoft Business Solutions ERP consulting practice: Microsoft Great Plains, Navision, Axapta, MS CRM. Also we've analyzed Oracle products: Oracle Financials, JD Edwards, PeopleSoft, and IBM Lotus Notes Domino. The Bluebird Project The objective for Zandi Digital is to make available clever programs to end-users that want and need something more diverse. Bluebird is the current application being developed by Zandi Digital. What to Do if All Screensavers Fun is Grayed Out? Finally, you have some time to personalize your desktop with an interesting screensaver. But wait. SyncUp - A File/Folder Synchronizer For Windows SyncUp, a file synchronizer is designed to assist the home and advanced users. The product has a simple and familiar windows explorer type interface for easy file handling. Microsoft Moves to Small Business Accounting/Retail Market - Stakes and Thoughts In this small article we will be looking at the new opportunities for Microsoft Small Business Server specialists, but rather look at the global business strategy and possible ways of future ERP modules standardizing and interoperability. This is important to get into consideration for midsize and large corporate business IT decision makers. Review of TikiWiki Content Management System TikiWiki is open source software - it is written in PHP, uses phpAdmin for mySQL database administration, and uses the Smarty Template Engine.Installation - Since our host installed the TikiWiki, I cannot comment on ease of installation. The Opera Alternative Security flaws have long plagued Internet Explorer (IE), the market-dominating web browser from Microsoft. IE won the early browser wars, not only because it was free and bundled with Windows, but because it had some features and capabilities that its only real competitor, Netscape, didn't have. Great Plains Dexterity: Customizations & Source Code Programming Great Plains Software Dynamics, Dynamics C/S+, eEnterprise were written on GPS proprietary programming language and development environment - Great Plains Dexterity. When Microsoft bought Great Plains Software, Dynamics was renamed into Microsoft Great Plains, but Dexterity is still the architectural base, there were trends to move MS Great Plains to . Microsoft CRM Integration with Microsoft Retail Management System (RMS) - Overview Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS are both Microsoft SQL Server based applications, however historically Microsoft was purchasing industry leading software applications, such as QuickSell which is now Microsoft RMS. So, RMS design fundamentals were minted a long time before Microsoft CRM. How Do I Get Rid Of That Darn Spyware? Ad-Aware and Spybot are probably the two most well known antispyware solutions. However, they frequently fail to catch the more crafty spyware. 10 Programming Tips (1) Avoid using the same variable again and again for different purposes.This happens with us that we think that more and more memory will be wasted if we declare seperate variable for each purpose. Microsoft Great Plains Remote Support - Overview Microsoft Great Plains is now standard mid-market ERP application, serving the whole spectrum of businesses. In the case of mid-size business we usually see strong IT team with SQL querying skills plus accounting department is already trained to use Great Plains and needs minimal help in figuring out on how to use new Great Plains version and features. Fast Car Knoppix Small can be beautiful! Working with Knoppix for the past two years has been a joy. Two terms to describe this distribution, simple, elegance. Microsoft CRM Implementation & Customization: MS CRM Fax Gateway With this small article we are continuing Microsoft Business Solutions CRM customization, development, modification, setup and implementation discussion.Microsoft CRM at this moment doesn't have advanced fax automation - you can register the fact of fax receiving or sending, but it is not sufficient for your daily work with your clients. Basic Steps To Optimize Your Internet Security After seeing many people complain about their weak Internet security I decided to write down some things that will help you for your Internet security.First, here are some tips to make windows safer :For basic security and update patches install Service Pack 2 for Windows XP or Service Pack 4 for Windows 2000. Microsoft Great Plains Implementation: Collection Management - Overview For Consultant Microsoft Business Solutions Great Plains is very good fit for mid-size company and probably good budget solutions for large corporation. Being matured product - Great Plains provides such horizontal solutions as Collection department automation. Introduction To ISDN, Part III: PAP Introduction To ISDN, Part III: Configuring PPP PAP AuthenticationNow we know how the ISDN link comes up (interesting traffic), and some scenarios that might cause the link to stay up, we need to look at ISDN authentication schemes. The two methods Cisco certification candidates must be familiar with are PAP and CHAP.