|
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...
|
|
|
|
| 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 |
|
| 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. |
|
| DDQM |
 Excellent Query Management tool for DBISAM 4 Users. Complete with Categorization, Syntax Coloring, Live Result Editing, One-Click Export to MS Excel, and much, much, more. |
|
| Sasfead Sudoku |
 Sasfead Sudoku Lite is a free sudoku game with a very nice design. Some funktions is unavailable in this version (Sasfead Sudoku Lite). If you want to have access to all the funktions you must buy the full version. |
|
| Clix-FX XML Flash Menus |
 Flash XML Menu Templates from Clix-FX We offer you the easiest way imaginable to design and create Flash
menus for your website. |
|
| SecuKEEPER |
 Are your data safe?SecuKEEPER is an ALL-IN-ONE file encryption software design to secure your files and folders from prying eyes, which designing four protection method(hide/rapidly lock/encrypt/private coffer). Furthermore offer Password Manager. |
|
| 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
