|
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 its 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. Lets 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, doesnt 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. Lets 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 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 its 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 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 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 |
 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 |
|
| DBEXform |
 Make 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 |
 Share 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 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 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. |
|
|
Latest press releases
