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


    Make or Break Factors - When Considering Estimating Software

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

    Great Plains Dynamics on Pervasive/Ctree support ? overview for consultant

    All of us know that Microsoft bought former Great Plains... Read More

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

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

    Backing Up And Restoring Your MySQL Database

    If you've been using MySQL database to store your important... Read More

    Microsoft CRM ? Consulting in the Post-Recession Time

    New post-recession era has new features, which didn't exist in... Read More

    The Bluebird Project

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

    Microsoft Great Plains Upgrade ? Things to Consider and FAQ

    If you have Microsoft Great Plains and support it for... Read More

    Microsoft Great Plains implementation: Restaurants Supply Chain Management Example

    Microsoft Great Plains serves majority of US based horizontal and... Read More

    Passwords Used In Microsoft Word Documents

    You would like to protect your documents, wouldn't you? Reasons... Read More

    Cisco Certification: Introduction To ISDN, Part V

    The major reason I recommend getting your hands on real... Read More

    Cisco Certification: Five Things To Do DURING Your CCNA Exam

    There are plenty of articles out there about how to... Read More

    Why Java RDBMS?

    It is a well known fact that Java as a... 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

    Microsoft Blues

    With the advent of 'Service Pack 2' for Windows XP... Read More

    Groupware Finds Home in American Business: Collaboration Tool Analysis

    What is Groupware?Have you ever had to manage document collaboration... Read More

    Lotus Domino Implementation and Development: Infrastructure ? Present and Future

    Domino server is a buffer between the operation system and... Read More

    Great Plains Dexterity Programming ? Overview For Developer

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

    Is Software Tester a Most Infamous Person in a Software Project Team?

    The fact that a software tester is a most infamous... Read More

    Microsoft Axapta, Navision or Great Plains: ERP Selection for Large Corporation

    If you would like to pick something from Microsoft, or... Read More

    ERP Software Financing: the Future? ? Overview for Company Owner

    In our case ? we serve Microsoft Business Solutions ERP... Read More

    Lotus Domino/Notes - Microsoft Great Plains Tandem as ERP with Documents Workflow - Overview for IT

    Lotus Domino/Notes ? Microsoft Great Plains tandem as ERP with... Read More

    Spyware, What is it?

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

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

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

    The Tools and Features of Adobe Photoshop

    Adobe Photoshop is one of the world's leading graphics editing... Read More

    Preventive Maintenance Software Companies

    Several software companies design programs for preventive maintenance. Most of... Read More

    What is Fleet Maintenance Software?

    Simply put, fleet maintenance allows companies to monitor and maintain... Read More

    Microsoft Great Plains Customization: Project Organization ? International Business Example

    Microsoft Business Solutions Great Plains fits to majority of horizontal... Read More

    Microsoft CRM USA Nationwide Remote Support

    Remember old good days when your company probably had Great... Read More

    Microsoft Business Solutions Customization Options - Overview for Programmer

    Several years ago Microsoft purchased Great Plains Software, then Navision... Read More

    Microsoft Great Plains ? Licensing & Product Versions

    Current Microsoft Business Solutions Great Plains has more that 10... Read More

    Microsoft eCommerce Web-development: Great Plains eConnect .Net ? Highlights for Programmer

    In our small article we'll consider Microsoft Business Solutions Great... 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

    An Easy Way to Develop JAVA Enterprise Applications

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