|
Crystal Reports for Microsoft Dynamics GP Great Plains Alba Spectrum
Crystal Reports Design for GP overview and typical FAQ
Microsoft Dynamics GP is successor of Great Plains Software Dynamics and eEnterprise ERP application, and Crystal Reports was always the reporting tool of the choice for Dynamics. Historically GP Dynamics was available on Pervasive SQL and Ctree platform, where Crystal Reports were limited, due to the limitation to Pervasive and Faircom ODBC drivers. The last version, available on Pervasive/Ctree was Microsoft Great Plains 7.5 and since version 8.0 GP Dynamics is available on Microsoft SQL Server only, and as you can expect, SQL Server opens all the possible horizons for reports development. Current Version of GP as of November 2007 is 10.0. In this small article we will open philosophical principles of Crystal Reports design for Microsoft Dynamics GP:
1. Crystal Reports is just a reporting tool, not and magic all-the-problems-solver. This means that you should not overestimate the power of report wizards, but instead design either SQL view or SQL stored procedure to accept parameters and return records set to your Crystal Report. Then all you need to do in CR is to group records, sort them, and of course apply styles and other cosmetics. We are placing this message in the first bullet, because we saw a lot of report design failures, where designer tried to do very complex GP tables links within CR and then apply further complex restrictions, and ended up with lines duplication, and other annoying problems, which in fact pile up if you try to fix them with similar patches and at the end of the way, report was abandoned
2. SQL View vs. Stored Procedure. Of course SP looks more elegant as it accepts parameters, which are translated to CR parameters, however SP is also more powerful than the view due to the ability to include temporarily tables and intermediate calculations (based on temporary tables). Temporary tables allow you to go beyond the standard techniques of grouping in SQL Select statement this should be the real solution, which will eliminate records duplications, described in #1. If you plan to invest your time in CR practicing for GP, you should make several practical lessons where you base GP Crystal Reports on SQL view and stored procedure
3. Other reporting tools for GP. If you are CR developer, it is natural, that you try to apply Crystal Report in all the situations, however you should be aware that GP has very powerful pre-designed tools. If you need to create financial statements: Balance Sheet, P&L, Cash Flow you should consider FRx report designer first, FRx links to GP General Ledger and so, if more efficient than CR in Financial Reporting. GP ReportWriter. This reporting tool gets the advantages of GP report launching screens, such as SOP Invoice form, from where you can print specific invoice so called modified reports allow you to place your company logo on Invoice form. Other features of FRx and RW are outside of the scope, please check our publications on these products
4. GP Dexterity Reporting. Dexterity is IDE and programming language of GP. Dex allows you to customize GP forms and reports plus create new ones. In order to explore Dex option, we recommend you to contact GP Dexterity developer, who should help you in the selection
5. Calling CR from GP interface. You can use several techniques. First one is traditional use VBA/Modifier (you will need customization site enabler license for GP), from VBA scripts you can call CR engine. Second technique is Dexterity, where you call Crystal Reports engine from your custom Dexterity sanscript code. You can also consider SDK for Visual Studio developer, allowing you to extend GP forms and of course call CR from your .Net extension application
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canada nationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah, Wisconsin, Florida, Texas. Local service is available in Houston & Dallas: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago, IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles, Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village, Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester, Hinsdale
|
Company: Alba Spectrum Group
| Related press releases |
eConnect Posting Extension: Alba Spectrum Autoposting Server [2008-05-21 22:54:55]
If you are ecommerce developer, who are programming in C# or VB.Net with some SQL stored procedures, then more likely you are deploying Microsoft Dynamics GP eConnect SDK to integrate eCommerce websit...
|
|
Upgrading to Microsoft Great Plains 10.0 Alba Spectrum Chicago [2007-08-07 07:15:48]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP upgrade service in Chicagoland: downtown Chicago, Chicago Southwest subur...
|
|
Microsoft Dynamics GP 10.0 Project Green Advances or future ERP trends Alba Sp... [2007-08-23 04:21:37]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
In around 2003 Microsoft stated about Project Green that it will be merging several Microsoft j...
|
|
Great Plains Reports Design: Crystal, SRS, MS Access, Excel, ReportWriter, Dexte... [2008-06-22 16:19:02]
Microsoft Dynamics GP is successor of former Great Plains Dynamics and eEnterprise, current GP version is 10.0. Since the time when GP became exclusively available on MS SQL Server DB platform only (...
|
|
Great Plains Dynamics upgrade notes Alba Spectrum [2007-09-22 04:08:07]
If your organization deploys GP Dynamics or eEnterprise ERP versions 7.5, 7.0, 6.0, 5.5, 5.0 or 4.0 you should consider upgrade scenarios, plus you should also consider reenrollment into Microsoft Bus...
|
|
Microsoft Dynamics GP 10.0 Dexterity Customizations review Alba Spectrum [2007-07-29 05:05:09]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577 1-630-961-5918
Microsoft Great Plains Dynamics GP version 10.0 is out there and a lot of existing GP customers ...
|
|
Microsoft Great Plains Boca Raton, FL Alba Spectrum Group [2007-12-23 04:52:45]
Microsoft Business Solutions Great Plains is gaining market share as we write these lines. Alba Spectrum Group is announcing its Florida GP consultants headcount increase. If you have concerns about...
|
|
Microsoft Dynamics GP 10.0 Reporting: traditional and new tools Alba Spectrum [2007-07-28 03:48:40]
Alba Spectrum Group http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Great Plains version 10.0 was released in Summer 2007. If you support GP ERP in your ...
|
|
Planning upgrade for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-08-08 04:56:42]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are on the way to upgrade GP versions 7.5, 8.0, 9.0 to GP 10.0, then you should read thi...
|
|
Great Plains Version Upgrade Microsoft Dynamics GP installation notes Alba Spe... [2007-10-07 03:20:00]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Business Solutions Great Plains Dynamics GP version update technology seems to be str...
|
|
|
|
| DRoster - Employee Scheduling |
Manage your employee scheduling efficiently and fast. Create any scheduling rules and DRoster will make sure they never clash; set up templates once and reuse them for instant scheduling; use out-of-the-box reports and export them in any format. FREE |
|
| AcePlanner |
This intuitive time management software provides possibility to organize tasks, planning a day using previously defined to do items, tracking daily mood changes via colors and prepare various time reports for printing. |
|
| AyaNova |
AyaNova service management and work order software includes work orders, dispatching, scheduling, preventive maintenance, custom fields, equipment tracking, custom reports, QuickBooks or PeachTree interface, mobile & web browser interface, and more. |
|
| Search My Network |
Search My Network is a professional file search and management program for LANs and desktop PCs. Look for computers, printers, files, folders on your LAN or PC. Create reports, print, export, sort, copy, move, delete, etc. Try it now! |
|
| QIOS Pelican |
Use QIOS Pelican to send personalized, bulk or mass e-mail to contacts in data sources, such as Microsoft SQL Server, Exchange, Access, Outlook, Excel, Oracle or MySQL. Define fields in your message and apply the datasource to create the e-mail. |
|
| Dutch Duck Cache and History Reader |
Dutch Duck Cache and History Reader shows Microsoft Internet Explorer's History, Cache, Cookies, and Favorites in a very accessible, spreadsheet-like format. You can selectively remove items, and sort, group, search, print, and export everything. |
|
| NET Reports Server PRO |
NET Reports 2.0 Server - a Internet ready application; Fast Query & Report solution for Ms.Sql Server, Oracle, PostGreSql, MySql, Interbase, Firebird, MS. VFP. Sybase, MS. Access; Free client software from http://www.net-reports.net/downloads.html |
|
|