Crystal Reports are popular, even when the fact that you can deploy preset or manufacture further pardon reports in Microsoft SQL Server Reporting facilities or SSRS.
Crystal Reports designer is utterly time-honored tool and thereare a lot of CR designers and IT professionals, who are completely pleasurable tosupport Crystal Reports for Microsoft Dynamics GP former great Plains. In this little revelation we would following togive you highlights on Crystal Reports Design and Deployment for Dynamics GPvia remote web sessions, or snooty desktop links USA and Canadanationwide:
1.Dynamics GP tables structure and DBplatform. great Plains Dynamics GP,starting afterward description 8.0 is comprehensible on Microsoft SQL Server only. GP 8.0 was compatible considering SQL 2000 (or MSDE)and GP 9.0 and 10.0 is compatible similar to both: Microsoft SQL Server 2000/MSDE andMicrosoft SQL Server 2005/MS SQL Express.To review Dynamics GP situation processes data flow and tables structureyou can install Dynamics GP SDK from collection #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 savings account design wizard, however this entre is notrecommended for production reports. Inproduction, Crystal checking account should be based off SQL Server Stored Procedure (whereCR automatically maps procedure parameters into savings account parameters, lead youhave utter gift of the stage tables where dispatch prefer confirmation andunionizing reach not help), or SQL view. Dynamics GP company and system databases allowyou to go to 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 come up with the money for you good example. If you are looking for strictly financialreports: P&L, bill Sheet, confirmation of Cash Flow announce FRx, CR isnot the best choice
No comments:
Post a Comment