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

Crystal Reports for Microsoft Dynamics GP 10.0 – Alba Spectrum

Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918

Microsoft Great Plains has long tradition to deploy Crystal Reports, where it’s embedded reporting tool ReportWriter does not provide required reporting flexibility, especially for high quality reports with graphical elements, such as logos, advanced fonts, plus where you need advanced reporting logic. Report Writer can only deal with Dexterity tables from one GP module. Crystal Reports allows you to build any SQL query you need and join “cross-modules” tables, including custom tables and tables and data in heterogeneous databases environments: Oracle, DBII, Pervasive SQL, Ctree, MySQL, and other ODBC compliant platforms. Let’s review Crystal Reports design techniques:
1. Designing Report vs. Query Building. If you are new to Crystal Reports design, we certainly understand the temptation to use wizard to create report. Unfortunately, we saw the results, when programmer was very disappointed and ended up complaining that report shows “duplicate” records, doesn’t show “all the records”, etc. You should probably think about what report designer is and what it is not. Crystal Reports is excellent report designer, but in order to provide report designer the records set you should use other tools. Let’s move to the next paragraph
2. Stored Procedures and SQL Views; unions. The most flexible query building instrument is stored procedure. Crystal Report should submit parameters to stored procedure and so create relevant records set for the report. In SQL View you can use Crystal Report parameters for limiting view results to be included in the report. Stored procedure, comparing to the SQL view, allows you to use internal temporary tables to build the most sophisticated result set – in view you can not use temp tables. Unions allows you to combine Work, Posted and Historical transactions, for example to be included in report
3. Example One. Imagine you would like to display SOP work and historical invoices in the same report. You should create SQL view, where you will unionize SOP10100 and SOP30200 tables, assuming that you would like to show each invoice total in the report
4. Example Two. Imagine, you are selling serialized items and you would like to show the report on Item history: from whom and when it was purchased, to whom and when it was sold. In this case you create cross modules SQL view, where you join POP receiving lines and SOP historical tables

Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Microsoft Dynamics GP USA and Canada nationwide: Toronto, Montreal, Vancouver, Calgary, Windsor, New York, San Francisco, Los Angeles, Miami, Orlando, Pittsburg, Toledo, Indianapolis, Detroit, Philadelphia, Boston, Washington, Seattle, San Diego, Phoenix, Austin. Local service is available in Chicago and Houston metros: Rosenberg, Katy, Richmond, Dallas, Galveston, Sugar Land, Naperville, Wheaton, Plainfield, Aurora, Wheaton, Downers Grove, Lisle, Oakbrook, Morris, Marseilles, Joliet, Montgomery, Oswego, DeKalb. With reasonable travel we serve Springfield, Bloomington, Normal, Peoria, LaSalle, Ottawa, Dixon

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
189
.rpt Inspector Enterprise Suite for Crystal Enterprise 10 / Crystal Reports 10 3.12
19 tools for Crystal Enterprise 10 management
314
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.
6
Report Viewer for Crystal Reports 2.8.2.17
A Powerful Crystal Reports Viewer
824
IDAutomation Barcode UFL for Crystal Reports 3.0
Barcode UFL for Crystal Reports.
460
Barcode Generator for Crystal Reports 9.08
Barcode object for Crystal Reports.
576
Crystal Reports Barcode Font UFL 9.0
Barcode UFL for Crystal Reports
317
.rpt Inspector Professional Suite for Crystal Reports 8.5 3.02
16 tools for Crystal Reports 8.5 management
1275
.rpt Inspector Professional Suite for Crystal Reports 9 3.02
16 tools for Crystal Reports 9 management
588

Related press releases
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...
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...
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 ...
Crystal Reports for Microsoft Dynamics GP 10.0 – Alba Spectrum [2007-08-31 05:13:11]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918 Microsoft Great Plains has long tradition to deploy Crystal Reports, where it’s embedded report...
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 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 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...
Alba Spectrum, Dynamics GP Technology Partner Announces its Participation in Con... [2009-03-03 18:09:34]
Chicago, IL – March 3, 2009 – Alba Spectrum announced today its participation in Convergence 2009, the premier Microsoft Dynamics event that brings together customers, partners, Microsoft team mem...
Microsoft Dynamics GP 10.0 Implementation in Chicagoland – Alba Spectrum [2007-09-03 03:29:31]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918 If you are business owner or IT director, you are probably in charge of ERP selection, licenses...
Microsoft Great Plains Implementation Service in Chicagoland – Alba Spectrum [2007-09-06 06:13:43]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918 Microsoft Dynamics GP software sales, business processes mapping and modules selection, data mi...

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

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.

Search My Network
Search My Network 32x32 pixels iconSearch 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!

egrID3 COM Add-In for Microsoft Excel
egrID3 COM Add-In for Microsoft Excel 32x32 pixels iconegrID3 COM Add-In for Microsoft Excel adds functionality to fast mp3 ID3 v1.x, v2.3, v2.4 tag reading and altering, playlists generation, FreeDB querying, file names handling and full Unicode support on all operations. Handle compressed v2.x frames.


Archive: All downloads - Links - Links2

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