| Microsoft Dynamics GP is successor of
| |
| | allow you to go beyond the standard
|
| Great Plains Software Dynamics and
| |
| | techniques of grouping in SQL Select
|
| eEnterprise ERP application, and Crystal
| |
| | statement - this should be the real
|
| Reports was always the reporting tool of
| |
| | solution, which will eliminate records
|
| the choice for Dynamics. Historically GP
| |
| | duplications, described in #1. If you
|
| Dynamics was available on Pervasive SQL
| |
| | plan to invest your time in CR practicing
|
| and Ctree platform, where Crystal Reports
| |
| | for GP, you should make several practical
|
| were limited, due to the limitation to
| |
| | lessons where you base GP Crystal Reports
|
| Pervasive and Faircom ODBC drivers.
| |
| | on SQL view and stored procedure
|
| The last version, available on Pervasive
| |
| | 3. Other reporting tools for GP. If you
|
| Ctree was Microsoft Great Plains 7.5 and
| |
| | are CR developer, it is natural, that you
|
| since version 8.0 GP Dynamics is
| |
| | try to apply Crystal Report in all the
|
| available on Microsoft SQL Server only,
| |
| | situations, however you should be aware
|
| and as you can expect, SQL Server opens
| |
| | that GP has very powerful pre-designed
|
| all the possible horizons for reports
| |
| | tools. If you need to create financial
|
| development. Current Version of GP as of
| |
| | statements: Balance Sheet, P&L, Cash Flow
|
| November 2007 is 10.0. In this small
| |
| | - you should consider FRx report designer
|
| article we will open "philosophical"
| |
| | first, FRx links to GP General Ledger and
|
| principles of Crystal Reports design for
| |
| | so, if more efficient than CR in
|
| Microsoft Dynamics GP:
| |
| | Financial Reporting. GP ReportWriter.
|
| 1. Crystal Reports is "just" a reporting
| |
| | This reporting tool gets the advantages
|
| tool, not and magic
| |
| | of GP report launching screens, such as
|
| "all-the-problems-solver". This means
| |
| | SOP Invoice form, from where you can
|
| that you should not overestimate the
| |
| | print specific invoice - so called
|
| power of report wizards, but instead
| |
| | modified reports allow you to place your
|
| design either SQL view or SQL stored
| |
| | company logo on Invoice form. Other
|
| procedure to accept parameters and return
| |
| | features of FRx and RW are outside of the
|
| records set to your Crystal Report. Then
| |
| | scope, please check our publications on
|
| all you need to do in CR is to group
| |
| | these products
|
| records, sort them, and of course apply
| |
| | 4. GP Dexterity Reporting. Dexterity is
|
| styles and other "cosmetics". We are
| |
| | IDE and programming language of GP. Dex
|
| placing this message in the first bullet,
| |
| | allows you to customize GP forms and
|
| because we saw a lot of report design
| |
| | reports plus create new ones. In order
|
| failures, where designer tried to do very
| |
| | to explore Dex option, we recommend you
|
| complex GP tables links within CR and
| |
| | to contact GP Dexterity developer, who
|
| then apply further complex restrictions,
| |
| | should help you in the selection
|
| and ended up with lines duplication, and
| |
| | 5. Calling CR from GP interface. You can
|
| other annoying problems, which in fact
| |
| | use several techniques. First one is
|
| pile up if you try to fix them with
| |
| | traditional - use VBA/Modifier (you will
|
| similar patches and at the end of the
| |
| | need customization site enabler license
|
| way, report was abandoned
| |
| | for GP), from VBA scripts you can call CR
|
| 2. SQL View vs. Stored Procedure. Of
| |
| | engine. Second technique is Dexterity,
|
| course SP looks more elegant as it
| |
| | where you call Crystal Reports engine
|
| accepts parameters, which are translated
| |
| | from your custom Dexterity sanscript
|
| to CR parameters, however SP is also more
| |
| | code. You can also consider SDK for
|
| powerful than the view due to the ability
| |
| | Visual Studio developer, allowing you to
|
| to include temporarily tables and
| |
| | extend GP forms and of course call CR
|
| intermediate calculations (based on
| |
| | from your .
|
| temporary tables). Temporary tables
| |
| |
|
