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

MORE RESOURCES:

- Directory
- SEO
- Hosting
- Software Reviews
- Software News
- Flash Games
- software shop
- sony digital camera pink digital camera
- cheap book
- mp3 player ipod
- dummies dummies books
- sony walkman
- beauty shop women shop
- mp3 downloads
- งาน

Google
 


RELATED ARTICLES
5 Time-Saving Tips in Microsoft Word
Whether you have used Microsoft Word for years, have just switched from WordPerfect or are new to word processing, try these easy steps to save time and simplify your work in Word:Turn off Personalized Menus and ToolbarsAlthough it is a default, Personalized Menus and Toolbars is a terrible "feature" which limits your initial view to select toolbar buttons and menu commands. Do you only have one row of toolbars at the top of the screen? When you click on a menu, does it expand only after a few seconds? If so, you will save yourself a lot of frustration by turning off this personalized display:1.
Microsoft Great Plains Installation - Overview for IT Director/Controller
Microsoft Great Plains is main mid-market application from Microsoft Business Solutions. This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation.
Managing Stress in the Computer Industry - Five Steps to a Stress-free Life
It would be easy to think, like most people apparently do, that stress and the computing (and especially programming) industry were unlikely bedfellows. The habitual image of long-haired young "geek" programmers churning out 'software' from their teenage bedrooms is one that many still associate with mainstream programmers.
XML Parser and Their Types
XML parser is a software module to read documents and a means to provide access to their content. XML parser generates a structured tree to return the results to the browser.
Microsoft Blues
With the advent of 'Service Pack 2' for Windows XP operating system, Microsoft have really made the forums hum.Every forum on computer problems is replete with complaints that since downloading and installing 'SP2', many 'third party' applications don't work.
Microsoft Moves to Small Business Accounting/Retail Market - Stakes and Thoughts
In this small article we will be looking at the new opportunities for Microsoft Small Business Server specialists, but rather look at the global business strategy and possible ways of future ERP modules standardizing and interoperability. This is important to get into consideration for midsize and large corporate business IT decision makers.
Microsoft Great Plains Furniture & Fixtures - Implementation & Customization Highlights
Microsoft Great Plains, former Great Plains Software Dynamics / eEnterprise was introduced in 1993 as first Microsoft Windows and Macintosh based graphical accounting/ERP application for Mid-Size businesses. Considering the history of furniture retailer and custom assembly lines - they showed up on the market about five decades ago and they have automated their business operations with Unix-based businesses in the late 1960th and earlier 1970th.
C++ Tutorials: 3, Program Flow (If, Else, While, For)
Program Flow is what you think it is. How the program will flow.
netstat - Linux Command to Display Networking Information
In linux, one of great commands for finding out information about your network connections is "netstat". It provides you interface information, statistics, connections, and a lot of other really great information about your computer.
Groupware as a Document Manager: Collaboration Series #3
This article is the third of a series of articles exploring specific aspects of groupware. The brief informational articles in this series discuss some of the technologies associated with groupware, as well as some of the characteristics of groupware.
Microsoft Business Solutions Partner - How to Launch New IT Consulting Practice
In the new era of internet marketing the problem of severe competition comes into the first position. If you look back into 1990-th you will find high tech companies using traditional sales techniques: purchasing local and regional businesses contact lists, making cold calls and then trying hard sales closing techniques, such as "selling to the top" - IBM style, selling to VITO (very important top officer), etc.
Is Your Family Protected?
When you think about Security, what do you think of? We all have one device or another to assist in keeping us safe. We have pad locks and security systems to safe guard our home, alarm systems to protect the equipment in our cars, parental controls on our cable TV and satellite accesses.
3 Reasons Why Medical Billing Software is Leading the Way
Since technology changes so quickly, it is hard to begin by saying "in the old days . .
Microsoft Update - 5 Reasons to Update Service Pack 2
Microsoft released Service Pack 2 (SP2) for the Windows XP operating system back in August (2004), representing significant improvements in many areas, especially system security. For those people that are still unsure whether they should update to it, the following five reasons may help make the decision easier.
Microsoft CRM Programming Secrets - Tips For Developers
This article is for advanced Microsoft CRM SDK C# developers. It describes the technique of direct SQL programming, when SDK doesn't have the functionality to do the job.
Making The Decision To Automate Your Software Testing
Not every software testing project can or should be automated. Before your department accepts a new test automation project, you should establish a process by which projects are reviewed and either accepted or rejected.
The Hidden Power of Online Manual
Writing software manuals is boring, isn't it? We often think: "My software is easy to use. The user interface is intuitive.
Microsoft Great Plains GL: General Ledger - Overview For Consultant
Microsoft Business Solutions Great Plains is marketed for mid-size companies as well as Navision (which has very good positions in Europe and emerging markets where it can be easily localized). Great Plains Inventory control is pretty robust and here we would like to give you highlights on standard functionality as well as what could be added to its standard features.
Navision Attain C/ODBC Crystal Report - Customization Example
Microsoft Business Solutions Navision is main ERP application for European, Brazilian markets plus it serves vertical segments of the USA market, such as light manufacturing, POS, CRM. As our experience indicates - Navision implementation requires more customization and tuning in comparison to another mid-market ERP solution from MBS: Microsoft Great Plains.
Adware and Spyware
What is 'adware'?Adware is basically software or scripts that are hidden on your computer, that make advertising show up all over the place. It may be an extra menu in your web browser, icons appearing on your desktop, bookmarks or favourites appearing out of no where, and pop up ads that seem to come from no where!What is 'spyware'?Spyware is similar in nature to adware, however I feel its purpose is slightly more sinister.

Home | Site Map | globalwarming awareness2007