Microsoft Dynamics GP is replacement of Great Plains Software Dynamics and eEnterprise ERP application, and Crystal Reports was consistently the revealing device of the decision for Dynamics. Truly GP Dynamics was accessible on Pervasive SQL and Ctree stage, where Crystal Reports were constrained, because of the confinement to Pervasive and Faircom ODBC drivers. The keep going form, accessible on Pervasive/Ctree was Microsoft Great Plains 7.5 and since variant 8.0 GP Dynamics is accessible on Microsoft SQL Server just, and as you can expect, SQL Server opens all the potential skylines for reports advancement. Current Version of GP as of November 2007 is 10.0. In this little article we will open "philosophical" standards of Crystal Reports structure for Microsoft Dynamics GP:
1. Precious stone Reports is "only" a revealing instrument, not and enchantment "all-the-issues solver". This implies you ought not overestimate the intensity of report wizards, yet rather plan either SQL view or SQL put away technique to acknowledge boundaries and return records set to your Crystal Report. At that point all you have to do in CR is to amass records, sort them, and obviously apply styles and other "beauty care products". We are putting this message in the principal slug, since we saw a great deal of report plan disappointments, where architect attempted to do complex GP tables joins inside CR and afterward apply further complex limitations, and wound up with lines duplication, and other irritating issues, which in reality heap up on the off chance that you attempt to fix them with comparable patches and toward the finish of the way, report was relinquished data analytics.
2. SQL View versus Put away Procedure. Obviously SP looks progressively rich as it acknowledges boundaries, which are meant CR boundaries, anyway SP is additionally more remarkable than the view because of the capacity to incorporate incidentally tables and middle of the road counts (in light of brief tables). Brief tables permit you to go past the standard strategies of collection in SQL Select explanation - this ought to be the genuine arrangement, which will dispense with records duplications, depicted in #1. On the off chance that you intend to put your time in CR rehearsing for GP, you should make a few down to earth exercises where you base GP Crystal Reports on SQL see and put away strategy
Exclusive on fiverr by rajaaziz
3. Other revealing apparatuses for GP. On the off chance that you are CR designer, it is regular, that you attempt to apply Crystal Report in all the circumstances, anyway you ought to know that GP has extremely ground-breaking pre-structured devices. In the event that you have to make budget summaries: Balance Sheet, P&L, Cash Flow - you ought to consider FRx report architect first, FRx connections to GP General Ledger thus, if more productive than CR in Financial Reporting. GP ReportWriter. This announcing instrument gets the benefits of GP report propelling screens, for example, SOP Invoice structure, from where you can print explicit receipt - purported adjusted reports permit you to put your organization logo on Invoice structure. Different highlights of FRx and RW are outside of the extension, if it's not too much trouble check our distributions on these items
4. GP Dexterity Reporting. Mastery is IDE and programming language of GP. Dex permits you to tweak GP structures and reports in addition to make new ones. So as to investigate Dex choice, we prescribe you to contact GP Dexterity designer, who should help you in the choice
5. Calling CR from GP interface. You can utilize a few methods. Initial one is conventional - use VBA/Modifier (you will require customization site empowering agent permit for GP), from VBA contents you can call CR motor. Second strategy is Dexterity, where you call Crystal Reports motor from your custom Dexterity sanscript code. You can likewise consider SDK for Visual Studio engineer, permitting you to expand GP structures and obviously call CR from your .Net augmentation application
