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:

    Miranda To Buy TV Software Maker OmniBus For C$48.7M >MRTKF
    Wall Street Journal
    T) has agreed to acquire OmniBus Systems Ltd., a maker of television broadcast software, from private-equity firm Palamon Capital Partners for C$48.7 ...
    Miranda Technologies Acquires IT-Based Playout Pioneer OmniBus SystemsMarketWatch (press release)

    all 35 news articles »


    VirtualLogix VLX(TM) Virtualization Software Now Integrates with Cortex A15 ...
    MarketWatch (press release)
    The VLX virtualization software, in combination with the ARM Cortex A15, will enable silicon vendors and mobile device manufacturers to develop ...
    Red Bend Buys VirtualLogix for Mobile VirtualizationPC World
    Red Bend acquires mobile virtualization firmRethink Wireless
    Red Bend Buys VirtualLogixXconomy
    Bizjournals.com -Globes
    all 43 news articles »


    Daily Mail

    Hackers say they can “jailbreak” iPhone 4.1 software
    VentureBeat
    Less than a day after Apple released its iOS 4.1 operating system, hackers say they have jailbroken the software for the iPhone 4. In doing so, hackers have ...
    Apple's iOS 4.1 software update for iPhone, iPod Touch arrivesUSA Today
    Apple's iOS 4.1 software update out nowV3.co.uk
    iOS 4.1 Software Update Now Available for DownloadTouch Reviews
    ZDNet UK -ADI News (blog) -Softpedia
    all 1,065 news articles »


    Kansas City Star

    Q&A: How Randy Pitchford Saved Duke Nukem Forever
    Wired News
    Randy Pitchford, CEO of Gearbox Software, bought the rights to the troubled Duke Nukem videogame franchise. SEATTLE — Think you're excited ...
    Aliens: Colonial Marines Still Under DevelopmentPlayStation LifeStyle (blog)

    all 49 news articles »


    UK Broadcaster Adopts Adobe Premiere Pro CS5 Software
    MarketWatch (press release)
    The corporation launched the Creative Desktop Initiative in 2007, and is now implementing an additional 2000 seats of Adobe Premiere Pro CS5 software as the ...

    and more »


    SailPoint Signs International Reseller Agreement with BMC Software
    MarketWatch (press release)
    AUSTIN, Texas, Sept 08, 2010 /PRNewswire via COMTEX/ -- SailPoint today announced a global reseller agreement with BMC Software that allows BMC to directly ...

    and more »


    CNET

    Samsung Uses Google's Free Android Software, Blocks Google Search (GOOG, MSFT, VZ)
    San Francisco Chronicle
    Samsung's newest phone, the Fascinate, runs Google's Android software, but it doesn't have Google search on it. Moreover, Google Search widget in the ...
    Verizon bets big at the CRAPPS tableGotta Be Mobile (blog)

    all 309 news articles »


    Streamline Health(R) Solutions Reports Q2 Results
    MarketWatch (press release)
    The results for the quarter were impacted by a $25000 decrease in professional services revenues and a $62000 decrease in hardware and third-party software ...
    Streamline Healthcare sees bigger Q2 lossCincinnati.com
    Hospital adds Streamline productCincinnati.com

    all 56 news articles »


    Managing Automation Magazine

    CDC Software Announces Availability of New Product Lifecycle Management ...
    MarketWatch (press release)
    Leveraging a service-oriented architecture (SOA), CDC Software offers multiple delivery options for their solutions including on-premise, hosted, ...
    CDC Adds PLM to ERP OfferingManaging Automation Magazine

    all 16 news articles »


    New Set-Top Boxes With DVR-Like Features Enabled by NDS Software and SanDisk ...
    MarketWatch (press release)
    "The successful integration of SanDisk P4 SSD with NDS STB software enables new business models in the STB market, and takes Video on Demand content beyond ...

    and more »

    Google News

    home | site map
    © 2006