Using The Report Helper

ENG 11116 The custom data table on the .wms Dashboard uses a new structure for the custom report logic. The .wms Admin Tool includes a Report Helper option to assist you with the data table configuration.

1. In the Report Helper, you can either:

   Use an existing JSON configuration

   1. Click Load Existing Configuration.

      The Load Existing Configuration dialog box displays.

   2. Copy and paste your JSON configuration for the custom data table into the dialog box.

      Example

      Copy

      {
        "TableConfig": {
          "columns": [
            {
              "data": "ItemCode",
              "title": "Item Code"
            },
            {
              "data": "ItemName",
              "title": "Item Name"
            },
            {
              "footer": "SUM",
              "data": "ItemWeight",
              "title": "Item Weight"
            }
          ],
          "order": [
              2,
              "asc"
          ]
        }
      }

   3. Click Load.

   Generate a configuration form SQL

   1. Click Generate Configuration From SQL.

      The Generate Configuration From SQL dialog box displays.

   2. Copy and paste your SQL for the custom report into the dialog box.

   3. Click Generate.

   The Sorting and Columns sections update with the information from your configuration.

2. Make adjustments to the Sorting and Columns sections, as needed.

3. Click Output Configuration.

   The JSON code displays below the columns section.

4. Copy the code into the customer's report configuration in the REP table.