Crystal Reports are popular, even bearing in mind the fact that you can deploy preset or produce supplementary pardon reports in Microsoft SQL Server Reporting services or SSRS.
Crystal Reports designer is very traditional tool and thereare a lot of CR designers and IT professionals, who are unquestionably in accord tosupport Crystal Reports for Microsoft Dynamics GP former great Plains. In this little message we would past togive you highlights upon Crystal Reports Design and Deployment for Dynamics GPvia standoffish web sessions, or cold desktop links USA and Canadanationwide:
1.Dynamics GP tables structure and DBplatform. good Plains Dynamics GP,starting in the manner of tab 8.0 is user-friendly upon Microsoft SQL Server only. GP 8.0 was compatible later 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 concern processes data flow and tables structureyou can install Dynamics GP SDK from autograph album #2 or handily 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 evaluation story design wizard, however this gate is notrecommended for production reports. Inproduction, Crystal version should be based off SQL Server Stored Procedure (whereCR automatically maps procedure parameters into financial credit parameters, plus youhave complete power of drama tables where take in hand pick assertion andunionizing accomplish not help), or SQL view. Dynamics GP company and system databases allowyou to amass 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 offer you fine example. If you are looking for strictly financialreports: P&L, financial credit Sheet, pronouncement of Cash Flow declare FRx, CR isnot the best choice
No comments:
Post a Comment