A List Record is ready to be used as the Input Source of a new Report when:
The Usage field in the Review Query panel is set to Detail Report SQL or CrossTab Report SQL.
Your query is defined properly in the Edit Query panel.
In the Screen Builder panel, a report criteria screen has been designed. These report criteria can prompt users for field values that alter or narrow the scope of the query each time the Report is run.
The columns of data to be gathered together for sorting in the report have been identified in the Report Builder panel and a sort option has been selected for each.
To create a new report record:
Click the Screen Builder or Report Builder tab in the List Record page.
Click the Add New Report action on the Actions menu.
In the Add New Report dialog page, enter a name and description for the report. Note: The name and report description should allow users to easily recognize what report they need to use based on its name and description. Special characters are not allowed in report names, except for the explanation mark (!), underscore ( _ ), dash (-), period (.) and equal sign (=).
Select all Initial Report Columns that you want to appear in the report.
For each Initial Report Column selected, a column header and corresponding merge field will be created and entered automatically in the Detail panel of the new Report Record. These merge fields, which insert query results into the report, appear as ~generic.column(#)~ where (#) is derived from the order in which they appear in the Add New Report dialog page.
Select the number of Additional Report Columns to include in the report.
For each Additional Report Column selected, an Additional (#) column header will be created and entered automatically in the Detail panel of the new Report Record. These Additional # column headers (for example, Additional 1 and Additional 2) are used as placeholders for the actual headers you will enter in the Detail panel. A Merge Field Toolbar is provided in the Detail panel for inserting the merge fields for additional columns.