Reporting for Microsoft Great Plains/Dynamics/eEnterprise/Microsoft Dynamics GP 9.0: RW ReportWriter tips for developer
April 28, 2006 (Press Release) --
Alba Spectrum Group, USA/Canada: 1-866-528-0577, 1-630-961-5918, Europe: +44 20 8123 2580, +45 36 96 55 20, Mexico: 52-55-535-04027, Brazil: 55-11-3444-4949, help@albaspectrum.com skype: albaspectrum
Reporting for Microsoft Great Plains/Dynamics/eEnterprise/Microsoft Dynamics GP 9.0: RW ReportWriter tips for developer
In this article we will not be concentrating on MS SQL Reporting Services, if you are reports developer you should check on Microsoft Dynamics GP Business Portal Reporting and enabling SRS reports. We will concentrate on traditional tools: Report Writer, Crystal Reports, etc. Plus we will give some hints to ancient Great Plains versions: Ctree, Pervasive SQL.
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.
Lets 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)
About Alba Spectrum Technologies. Alba Spectrum Technologies is joint venture of several IT and business consulting companies, now operating as single business entity. We have local presence in the Houston, Chicago, New York, Los Angeles, San Diego, Dallas, Miami, Atlanta, Denver, Phoenix, New Orleans, Minneapolis, San Francisco, LATAM & Brazil, Germany, Russia, South East Asia and Oceania. We believe in the coexistence of Java (J2EE, EJB, Linux, Unix), Oracle and Microsoft (.Net, C#, VB) platforms and systems and specialize in several product lines and cross platform integration, customization, heterogeneous report design, plus we provide ERP/CRM systems comparison and reviews, not being committed to just on MRP platform. We also stake on XML cross-platform data interchange to be advanced in the coming decade.
Alba Spectrum Technologies websites:
http://www.albaspectrum.com
http://www.greatplains.com.mx
http://www.enterlogix.com.br
http://www.ronix-systems.de
Reporting for Microsoft Great Plains/Dynamics/eEnterprise/Microsoft Dynamics GP 9.0: RW ReportWriter tips for developer
In this article we will not be concentrating on MS SQL Reporting Services, if you are reports developer you should check on Microsoft Dynamics GP Business Portal Reporting and enabling SRS reports. We will concentrate on traditional tools: Report Writer, Crystal Reports, etc. Plus we will give some hints to ancient Great Plains versions: Ctree, Pervasive SQL.
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.
Lets 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)
About Alba Spectrum Technologies. Alba Spectrum Technologies is joint venture of several IT and business consulting companies, now operating as single business entity. We have local presence in the Houston, Chicago, New York, Los Angeles, San Diego, Dallas, Miami, Atlanta, Denver, Phoenix, New Orleans, Minneapolis, San Francisco, LATAM & Brazil, Germany, Russia, South East Asia and Oceania. We believe in the coexistence of Java (J2EE, EJB, Linux, Unix), Oracle and Microsoft (.Net, C#, VB) platforms and systems and specialize in several product lines and cross platform integration, customization, heterogeneous report design, plus we provide ERP/CRM systems comparison and reviews, not being committed to just on MRP platform. We also stake on XML cross-platform data interchange to be advanced in the coming decade.
Alba Spectrum Technologies websites:
http://www.albaspectrum.com
http://www.greatplains.com.mx
http://www.enterlogix.com.br
http://www.ronix-systems.de
Email
Print
SPAM
