Software Information

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:

McLane Company to Control Inbound Freight With Retalix Traffic ...
MarketWatch - 17 hours ago
a leading provider of software solutions for distributors and retailers, today announced that McLane Company, Inc., one of the world's largest foodservice ...


RadioShack Selects Fujitsu POS and Store Management Software
Trading Markets (press release), CA - 1 hour ago
RSH | Quote | Chart | News | PowerRating -- Fujitsu Transaction Solutions announced its GlobalStore, StoreCenter and ReturnCenter software has been chosen ...
NEC Corp. Introduces 2 Transaction Management Systems Trading Markets (press release)
all 2 news articles


SYS-CON Media

WSO2 Named "Silver Sponsor" of SYS-CON's SOA World Conference & Expo
SYS-CON Media, NJ - 10 hours ago
... Recursion Software, Red Hat, Reflex Security, Research & Markets, RadiantLogic, Ring Cube Technologies, Riptide Software, Rogue Wave Software, rPath, ...
LinuxWorks Named "Bronze Sponsor" of SYS-CON's Virtualization and ... SYS-CON Media
Krugle to Exhibit at SYS-CON's Virtualization and Cloud Computing ... SYS-CON Media
EMC Named "Gold Sponsor" of SYS-CON's SOA World and Virtualization ... SYS-CON Media
all 66 news articles


Software allows social sites to share info
Bizjournals.com, NC - Oct 11, 2008
JACKSONVILLE — A Jacksonville software company is knocking down walls between social networks, such as MySpace and LinkedIn, by giving users more control ...
Endure ads with the pain at your dentist's office HeraldNet
all 20 news articles


Creating job resumes online or with software
San Francisco Chronicle,  USA - 1 hour ago
What software do you recommend? A: You don't really need software. If you use a big Internet job board such as HotJobs.com or Monster.com, you can build a ...


Ruling ends uncertainty for software developers
Contractor UK, UK - 6 hours ago
Ominously for small software developers, the UK IPO said it would continue to follow the practice, contrary to a High Court ruling in March that it should ...
Limits on bank compensation Financial Times
all 13 news articles


21st Century Software, Inc. Announces DR/VFI v4.3 for IBM Mainframes
PR Web (press release), WA - 4 hours ago
Las Vegas, NV and Wayne, PA (PRWEB) October 12, 2008 -- Today, at the 2008 IBM System z Expo Conference, 21st Century Software, Inc., announced a major ...


Software gives top students another boost
The Nation Newspaper, Barbados - 20 hours ago
Through this partnership, Aries Technologies has provided the school edition of the software to primary schools across the island at no cost to the Ministry ...


Economic climate weighs on oracle, but it makes gains
Newsday, NY - 20 hours ago
Nonetheless, its dominant position in database software gives it a degree of pricing power most other technology companies can only dream about. ...


Swimming with the tide:
San Francisco Chronicle,  USA - 55 minutes ago
Given the above, why would Goldman Sachs' Menlo Park office lead a $12 million round, announced last week, for a Redwood City systems software company ...

Software - Google News

home | site map
© 2006