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


    Partitioning, Formatting and Reinstalling in Windows 98

    Formatting and reinstalling windows 98 is very easy if you... Read More

    Call Alert Notifications - Free Answering Machine Software for PCs

    If you're online using a dialup Internet connection, you'll probably... Read More

    Cisco Certification: Introduction To ISDN, Part V

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

    6 Easy Steps for a Smoother CD/DVD Order

    It's all about turn times in the eMedia industry! The... Read More

    Reloading Windows XP

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

    Easy Guide to RAID Recovery

    What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... Read More

    .Net Charts and Graphs Interact with Businesses and Customers

    Bar charts, bar graphs, and any other chart or graph... Read More

    Great Plains Dexterity History and Programming Overview

    As of now - Great Plains Dynamics/eEnterprise is transformed/renamed into... Read More

    What is Preventive Maintenance Software?

    Preventive Maintenance (PM) is defined as scheduled work done on... Read More

    Not All Project Management Software is Created Equal

    The purpose of Project Management Software is to provide an... 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

    Know-how in Microsoft Publisher

    For those who still don't know, Microsoft Publisher helps computer... Read More

    Software Engineering: An Introduction

    Software Engineering is the Systematic Approach for analysis design implementation... Read More

    A Guide To Purchasing Professional XP Icons Online And Enhancing Your Applications

    Icons are used everywhere; right from software applications, to internet... Read More

    Microsoft CRM Data Import FAQ

    Microsoft CRM has built-in conversion tool, however you should probably... 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

    Lotus Notes Domino and Web: Application Development ? Tips for Programmers

    Beginning with Domino version R4 it has integration with the... Read More

    Software Process Improvement -A Successful Journey

    Background: For many organizations like ours, the interim target of... Read More

    Groupware: Avoid the Ad Hoc Shuffle

    GroupwareEfforts are continually made to manage the unavoidable ad hoc... Read More

    Microsoft Retail Management System (RMS) SQL Customization ? Overview for Programmer

    Microsoft Retail Management System serves retail single store as well... Read More

    Hubris - Definition: Microsofts Passport

    Before September of 1995, Microsoft ignored the Internet because their... Read More

    Microsoft Great Plains Integration Manager ? Advanced Techniques

    Great Plains Integration Manager scripting and translation - overview for... Read More

    ERP Implementation: Success Factors

    As seeing large number of implementations ? in our case... Read More

    Linux for Home Users

    Hey Guys! Don't raise your eyebrows or fear by hearing... Read More

    Microsoft Great Plains e-Commerce ? additional considerations for programmer

    Microsoft Great Plains, designed back in 1990th as database transferable... Read More

    Great Plains Dexterity Programming ? Overview For Developer

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

    Theres Gold in Your Websites Server Log

    Many Webmasters have never bothered to view their website's server... Read More

    Demand More From Your Lead Tracking Software

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

    The Tools and Features of Adobe Photoshop

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

    How to Make Attractive and Effective PowerPoint Presentations

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

    Accounts Payable: A Powerful Document Management and Workflow Solution

    Accounts payable is just one area of office management where... Read More

    Oracle Development: JDeveloper 10G ? Java, J2EE, EJB, MVC, XML - Overview For Programmer

    In 2004 Oracle, Inc. made its new step toward J2EE... Read More

    Explore the Internet in a Whole New Way

    For a long time now Microsoft's Internet Explorer has ruled... Read More