Great,Plains,Reports,Design,Cr computer Great Plains Reports Design: Crystal, SRS, MS Access, Excel,
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
This tool, essentially coming often free with the purchase of MS SQL Server license turned to become very efficient competitor to such traditional generic reports design tool as Crystal Reports. Lets review reporting tools in brief, following the rules of small article genre:1. SRS. The nicety of this tool, coming with Microsoft SQL Server 2005 or 2000 is native web interface. You should be familiar with Microsoft Visual Studio to design SRS reports. However as it is the case with its rival Crystal Reports, if you are facing the requirements to design really powerful and flexible report, you should consider first creating the SQL stored procedure or view, which will serve as report query foundation2. Crystal Reports. We expect that article reader audience has experienced reports designers, who are typically familiar and comfortable with Crystal Reports. CR designer is a bit more natural and intuitive in comparison to Visual Studio interface (as in the case of SRS). One of the drawbacks for CR is the requirement to purchase separate Crystal licenses3. MS Access. This tool is typically found in use, when you are dealing with legacy reports for older GP version and you are facing the requirements to upgrade them, meaning keep them as they are and have them just still work for new Great Plains version. You as MS Access programmer should be familiar with VBA scripting, ODBC connection and some SQL selection statements4. Excel. Microsoft Excel also supports VBA modifications, and in this sense it is similar to mentioned above MS Access. In Excel you can also pursue Data Mining and Data Warehousing with GP database Pivot Tables5. Report Writer. This tool you deploy when you modify existing GP reports: SOP blank invoice form is the most popular. Modified reports are immediately available for GP users they are stored in shared or local Report.dic file6. Dex custom reports. They would be similar to RW, described above, however in Dexterity you virtually have no limits on what you can do with Great Plains alternative business logic. With one caution Dexterity developers are not easy to find on the job market, however you can hire GP ISV partner to help you with Dex coding7. FRx. This tool does financial reporting: P&L, Balance Sheet, Cash Flow, plus consolidated reporting (Reporting Tree allows you to choose companies or account segments for consolidation)
Great,Plains,Reports,Design,Cr