Report Writer

Report Writer Integration

Information from the following windows can be added to Report Writer reports:

  • Item Extension
  • Item Class Extension
  • Site Extension
  • Item Site Extension

The integration uses the Report Writer function called rw_TableHeaderString. This function requires five input fields:

Dictionary ID = 5241

Values for String 1

Item Number Use Item Number when retrieving Item Extension
Item Class Use Item Class when retrieving Item Class Extension
Item Number Use Item Number when retrieving Item Site Extension
Location Code Use Location Code when retrieving Site Extension

Values for String 2

Blank Leave blank when retrieving Item Extension
Blank Leave blank when retrieving Item Class Extension
Location Code Use Location Code when retrieving Item Site Extension
Blank Leave blank when retrieving Site Extension

Values for Table ID

1 Item Extension
2 Item Class Extension
3 Item Site Extension
4 Site Extension

Values for Field ID

1 Included checkbox setting (True or False)
2 Tolerance drop down list setting
3 Tolerance value setting (returns value formatted as quantity, currency or percent depending on Tolerance dropdown setting)
4 Value Code

The following example will add Value Code to the Detailed Item List report.

  1. Open the Detailed Item List report in Report Writer
  2. Select Calculated Fields in the Toolbox window, click NEW
  3. Name the field sValueCode, set Result Type = String, and Expression Type = Calculated

  1. Click the FUNCTIONS tab, select User-Defined, Core = System, and location Function = rw_TableHeaderString

  1. Click ADD.
  2. Enter Dictionary ID. Click the CONSTANTS tab, Type = Integer, enter Constant = 5241

  1. Click ADD.
  2. Enter String 1. Click the FIELDS tab, Resources = Item Master, Field = Item Number

  1. Click ADD
  2. Enter String 2. Click the CONSTANTS tab, Type = String, leave Constant blank. Click ADD.
  3. Enter Table ID. Still on the CONSTANTS tab, Type = Integer, Constant = 1. Click ADD.
  4. Enter Field ID. Still on the CONSTANTS tab, Type = Integer, Constant = 4. Click Add.

Add the calculated field (sValueCode) to the report.