Software Information

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.


    MORE RESOURCES:

    Scott Tomlinson Joins Cypress Software Systems as Vice President ...
    MarketWatch - 1 hour ago
    "His extensive banking background and familiarity with our products will be indispensable as we introduce new clients to our software solutions, ...


    Rally Software Names Jim Lejeal as Chief Financial Officer
    MarketWatch - 3 hours ago
    "I've worked with Jim and his companies for more than 10 years and have the utmost confidence in his ability to successfully lead software and SaaS ...


    NewsOXY

    DVD Ripping Flourishes
    PC World - 4 hours ago
    Illegal DVD-ripping software is flourishing, despite well-publicized wins by DVD piracy foes and laws against copying Hollywood movies. ...
    Real Offers Legal but Limited DVD-Ripping Software E-Commerce Times
    Real Introduces RealDVD Ripping Software Laptop Logic
    DVD ripping goes legit with RealDVD CNET News
    eFluxMedia - Los Angeles Times
    all 94 news articles


    New Enterprise Associates invests $10M in Tableau Software
    Bizjournals.com, NC - 1 hour ago
    Seattle-based Tableau makes analytics and visualization software. The money will be used for “new product development and sales channel expansion," the ...


    Sage Software Announces Sage FAS Fixed Assets Version 2008.2 Now ...
    MarketWatch - 1 hour ago
    HERNDON, VA, Sep 08, 2008 (MARKET WIRE via COMTEX) -- Sage Software announced today the general availability of Sage FAS Fixed Assets version 2008.2 for the ...


    Proposal Software, Inc. Introduces Revolutionary New Search ...
    MarketWatch - 7 hours ago
    Proposal Software Inc. (PSI) provides the best-in-class comprehensive proposal management platform. PMAPS(R) is in use by over 200 leading financial ...


    Tectura Signs Agreement With Boeing to Develop Airline Software ...
    Market Wire (press release) - 6 hours ago
    The software license agreement allows Tectura to use Boeing's Software Development Kits (SDKs) to develop airborne applications for both the Electronic ...


    Hidd Power Company Selects InStep's eDNA Historian Software
    MarketWatch - 2 hours ago
    William King, Hidd Production Director, says, "The eDNA software will be used to support key operational decisions we make at Hidd which are responsible for ...


    Omnify Software to Host Fifth Annual Customer Conference
    MarketWatch - 6 hours ago
    ANDOVER, MA, Sep 08, 2008 (MARKET WIRE via COMTEX) -- Omnify Software, a leading provider of Product Lifecycle Management (PLM) software for electronic, ...


    Northside ISD adopts financial management software to keep pace ...
    Bizjournals.com, NC - 2 hours ago
    Northside Independent School District awarded Tyler Technologies Inc. a $4.9 million contract to implement its enterprise resource planning software ...
    Tyler Technologies (TYL) Wins $4.9M Contract with San Antonio's ... StreetInsider.com (subscription)
    all 11 news articles

    Software - Google News

    home | site map
    © 2006