Defining Alternate Orders

You can define alternate (or multiple) orders for a report to run the report in one of several orders at run time. The maximum number of orders you can define for a report is six. For information on selecting an order at run time, see Defining a Parameter Field.

Before you can define an alternate order, you must paint the report with a single index or sort order. For more information, see Selecting an Index and Defining a Sort Order.

  1. Paint and save the report.
  2. On the Database Structure-Program Structure form, press Define (F6) and choose Alternate Orders.

    If the report already has alternate orders, press Define (F6) and choose Add to add another access order.

  3. In the Select Order window, select an index or define a new sort order. For more information, see Selecting an Index and Defining a Sort Order.
  4. In the Structure Definition window, define the report structure. For more information, see Structuring a Report.
  5. Press OK.

    The Report Format form appears. Paint the report for the alternate order.