Crystal Reports for Microsoft Great Plains ? Overview for Developer

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.

    In The News:

    pen paper and inkwell


    cat break through


    Dig Out That Worm

    Internet worms. Is your PC infected?If your computer has become... Read More

    CRM 101: Customer Relationship Management for Beginners

    Customer Relationship Management, abbreviated "CRM," is the term for a... Read More

    Microsoft Great Plains: Government & Non-Profit Organization ? Workflow Implementation

    Usually workflow & messaging is realized in CRM and then... Read More

    Five Steps to Rapid Development with TierDeveloper 4.0

    Follow the steps below to quickly design, generate, and deploy... Read More

    The Bluebird Project

    The objective for Zandi Digital is to make available clever... Read More

    ERP for Large Corporation ? New Selling Strategy

    Our opinion is based on our Microsoft Business Solutions Great... Read More

    Professional Software Icons For Your Standalone Application

    User interfaces and accessibility are some of the most important... Read More

    Basic Steps To Optimize Your Internet Security

    After seeing many people complain about their weak Internet security... Read More

    Do You Know These Facts About Spyware ?

    Imagine something that follows you home and sets itself up... Read More

    Imagine if Everyone Working In Your Office Was In Synch?

    Microsoft-Outlook is a pretty amazing program. So much more than... Read More

    Algebra Help Software

    Need help making sense of algebra? Have algebra lectures in... Read More

    Great Plains Custom Development: Dexterity, VBA, SQL, Crystal, eConnect ? Overview For Programmer

    Microsoft Great Plains is main Microsoft Business Solutions accounting package... Read More

    Causes of ERP Failures

    ERP is the acronym of Enterprise Resource Planning. Multi-module ERP... Read More

    Unwanted Files

    A LOT OF UNWANTED FILES.When you uninstall an item of... Read More

    Microsoft CRM Customization Secrets ? Second Edition

    This article is for advanced Microsoft CRM SDK C# developers.... Read More

    What You Must Know About Spyware Right Now

    Spyware is like the new technological nuclear weapon on the... Read More

    A Case Study on Selecting Contract Management Software

    Professional services firm cuts costs and improves productivity with integrated... Read More

    Microsoft Great Plains Implementation ? Overview for IT Director/Controller

    What is installation in the language of technology? Installation... Read More

    Microsoft Great Plains Integration Manager ? Working With Text File

    Microsoft Business Solutions main middle market ERP application - Microsoft... Read More

    Document Templates Give You The Perfect Framework For Your Documents

    When it comes to running an office, the SOHO entrepreneur... Read More

    Computer Phones ? Facts and Fallacies

    The stakes are high when considering security, privacy, and savings,... Read More

    Running a Program on a Remote Server Using SSH

    How do you run a program on a remote server... Read More

    An Easy Way to Develop JAVA Enterprise Applications

    Research bears that less than 70 percent of development projects... Read More

    Bill of Lading ? Custom Reporting for Microsoft Great Plains ? Overview for Consultant

    Bill of Lading is required report for Logistics and Freight... Read More

    How to Make Attractive and Effective PowerPoint Presentations

    Microsoft PowerPoint has dramatically changed the way in which academic... Read More

    Industry Experts Answer the One Million-dollar Question - Why Genie Backup Manager?

    Many reasons made GBM a unanimous choice for experts, one... Read More

    What to Do if All Screensavers Fun is Grayed Out?

    Finally, you have some time to personalize your desktop with... Read More

    Microsoft Great Plains: Data Conversion & Migration Scenarios ? Overview for Consultant

    Microsoft Business Solutions Great Plains serves multiple industries in the... Read More

    CROOK: A Methodology for the Refinement of Forward-Error Correction

    Table of Contents1) Introduction 2) Related Work 3) Framework 4)... Read More

    New SQL Delta Version 3.1

    COMMAND LINE FUNCTIONA powerful command line script processor has been... Read More

    eCommerce development for Microsoft Great Plains: tools and highlights for programmer

    Microsoft Business Solutions Great Plains, former Great Plains Software Dynamics... Read More

    Spyware, What is it?

    Spyware, what it is and what it does. Basically, spyware... Read More

    Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

    In this small article we will be looking at the... Read More