GP Report Extender

Dynamics GP Report Extender (GP-REX) provides the ability to add any field from any table to any GP Report Writer Report.  If you purchased a license that includes GP-REX, it is automatically enabled (there are no settings for it inside Dynamics GP). To use GP-REX you must be proficient with writing queries in tSQL.

Overview

GP-REX works through an integration to two existing Report Writer functions:

rw_TableLineCurrency

rw_TableLineString

Since these functions are part of core Dynamics GP, they are available when modifying any Report Writer report (i.e. they are present when working with a core GP report, or with a report from any 3rd Party Product or customization).

GP-REX connects these two functions to corresponding SQL Stored Procedures:

wrwTableGetLineCurrency

wrwTableGetLineString

The CTK installation routine creates these stored procedures.  They have some sample code in them which should be removed before adding your own tSql.

Adding a field using GP-REX requires two steps:

Using Report Writer, create a Calculated Field using one of the two functions above, and add that field to the report.

Using SQL Management Studio, modify the corresponding stored procedure to retrieve the desired value.