Microsoft Dynamics GP ERP application fits to majority of US businesses and due to the fact that it resides in Microsoft SQL Server it is open to the whole range of Reports design tools: Crystal Reports, Microsoft SQL Server Reporting Services, Cognos, MS Access, MS Excel

If you are looking for implementing financial reporting, such as Balance Sheet, Profit and Loss Statement, Statement of Cash Flow ? then your tool of choice is actually FRx reports.  In this small publication we will try to cover Crystal Reports niche and design scenarios

1.       Special Industry documents.  If you need something that belongs to your vertical niche, like special format of Bill of Lading and you believe that you can produce this document from Great Plains Sales Order Processing and Inventory Control modules tables.  In this case Crystal does wonderful job

2.       Heterogeneous database queries.  If you data resides in non Microsoft databases, such as Oracle, DB2, MySQL, Btrieve, Ctree, Lotu