The HTML Report Assistant always saves a procedure with its fully qualified field name. If you want to view this information, click the Prefix with the segment name and Prefix with the filename options in the Report Fields section of the Field selection tab.

Prefix with the segment name and Prefix with the filename are checked. Note that the fields under Sort by demonstrate the field, segment, and file names.

The following image shows the result after selecting both the prefix with segment name and prefix with the filename.

If you open a report procedure in the Editor, the fields appear with their qualifiers prefixed to the field name or alias.

The information for the highlighted field appears. If multiple fields are selected, the information that appears applies to the last field chosen.

The following procedure shows the underlying code generated by Report Assistant. Note that the fields referenced in the request—SALES, COUNTRY, CAR, and MODE—are prefixed with file and segment qualifiers.

TABLE FILE CAR
SUM CAR.BODY.SALES
BY CAR.ORIGIN.COUNTRY AS 'COUNTRY'
BY CAR.COMP.CAR AS 'CAR'
BY CAR.CARREC.MODEL AS 'MODEL'

Once you have qualified a field with an alias, segment name, or file name, the field will appear with these prefixes in any windows in which that field is referenced in a request. You can vary the qualifiers you select for individual fields.

You can add grand total values to the end of your report and add a row total column by checking the appropriate boxes under Report fields as shown in the following image. The Add grand totals drop-down list provides two options. The Totals option displays grand total values for each column in your report. The Recompute Totals option recalculates computed fields before displaying the grand total values. Selecting the Add a row total column check box adds a column to display the totals for each row.

Select fields for a report by highlighting a field in the Available fields list and clicking the Add icon above the Sort by, Sort across, or Sum/Print field box. From either the List or Tree view, you can also drag and drop a field on the desired field box, or double-click a field to add it automatically.

Note: When you double-click fields, numeric fields are added to the Sum/Print field box, and non-numeric and date fields are added to the Sort by field box. Numeric fields include decimal, floating point, and other formats, and non-numeric fields are usually in alphanumeric format.

The following image shows a field selected in each of the data field boxes, the COUNTRY field in the Sort across data field box, the CAR in the Sort by data field box, and the SALES field in the Sum/Print display field list.

Specifying sort phrases enables you to organize the presentation of information in a desired sequence. Adding fields to the Sort across fields box establishes the field you selected as a column in your report. You can create a matrix report by combining sort and across phrases. You can include a maximum of five ACROSS fields in each report. If you try to enter a sixth ACROSS field, the following message appears:

The Maximum number of horizontal dimensions is 5.

Adding fields to the Sort by fields box establishes your field as a sort field in your report. Sort fields (also known as BY fields) are rows in your report. Any field can be a sort field and you can include up to 32 sort fields in a report.

The Column data fields box designates the selected field as Sum or Print (Detail). After selecting the field, you must also decide if you want WebFOCUS to add the values together (Sum) or print the values individually (Print). WebFOCUS displays the field you select in the last column of your report and performs the requested operation on the data (Sum or Print). The default selection is Sum.

You must select at least one field for the Sort or Sum/Print field lists to create a report. For more information on WebFOCUS syntax used in requesting reports, see the Creating Reports With WebFOCUS Language manual.

Application Objects enable you to add fields to your report that have been customized for your use. For example, if you are creating a sales report, an Application Object may have been set up for you that enables you to easily add a sort field to your report that lists the top 5 highest sellers for a certain year.

Note: Application Objects are only available when you are building a report using a Reporting Object as a template. If you do not see Application Objects, this means they have not been developed for this Reporting Object.

The following image shows a few sample Application Objects as they appear in the Field selection tab of the HTML Report Assistant. They are listed by Name and Type.

You add Application Objects to your report from the Field selection tab in the HTML Report Assistant. When you double-click the object you want to add to your report, it is automatically added to the appropriate list in the Field selection tab. For example, if it is a BY sort object it is added to the Sort by list.

Field options are not available for Application Objects. If you open the Field Options pane for an Application Object, the following message appears: No options are available for Application Objects. You can use Global Styling for these fields, which is available on the Report options tab.

You can search the field list on the Field selection tab, Report Headings tab, Selection criteria tab, and Join options tab (for the host Master File) in the HTML Report Assistant and HTML Graph Assistant. You can search by the following Master File attributes: Name, Alias, Title, Format, Description, Segment, and Filename.

When you apply a search to a field list, your search results appear in all other areas of the tool, until you reset the field list. Your search results are saved when you exit the tool, so when you open the procedure again, you only see the results of your search in the field list.

Note:

• The field list that appears for conditional styling is already restricted to the fields selected for the report and is not further restricted by the search string.
• Search options are available when viewing fields in List mode. It is not available when viewing fields in Tree mode.