Reporting for Microsoft Great Plains/Dynamics/eEnterprise: RW ? ReportWriter ? Tips for Developer

Microsoft Business Solutions Great Plains is written in Great Plains Software programming tool: Great Plains Dexterity. Dexterity in turn was built with conception of graphical cross-platform transferability (in time ? 1992 ? mostly Mac and MS Windows). Plus Dexterity had database abstraction level (through C programming language). The result of such a shrewd future-looking architecture ? Great Plains ReportWriter has multiple restrictions and drawbacks.

Let's first look at the advantages of using ReportWriter:

? Seamless integration with Great Plains forms ? the most typical scenario ? you modify SOP_Long_Invoice_Form or SOP_Blank_Invoice_From and then print your invoices with modified form ? usually with your logo and changed formats and positions of the fields

? Parameters Entry Forms. Each existing report (Reports section) has associated parameters entry form. Restrictions:

? No Cross-Modules links. You can not associate report with the tables from non-related modules. For example you can not have Sales Order Processing (SOP) and Purchase Order Processing data on the same report (you actually can ? but you need Dexterity programmer help)

? Custom Reports. You do not have parameters entry interface for your custom reports, but you could use restrictions to restrict the selection. Custom reports could be used to export data from Great Plains in text (and then Excel format)

Advanced ReportWriter programming

? Rw_ functions in Great Plains Dexterity. When you need cross-modules data on the same report (Bill of Lading, which you could produce on the base of Picking List) you need to move the report you want to customize into your custom DYNAMICS.DIC and fill the gaps with RW_ functions ? these are allowed to be placed on the report with parameters

If ReportWriter doesn't do the job:

? Crystal Reports. Current version 8.0 and 8.5 (July 2005) are MS SQL Server based, where Crystal Report could work at will and produce all the desired links ? we recommend you to base Crystal Report on SQL Stored Procedure or SQL View. You call Crystal Report engine via Modifier/VBA ? you need Customization Site Enabler license. If you are on Great Plains Standard version: 7.5, or Great Plains Dynamics/eEnterprise 7.0, 6.0, 5.5 or 5.0 Btrieve/Pervasive SQL/Ctree ? you need to install Pervasive SQL driver (or Faircomm driver for Ctree)

Good luck with implementation, customization and integration and if you have issues or concerns ? we are here to help! If you want us to do the job - give us a call 866-528-0577 or 630-961-5918! help@albaspectrum.com

Andrew is Great Plains specialist in Alba Spectrum Technologies ( http://www.albaspectrum.com ) ? Microsoft Great Plains, Navision, Microsoft CRM Partner, serving clients in California, Minnesota, Illinois, Washington, Florida, Arizona, New York, New Jersey, Virginia, Georgia, Louisiana, Texas, Canada, UK, Australia, Brazil, Germany, Russia

In The News:

pen paper and inkwell


cat break through


Microsoft eCommerce Web-development: Great Plains eConnect .Net ? Highlights for Programmer

In our small article we'll consider Microsoft Business Solutions Great... Read More

Put Some Pizazz in Your Software Arsenal

The software giants don't do everything and don't always produce... Read More

Fleet Maintenance Software Reviews

Innovative Maintenance Systems (IMS) is one company that offers solutions... Read More

Recovering Microsoft Great Plains Customization ? Tips for IT Director

Remember nice and prosperous Clinton era? When you implemented innovative... Read More

How To Choose A Fire Wall Software Program

In the real world a "fire wall" is a fireproof... Read More

5 Time-Saving Tips in Microsoft Word

Whether you have used Microsoft Word for years, have just... Read More

Recent Studies Show that 9 out of 10 PCs Are Infected with Spyware

Spyware and malware are large problems for Internet users today... Read More

Microsoft Great Plains Integration Manager: Using Continuum ? Overview for Developer

Microsoft Business Solutions Great Plains has I'd say end user... Read More

Microsoft Business Solutions VAR/Partner Selection ? Overview for IT Director/Manager/Controller

Microsoft Great Plains and Microsoft CRM become more and more... Read More

Most Dangerous Types of Spyware are on the Rise: How to Choose the Weapon

Bad News - the Threat is Bigger than it SeemedHow... Read More

Great Plains Bill of Materials Setup & Customization for Process Manufacturing ? Overview

Microsoft Great Plains has full-featured Manufacturing suite of modules: Capacity... Read More

Instant Messaging is a Sweet Way to Communicate

MSN messenger is a pretty cool invention. I mean I'm... Read More

Microsoft CRM Custom Design & Development: SDK, C#, SQL, Exchange, Integration, Crystal Reports

Microsoft CRM is new player on the CRM software... Read More

How a Bug Challenges to a Software Professional

It is really interesting that a bug can create problem... Read More

Intro to UNIX Shells

A UNIX Shell is in simplest terms, a command line... Read More

XML Parser and Their Types

XML parser is a software module to read documents and... Read More

The Opera Alternative

Security flaws have long plagued Internet Explorer (IE), the market-dominating... Read More

Microsoft Blues

With the advent of 'Service Pack 2' for Windows XP... Read More

Spyware - The Internet Devil Of Our Times!

Spyware and Adware infest over 90 percent of computers in... Read More

CRM 101: Customer Relationship Management for Beginners

Customer Relationship Management, abbreviated "CRM," is the term for a... Read More

COSMIC: A Small Improvement on the Symons Method

The COSMIC FP (function point) software quality metric, is no... Read More

Unwanted Files

A LOT OF UNWANTED FILES.When you uninstall an item of... Read More

Keeping Track

One of the things we can be as certain of... Read More

Cisco Certification: Introduction To ISDN, Part V

The major reason I recommend getting your hands on real... Read More

Great Plains Customization ? Programming Auto-apply in Accounts Receivable

Microsoft Great Plains is one of three Microsoft Business Solutions... Read More

Reloading Windows XP

If you have been running Windows XP for a couple... Read More

Passwords Used In Microsoft Word Documents

You would like to protect your documents, wouldn't you? Reasons... Read More

Data Quality Best Practices for Salesforce.com

Executive SummaryAn effective plan for entering, cleaning and updating the... Read More

Photoshop Files and Formats

People often ask me: What image file formats will Photoshop... Read More

Alien Intruders!

You probably didn't casually invite, or extend a formal attendance... Read More

How to Choose the Right Accounting Software for Your Business

With any good luck and a good amount of hard... Read More

C++ Tutorials: 3, Program Flow (If, Else, While, For)

Program Flow is what you think it is. How the... Read More

Understanding Document Management

The term "document management" and "paperless office" is the subject... Read More