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


    Separate Anti-Keylogging Protection: Who Needs it Most?

    If there still are few unprotected computers left, I haven't... Read More

    Five Tips For A Great Software Demo

    Whether you need to close a sale, gather end-user feedback,... Read More

    Implementing ERP for Large Publicly Traded Corporation ? Microsoft Great Plains

    We would like first emphasize the change in the paradigm.... Read More

    The Religion And Philosophy Of Small Internet Business

    I have always had a tendency to focus on the... Read More

    A Symons Mark II Function Point Counting Example

    I provide, here clear explanations and a count of function... Read More

    Instant Messaging is a Sweet Way to Communicate

    MSN messenger is a pretty cool invention. I mean I'm... Read More

    Falling in Love With More Than One Screensaver: The Fun Part

    Having from five to ten and more favorite screensavers is... Read More

    How to Get The Best Accounting Software For Your Small Business

    Buying accounting software is a major investment. It's an important... Read More

    Microsoft CRM Integration with Microsoft Retail Management System (RMS) ? Overview

    Microsoft Client Relation Management system (Microsoft CRM) and Microsoft RMS... Read More

    Microsoft CRM Data Conversion FAQ

    Microsoft Business Solutions CRM data conversion deserves FAQ type of... Read More

    CRM 101: Customer Relationship Management for Beginners

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

    The Software 2005 Conference - A Review

    The Software 2005 conference is now a wrap. This conference,... Read More

    Document Templates Give You The Perfect Framework For Your Documents

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

    Review of TikiWiki Content Management System

    TikiWiki is open source software - it is written in... Read More

    Begun, The Browser Wars Have

    As Mozilla Firefox nears 10% market share, with well over... Read More

    MultiNational Corporation ERP Implementation ? Microsoft Business Solutions Great Plains

    If you look back to the history, you will see... Read More

    Does Microsoft have any real competition?

    Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory... Read More

    How to Choose the BEST Charting Software

    I suggest that you do not spend a lot of... Read More

    Google Brings the Earth to Your Desktop

    Google Inc. has launched a new software package that allows... Read More

    Software Tools To Help Your Business Sell More

    Sales are all about leverage, because there is only so... Read More

    Microsoft Great Plains eCommerce: overview for developer

    Microsoft Business Solutions Great Plains was designed back in the... Read More

    Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ? ReportWriter ? Tips for Developer

    Microsoft Business Solutions Great Plains is written in Great Plains... Read More

    Groupware: What Works the Way Businesses Do?

    GroupwareThe internet is full of 1.5 million to 7 million... Read More

    Microsoft Great Plains Partner Selection: Overview

    Microsoft Great Plains, Navision, Solomon and Axapta are Microsoft Business... Read More

    Configure Windows Indexing Service for Performance

    The Windows Indexing Service provides you with the ability to... Read More

    Great Plains Dynamics/eEnterprise Upgrade ? Things to Consider and FAQ

    If you have Great Plains Dynamics/eEnterprise (version 6.0 or earlier)... Read More

    IT Strategy for Large Corporation: ERP/MRP/CRM, Unix/Linux/Windows, Microsoft/Java

    Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business... Read More

    S is for Spying, Surveillance -- and for Software as Well

    Words we choose to describe things and phenomena often show... Read More

    Putting Screensavers Under Control

    No matter how much you enjoy your favorite screensavers, sometimes... Read More

    Navision Attain Database access via C/ODBC in ASP.NET Application

    Navision Software was purchased by Microsoft and now it is... Read More

    Can Group Collaboration Software Meet Business Needs?

    According to a survey conducted by InfoTrends/CAP Ventures entitled "Content-Centric... Read More

    Alien Intruders!

    You probably didn't casually invite, or extend a formal attendance... Read More

    Make or Break Factors - When Considering Estimating Software

    Make-or-Break Factors in Success and ProfitabilityFor quick printers, estimating can... Read More