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:

    This RSS feed URL is deprecated, please update. New URLs can be found in the footers at

    The Verge

    AI software helped NASA dream up this spider-like interplanetary lander
    The Verge
    Using an AI design process, engineers at software company Autodesk and NASA's Jet Propulsion Laboratory came up with a new interplanetary lander concept that could explore distant moons like Europa and Enceladus. Its slim design weighs less than ...
    Autodesk Teams Up with NASA's Jet Propulsion Laboratory to Explore New Approaches to Designing ... - Autodesk NewsAutodesk News

    all 12 news articles »


    FAA, Boeing study the need for 737 MAX software changes after Lion Air crash
    The U.S. Federal Aviation Administration and Boeing are evaluating the need for software or design changes to 737 MAX jets in the wake of last month's deadly Lion Air crash in Indonesia, the regulator said on Tuesday. Boeing shares fell 2.1 percent on ...
    Boeing, FAA weigh software fix on 737 Max plane after crashCrain's Chicago Business
    FAA, Boeing study need for 737 MAX software changes after crashReuters
    Boeing, US Regulator Weigh Software Fix on 737 Max After CrashBloomberg
    Channel NewsAsia
    all 658 news articles »


    'Software robot' startup UiPath expands Series C to $265M at a $3B valuation
    UiPath, a startup that works in the growing area of RPA, or robotic process automation — where AI-based software is used to help businesses run repetitive or mundane back-office tasks, to free up humans to tackle more sophisticated work — has raised ...

    and more »

    A framework for secure software
    The Business Software Alliance is creating a framework policymakers can use to develop rules and legislation related to software security, according to Tommy Ross, BSA's senior director of policy. The International Cybersecurity Policy Framework is ...

    Adoption of HR onboarding software accelerating, says one study
    When Accenture PLC installed an onboarding system in 2009, there weren't many HR onboarding software tools or users in enterprise businesses. "There were not many options out there. There weren't even many people doing it, and we were one of the first ...

    Wall Street Journal

    Amazon, Google Poised for Race to Hire High-Tech Talent
    Wall Street Journal
    Of the more than 42,000 jobs Amazon listed, the highest concentration were in three occupations—software-development engineers, software-development managers and so-called solutions architects. Among the 14,000 jobs Google posted over the same ...
    How Google Protected Andy Rubin, the 'Father of Android'New York Times
    Google Executive on Company Walkout, Sexual Misconduct PoliciesWall Street Journal
    Square, Airbnb And eBay Just Said They Would End Forced Arbitration For Sexual Harassment ClaimsBuzzFeed News
    Wall Street Journal -CNNMoney
    all 34 news articles »


    Enterprise Software Acquisition Surges
    Earlier this week, private equity firm Vista Equity Partners announced that it was buying Apptio for $1.94 billion and SAP announced that it was purchasing Qualtrics for $8 billion. These acquisitions are just the latest in a recent series of ...

    MapR Seeks Advantage From Cloudera-Hortonworks Merger With New Software Release, Data Assessment Service
    The software offers a common data management, security and protection model for uniform data governance – data security and management are not based on data type or access method, according to the company. Those capabilities extend to edge ...


    7 Multi-Billion-Dollar Software Deals This Year
    On Sunday, German software industry giant SAP announced that it was acquiring Utah-based cloud unicorn Qualtrics just before its highly anticipated initial public offering (IPO). The $8 billion all-cash deal, slated to close in the first half of 2019 ...
    SAP joins a growing list of software giants making big acquisitions in 2018: Here's a full rundownCNBC

    all 11 news articles »


    Three Steps To Take Before You Commit To A Marketing Automation Software
    The decision is already made. You are dead set on the [fill in the blank] marketing automation software. You've heard plenty of good things about it this conference season. Its tech is so advanced, it's leading edge. Now you're telling everyone it's ...

    Google News

    Microsoft Blues

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

    Basic Tips and tricks for Windows XP

    Running Applications in Compatibility Mode With Windows XP, you can... Read More

    Introducing GRML

    Creating a new markup language.Introduction.General Reuse Markup Langauge, or GRML,... 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

    Brand Your Websites URL With a Favicon

    Have you ever noticed that when you look at your... Read More

    Microsoft Great Plains Security Setup - Overview For Consultant

    Microsoft Business Solutions Great Plains is very good fit for... Read More

    5 Time-Saving Tips in Microsoft Word

    Whether you have used Microsoft Word for years, have just... Read More

    Save Your Resources - Combine Your IM Clients

    There are so many different programs that clutter up your... Read More

    Programming Environments And The Software Production Process

    Introduction: The creating of a computer program involves a number... Read More

    Where to Find Free Fleet Maintenance Software

    Costs of fleet maintenance software can vary widely. It is... Read More

    Corporate ERP: Microsoft Great Plains For The Plant In Brazil ? Overview For CIO

    Microsoft Business Solutions Great Plains as new ERP for multinational... Read More

    Microsoft Moves to Small Business Accounting/Retail Market ? Stakes and Thoughts

    In this small article we will be looking at the... Read More

    Beware of The Pirated Software E-Mail Scams!

    You have gotten those E_Mails buy software at deep discounts.... Read More

    Microsoft Great Plains: Annual Enhancement Program ? How To Be Re-Enrolled

    Microsoft Business Solutions Great Plains is mid and even corporate... Read More

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

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

    Microsoft CRM Implementation & Remote Support

    We would like to give you pluses and minuses of... Read More

    What Stands Behind The Software Description?

    With thousands of web pages added to the Net every... Read More

    Popular Fleet Maintenance Programs

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

    How to Tell You Have Spyware, Ad-ware or Viruses

    Usually, the easiest way to tell you have spyware is... Read More

    A Simple Guide To Wikis

    A wiki is an editable text-based website. But you don't... Read More

    C++ Tutorials: 3, Program Flow (If, Else, While, For)

    Program Flow is what you think it is. How the... Read More

    Easy Guide to RAID Recovery

    What is RAID RECOVERY?RAID stands for Redundant Array of Inexpensive... 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

    Making The Decision To Automate Your Software Testing

    Not every software testing project can or should be automated.... Read More

    Groupware as a Document Manager: Collaboration Series #3

    This article is the third of a series of articles... Read More