Relational Grid Configuration Dialog Box

This dialog box opens when you click Configure on the General tab of the Property Editor for the Relational Grid Widget. You must select a relational field and report before you can complete this dialog box.

The following describes the configuration settings for a new relational grid report based on an SBM Composer report definition. To configure a relational grid report based on an external report (Reference Link report type), refer to Embedded Report Configuration Dialog Box.

For details on using the widget, refer to Using the Relational Grid Widget.

Element Description
Relational field Select the relational field you want to report against. The relational field can be mapped to a primary or auxiliary table in this application or to a table in a referenced application in another process app.
Report Select the report definition. The report definition must be based on the table that is referenced by the relational field. For example, if in Process App A you want to display a list of relational field values for Auxiliary Table A located in Process App B:
  1. Open Process App B.
  2. Select Auxiliary Table A in the Data Design area of the App Explorer.
  3. Right-click, and then select Create Report Definition for this table.
  4. Create the report definition.
  5. Close Process App B, and open Process App A.
  6. Create a reference to Process App B. (For steps, refer to Defining a Reference.)
  7. Add a Single Relational or Multi-Relational field based on Auxiliary Table A.
  8. Configure the relational grid in Process App A to use the report created in Process App B.
Inputs Shows the input parameters for the report. Change parameters on the Query tab of the widget Property Editor.
Automatically bind compatible parameters Select this option if you want fields that are configured as "query-at-runtime" to be automatically bound on the Query tab of the widget Property Editor when you complete this configuration dialog box.