|
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 (...
|
|
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 ...
|
|
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...
|
|
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...
|
|
|
|
| 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! |
|
| Directory Report |
 Directory printer. Print to a Printer, Text, Excel, XML or HTML file. Find duplicate files. Find duplicate directories. Multiple file rename. Multiple file change date. Multi file change owner. Shows file owner. Print cyclic redundancy checksum CRC |
|
| Ez4file (Personal Edition) |
 The Ez4file allows you to access and manage files woldwide using a Web broswer. It features with Virtual Directory, password encryption, 100+ MB file upload, bulk file/folder copy/paste/delete, clipboard view/clear. It is an alternative to FTP. |
|
| Pure SEO CMS |
 Fast, powerful, SEO website builder, optimized CMS, CSS compliant. Fast, client side XML to html engine. Beginners enter content and select design. Experts use their own templates and save time building high quality sites . No online server required. |
|
| 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 |
|
| Clix-FX Fee 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. |
|
| 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. |
|
|
Latest press releases
