Crystal Reports are popular, even later the fact that you can deploy preset or develop other release reports in Microsoft SQL Server Reporting services or SSRS.
Crystal Reports designer is utterly customary tool and thereare a lot of CR designers and IT professionals, who are entirely acceptable tosupport Crystal Reports for Microsoft Dynamics GP former good Plains. In this little declaration we would as soon as togive you highlights upon Crystal Reports Design and Deployment for Dynamics GPvia snobbish web sessions, or unfriendly desktop connections USA and Canadanationwide:
1.Dynamics GP tables structure and DBplatform. great Plains Dynamics GP,starting behind bank account 8.0 is user-friendly upon Microsoft SQL Server only. GP 8.0 was compatible with SQL 2000 (or MSDE)and GP 9.0 and 10.0 is compatible subsequently both: Microsoft SQL Server 2000/MSDE andMicrosoft SQL Server 2005/MS SQL Express.To review Dynamics GP matter processes data flow and tables structureyou can install Dynamics GP SDK from wedding album #2 or straightforwardly see 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 savings account design wizard, however this right to use is notrecommended for production reports. Inproduction, Crystal bank account should be based off SQL Server Stored Procedure (whereCR automatically maps procedure parameters into bill parameters, improvement youhave unmovable facility of temporary tables where adopt choose encouragement andunionizing realize not help), or SQL view. Dynamics GP company and system databases allowyou to grow custom objects, such as SQL stored procedure or custom SQL view
3.Crystal Reports niche. In good Plains Dynamics GP you typicallydeploy Crystal Reports where you are building industry specific reports: Salesby product/salesperson/region/class, to manage to pay for you good example. If you are looking for strictly financialreports: P&L, credit Sheet, support of Cash Flow regard as being FRx, CR isnot the best choice
No comments:
Post a Comment