Example 3: Use the "Items" template to create a report

Create a report using the new template.

  1. Go to File > New > Report from Template.
  2. Select the Items template.
    Tip:

    If you do not see the template in this list, select Tools > Specific Setup > Reload. If the template is still not visible, check that you have set the report template directory.

    The New Report from Template wizard opens.
  3. In the Schema Associations tab, select the Schema Location you want to use.
    Note:

    You do not need to select the repetition. The trigger is required for the template to work, but is not used in this example.

  4. In the Add Fields [items] and Add Fields [moreItems] tabs, add as many fields as you want.
    Note:

    Add fields of different types, for example, at least one String and at least one Numeric type.

  5. Click Finish.

Select the fields that have been created in the report and look at their properties, in particular:

  • Text matches the selected field, for example, data_orderline.item_itemid.
  • Type is specific to the data type, for example a Word Box for a string value.
  • Class is also specific to the data type, for example grwStringValue.