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


    Document Templates Give You The Perfect Framework For Your Documents

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

    Microsoft Great Plains: carpet, textile, fabric, felt distributor ? implementation overview

    In this small article we will show you the possible... Read More

    Microsoft Great Plains Implementation in Russia ? Overview for Consultant

    Microsoft Business Solutions Great Plains is very popular ERP platform... Read More

    Will Adobe Manage to Replace Industry Work Horse Quark Express by Giving Adobe InDesign for Free?

    And kill the best layout software in the process of... Read More

    OLAP, An Alternative Technology Over Spreadsheets

    Are Spreadsheets Robbing your Enterprise of Competitive Advantage?'90% of "average"... Read More

    Reloading Windows XP

    If you have been running Windows XP for a couple... Read More

    Did You Ever Want to Completely Erase Everything on Your Computer?

    Did you ever want to erase everything on your computer?... Read More

    Reduce TCO: The Java Database Way

    TCO (Total Cost Ownership) is the buzzword in... Read More

    Managing Stress in the Computer Industry - Five Steps to a Stress-free Life

    It would be easy to think, like most people apparently... Read More

    Blind CC (Bcc): Master Its Use When E-Mailing

    If you use Microsoft Outlook (or similar applications) for e-mailing,... Read More

    Destination: Desktop for Google

    First we had the original Google search that evolved into... Read More

    Increase Office Efficiency With One Simple Tool

    When you need a phone number, you do a quick... Read More

    Microsoft Great Plains in Construction & Building ? Implementation & Customization Highlights

    Microsoft Great Plains could be tuned and setup to fit... Read More

    Getting Technical Support Help Online

    Sometimes your PC will start acting strange for no apparent... Read More

    Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve ? Tips For Developer

    Crystal Reports is the most flexible tool on the market... Read More

    Most Common Ways to Accumulate Spyware (where It is Downloaded to Your PC)

    It is possible that if one avoided all sources of... Read More

    Put Some Pizazz in Your Software Arsenal

    The software giants don't do everything and don't always produce... Read More

    The Secret of the Layer Styles Dialogue

    When you double-click a layer in the Layer Palette, you... Read More

    The Religion And Philosophy Of Small Internet Business

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

    Popular Fleet Maintenance Programs

    Some companies that are in need of fleet management may... Read More

    Corporate ERP Selection: Microsoft Great Plains

    In our opinion, traditional approach when you select ERP/MRP system... Read More

    Downloading Spyware Removers: Think Before, not After

    Just imagine: you are walking, say, towards your car, and... Read More

    Professional XP Style Icons in Software and Website Development

    Using professional icons in your application or website can bring... Read More

    Collaboration Software: Index of Collaboration Software Technologies

    Collaboration SoftwareCollaboration Software, also known as group collaboration software or... 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

    How To Identify, Cure and Prevent Spyware/Adware Infections

    Just when you thought you were Web savvy, one more... Read More

    Cross-Platform Custom Software Development & Integration ? IT Strategy for Large Corporation

    Microsoft Business Solutions products: Great Plains, MS CRM, Navision, Axapta,... Read More

    Demand More From Your Lead Tracking Software

    An integral part of any quality CRM system is lead... Read More

    How to Build a Basic CSS Layout

    Designing without tables by using CSS layouts is fast becoming... Read More

    Microsoft CRM Messaging through Lotus Domino eMail Server - Balanced Solution

    Microsoft CRM and IBM Lotus Notes Domino seem to be... Read More

    The Bluebird Project

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

    Why do Manufacturers Invest in Business Management Software?

    With many manufacturing shops heading over seas in favor of... Read More

    Microsoft Great Plains Implementation for Midsize & Large Corporation: Lockbox Processing

    Microsoft Great Plains is now targeting large and midsize businesses... Read More