Home | Advertise | Submit | Press | Top | Contact | Help | Bookmark |
Search downloads:
Home Latest press releases Crystal Reports for Microsoft Dynamics GP Great Plains – Alba Spectrum

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 downloads
.rpt Inspector Enterprise Suite for Crystal Enterprise 9 / Crystal Reports 9 3.12
19 tools for Crystal Enterprise 9 management
190
.rpt Inspector Enterprise Suite for Crystal Enterprise 10 / Crystal Reports 10 3.12
19 tools for Crystal Enterprise 10 management
317
Crystal Clear Reports for ACT! 1
Crystal Clear Reports from ACT! Information
280
ViewerFX for Crystal Reports 1.9.0.0
Office 2007-like Crystal Reports Viewer.
7
IDAutomation Barcode UFL for Crystal Reports 3.0
Barcode UFL for Crystal Reports.
464
Report Viewer for Crystal Reports 2.8.2.18
A Powerful Crystal Reports Viewer
844
Barcode Generator for Crystal Reports 9.08
Barcode object for Crystal Reports.
581
Crystal Reports Barcode Font UFL 9.0
Barcode UFL for Crystal Reports
321
.rpt Inspector Professional Suite for Crystal Reports XI 3.02
16 tools for Crystal Reports XI management
424
.rpt Inspector Professional Suite for Crystal Reports 10 3.02
16 tools for Crystal Reports 10 management
612

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...
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 (...
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 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...
Dynamics GP or Great Plains with Crystal Report [2008-09-04 16:35:52]
Besides the great and versatile built-in Microsoft Dynamics GP or Great Plains Report Writer, Crystal Report also offers another great tool to create financial reports that base on Dynamics GP data. ...
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...

NET Reports Server PRO
NET Reports Server PRO 32x32 pixels iconNET 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

AyaNova
AyaNova 32x32 pixels iconAyaNova 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.

Dutch Duck Cache and History Reader
Dutch Duck Cache and History Reader 32x32 pixels iconDutch 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.

DRoster - Employee Scheduling
DRoster - Employee Scheduling 32x32 pixels iconManage 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

SnapaShot
SnapaShot 32x32 pixels iconSmallest free screen capture tool, SnapaShot is great for taking screenshots of different size. Just open Snapa, resize its window to fit the area you want to save, and press "save it" button.

DBEXform
DBEXform 32x32 pixels iconMake database application development and use as easy as using word processor or spreadsheet with DBEXform. It builds application logic in background and frees developer to just on building interfaces. Support for Microsoft Sql and Access databases.

OfficeCalendar for Microsoft Outlook
OfficeCalendar for Microsoft Outlook 32x32 pixels iconShare Microsoft Outlook calendar, email, contact, and task information with this affordable Exchange alternative. Makes Outlook calendar sharing and Outlook group calendaring easy. Works with Microsoft Outlook 2000, XP, 2003 and 2007. Free trial.


Archive: All downloads - Links - Links2

Copyright (c)2005-2009 Download3K.com - All rights reserved - Terms of use - Privacy Policy