Creating an Initialization Query

An initialization query executes once at the beginning of a report, before the master query. It returns a single row with one or more columns. The results are stored in uniquely named Production Reporting variables that you can use anywhere in the layout. Initialization queries are non-layout queries executed using the Production Reporting BEFORE-REPORT command. See Volume 2 in the Hyperion SQR Production Reporting Developer's Guide for more information.

Initialization queries are useful for:

*  To create an initialization query:

  1. Display the layout for the master query in the Layout window.

  2. Click Insert Fields button on the Object Toolbar, select Insert, then Field, or right-click Fields in the Object Explorer and choose Insert.

    The Report Fields dialog box is displayed with the master query listed in the Database tab.

  3. Click New and choose Init Query.

  4. In the Query Builder, enter a name for the initialization query and select the data to use.

    After you create an initialization query, it is displayed in the Database tab of the Report Fields dialog box.

    Note:

    You can create an initialization query using data from a different data source than the data source used by the master query. See Creating Queries Using Different Data Sources.

    Note:

    The fields returned from an initialization query can be used in the report layout like any other fields. The initialization query and the fields from the initialization query do not appear in the Query Explorer, however, since an initialization query does not have its own layout.