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! [email protected]

    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 (, he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer.

    In The News:

    Nutanix, VMware Battle For HCI Software Market Share Lead  CRN: Technology news for channel partners and solution providers
    Govt amends VAHAN software  The Tribune India

    OS 101: Suggestions for Choosing an Operating System

    An operating system (abbreviated OS) is essentially the path through... Read More

    Document Templates Give You The Perfect Framework For Your Documents

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

    Separate Anti-Keylogging Protection: Who Needs it Most?

    If there still are few unprotected computers left, I haven't... 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

    SyncUp ? A File/Folder Synchronizer For Windows

    SyncUp, a file synchronizer is designed to assist the home... Read More

    Microsoft Great Plains - Payroll & HR Inexpensive Solution? Not Any More

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

    What You Should Know About Installing Screensavers

    Do you remember that frustrating feeling when you find an... Read More

    Microsoft Great Plains Middle East - Arabic Language Support

    Microsoft Business Solutions Great Plains is marketed for mid-size companies... Read More

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

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

    Fleet Maintenance Software Reviews

    Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More

    Database Guru James F. Koopmann Reviews DBxtra Reporting and Query Tool

    DBxtra is a powerful query and reporting tool that hides... Read More

    SpyBot - Search and Destroy versus Microsoft AntiSpyware (Beta).... My personal experiences...

    Ok... Where to start?Well, I guess I will start at... Read More

    MCP Market News: Microsoft SQL Server & SQL Reporting Services

    Are you ready? SQL Server 2005, the next-generation data management... Read More

    5 Mac Security Tips You Can?t Live Without

    So, you've bought a new Macintosh, and now you may... Read More

    Microsoft Great Plains Reporting ? Overview for Developer

    Looks like Microsoft Great Plains becomes more and more... Read More

    A Case Study on Selecting Contract Management Software

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

    Why Stick With Email Clients Like Outlook?

    Trying to figure out a stream in banning one email... 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

    Begun, The Browser Wars Have

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

    Looking for an Alternative to Microsoft Office? You Should Be!

    Now is the time to look at an alternative to... Read More

    How To Choose A Fire Wall Software Program

    In the real world a "fire wall" is a fireproof... Read More

    String in Java

    Handling character strings in Java is supported through two final... Read More

    5 Easy File Management Tips in Microsoft Word

    How many steps does it take you to locate and... Read More

    Software Review: Xsitepro Total Site Management Software

    It's not very often I get excited about a software... Read More

    Tripwire for Linux File Integrity

    What is Tripwire?Tripwire is a form intrusion detection system (IDS)... Read More