Dynamics,Partner,Newsflash,Cry computer Dynamics GP Partner Newsflash: Crystal Reports for Great Pla
----------------------------------------------------------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 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
Crystal Reports designer is very traditional tool and thereare a lot of CR designers and IT professionals, who are very comfortable tosupport Crystal Reports for Microsoft Dynamics GP former Great Plains. In this small publication we would like togive you highlights on Crystal Reports Design and Deployment for Dynamics GPvia remote web sessions, or remote desktop connections USA and Canadanationwide: 1. Dynamics GP tables structure and DBplatform. Great Plains Dynamics GP,starting with version 8.0 is available on Microsoft SQL Server only. GP 8.0 was compatible with SQL 2000 (or MSDE)and GP 9.0 and 10.0 is compatible with both: Microsoft SQL Server 2000/MSDE andMicrosoft SQL Server 2005/MS SQL Express. To review Dynamics GP business processes data flow and tables structureyou can install Dynamics GP SDK from CD #2 or simply look the structure in GPinterface: Dynamics GP->Tools->ResourceDescription->Tables/Forms/Fields 2. Dynamics GP Crystal Reports design bestpractices. If you are making first stepswith CR, you should review report design wizard, however this approach is notrecommended for production reports. Inproduction, Crystal Report should be based off SQL Server Stored Procedure (whereCR automatically maps procedure parameters into report parameters, plus youhave unlimited power of temporary tables where direct select statement andunionizing do not help), or SQL view. Dynamics GP company and system databases allowyou to add custom objects, such as SQL stored procedure or custom SQL view 3. Crystal Reports niche. In Great Plains Dynamics GP you typicallydeploy Crystal Reports where you are building industry specific reports: Salesby product/salesperson/region/class, to give you good example. If you are looking for strictly financialreports: P&L, Balance Sheet, Statement of Cash Flow consider FRx, CR isnot the best choice
Dynamics,Partner,Newsflash,Cry