|
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 ...
|
|
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 (...
|
|
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...
|
|
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...
|
|
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...
|
|
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...
|
|
|
|
| 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. |
|
| 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. |
|
| 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. |
|
| 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 |
|
| uCertify MCSE (70-270) practice test |
 Pass MCSE exam 70-270 in first attempt. 455 questions with detailed explanation and 138 study notes. 70-270 - Windows XP Professional study notes, articles and mock test. 99% pass rate, 100% money back guarantee. Based on latest Microsoft certificat |
|
| 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. |
|
| 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 |
|
|
Latest press releases
