|
Great Plains Reports Design: Crystal, SRS, MS Access, Excel, ReportWriter, Dexterity, FRx – Alba Spectrum
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 (since version 8.0), reporting tools for Great Plains gained new one: Microsoft SQL Server Reporting Services or SRS. This tool, essentially coming often free with the purchase of MS SQL Server license turned to become very efficient competitor to such traditional generic reports design tool as Crystal Reports. Let’s review reporting tools in brief, following the rules of small article genre:
1. SRS. The nicety of this tool, coming with Microsoft SQL Server 2005 or 2000 is native web interface. You should be familiar with Microsoft Visual Studio to design SRS reports. However as it is the case with its rival – Crystal Reports, if you are facing the requirements to design really powerful and flexible report, you should consider first creating the SQL stored procedure or view, which will serve as report query foundation
2. Crystal Reports. We expect that article reader audience has experienced reports designers, who are typically familiar and comfortable with Crystal Reports. CR designer is a bit more natural and intuitive in comparison to Visual Studio interface (as in the case of SRS). One of the drawbacks for CR is the requirement to purchase separate Crystal licenses
3. MS Access. This tool is typically found in use, when you are dealing with legacy reports for older GP version and you are facing the requirements to upgrade them, meaning keep them as they are and have them just still work for new Great Plains version. You as MS Access programmer should be familiar with VBA scripting, ODBC connection and some SQL selection statements
4. Excel. Microsoft Excel also supports VBA modifications, and in this sense it is similar to mentioned above MS Access. In Excel you can also pursue Data Mining and Data Warehousing with GP database – Pivot Tables
5. Report Writer. This tool you deploy when you modify existing GP reports: SOP blank invoice form is the most popular. Modified reports are immediately available for GP users – they are stored in shared or local Report.dic file
6. Dex custom reports. They would be similar to RW, described above, however in Dexterity you virtually have no limits on what you can do with Great Plains alternative business logic. With one caution – Dexterity developers are not easy to find on the job market, however you can hire GP ISV partner to help you with Dex coding
7. FRx. This tool does financial reporting: P&L, Balance Sheet, Cash Flow, plus consolidated reporting (Reporting Tree allows you to choose companies or account segments for consolidation)
Andrew Karasev, Alba Spectrum http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Great Plains USA and Canada nationwide. Local service in Chicago, Houston, Dallas, San Diego. Please visit our information portal Pegas Planet: http://www.pegasplanet.com . If you need custom programming for GP, we are happy to help you with Dexterity, eConnect, VBA/Modifier, SQL Stored Procedures, Crystal Reports. We also provide instant support to new and existing clients via web sessions
Company: Alba Spectrum
|
| Related press releases |
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 (...
|
|
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 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...
|
|
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 Visual Studio Development notes Alba Spectrum [2007-08-26 04:23:08]
Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
If you are eCommerce programmer and plan to dive into Microsoft Great Plains e-commerce web des...
|
|
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 Great Plains: Renaissance of GP Dexterity Alba Spec... [2007-07-30 04:56:04]
Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918
Microsoft Dynamics GP Great Plains version 10.0 is now released and available to GP customers a...
|
|
Crystal Reports for Microsoft Dynamics GP Great Plains Alba Spectrum [2007-10-22 04:56:11]
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 repor...
|
|
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...
|
|
|
|
| SafeSquid Personal |
 Internet Proxy Server with antivirus and Web Filter for Internet security, Cache, IP based Access Control, Authentication, Block - website access with URL blacklist and keywords; Block music, videos, flash, java applets, messengers, cookies, activex |
|
| DoneEx XCell Compiler |
 Excel workbook copy protection tool, compiles XLS to EXE application (which requires MS Excel to run) with securely hidden formulas and VBA code. Main features:copy protection with regkey; create trial/demo of workbook; and much 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! |
|
| NotJustBrowsing |
 1. Drag&Drop for URL collection
2. Skin shades to choose from
3. Linear Browsing with web page access time
4. Multiple Browsing using tiled-windows
5. Tailored Browsing
6. Auto Browsing
7. Verbial Icons
8. Computer control from within browser |
|
| Amazon Price Watch |
| Amazon Price Watch help you to keep track of the price, get notice when hot item is available or price drops for your wishlist, and find great deals or filler items when you need a bit more for free shipping. |
|
| 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 |
|
| SnapaShot |
 Smallest 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. |
|
|
Latest press releases
