Fields

Once you select a query to use in the report, the display fields it contains are shown in the Available Fields list. You can select which of these display fields you want to use in your report. . For information on building new queries, see Queries.

To edit the fields on the Classic Report, click the Query Editor link. To edit the query in a Smart Report, make sure the is enabled and click the icon.

Note: In addition to the fields in the WHERE clause of the query, the fields in the SELECT clause also need to be indexed to yield faster report generation. For more information about indexing fields, see Indexing.

In the Classic Report, enter a title for the report in the Report Title field, and then select whether the report contents should be Detailed or Summarized in the Report Contents field. The report title is displayed at the top of a report.

Select the query you want to use from the list located on top of the Select Display fields section. Select the fields to use in the report by moving fields from Available Fields into the Selected Fields list.

Note: You must move at least some available fields to the Selected Fields list, or the report will not run correctly

Select a field in Available Fields (in Design reports, make sure to select the box) and click to move it into the Selected Fields list, or click to add all fields.
To deselect fields from the report, select a field in the Selected Fields list and click to move it back to the Available Fields list, or click to deselect all fields. You can also drag and drop to the available fields column.
Use the move up and move down arrows to order the Selected Fields.
In Smart reports, you can also add new fields at runtime by checking the correspondent box. To set the rendering details, make sure to update and render as boxes and drill-down accordingly.

Tip: For information on how to create query objects for use in reports, see Queries. All available queries, including new queries you create, show up in the pull-down menu in the Select Display Fields section of the Ad hoc Report Designer.