Editing the Report Definition

A report definition contains information about a One View report, such as which columns were selected from the data model, the naming convention that was used, the row setting, the name of the report, and so on. You use the report definition side panel to create or modify a report definition.

Note: You cannot edit a One View report definition when using a List View grid format because the Report Definition tab is not available in a List View grid. This means that you cannot perform any of the functions discussed in this section, such as save, save as, reserve, request to publish, delete, etc. Change your grid format to a Table View in order to access the Report Definition tab. For more information, see "Grid Formats" in the JD Edwards EnterpriseOne Tools Using and Approving User Defined Objects Guide. (Tools Release 9.2.0.5)

This is an example of the Report Definition tab:

The Selected Columns portion of the Report Definition side panel displays the columns that were selected for the report. You can remove a column from the report definition by clicking it. To include additional columns in the report definition, click any QBE column header with a plus (+) sign. Additionally, you can perform the following tasks using some of the icons on the Report Definition tab:

• Copy an existing report.

• Request to publish a personal or reserved report to a shared report.

• Sync a report to the data dictionary item naming convention.

• Add all columns in the data model to the report definition.

• Remove all columns in the data model from the report definition.

• Delete a report.

The following table describes the report definition tab:

Report Definition Options	Description
Name	The name of the report.
Naming Convention	You can select one of two options when adding a new report: Use Column Title For companies with one language preference, end users usually prefer to use column titles when designing reports. If the column title accurately describes the data item, it is more understandable than the data dictionary item name. Use Data Dictionary Item Name Developing new reports using data dictionary item names is the preferred method for companies with more than one language preference. Reports that are based on the data dictionary item names are more easily translatable.
Select Default Row Set to Run Report	Three row set options are available for the grid data that is used in reports: Retrieve record count The report displays data up to the number of records specified, even if more records exist that match the query conditions. Retrieve record count = 500 is the default unless it is configured differently for your company. You can override the default setting when you run a report or add a new report. Use current data in grid The report displays the data currently shown in the grid. Retrieve all records The report displays all data matching the current query condition.
Selected Columns	The columns selected from the data model for the report.
Drill Back Link Composer	This section is used to compose drill back links. This feature enables you to trace and investigate transactions by drilling from a specific row in a One View report table back to the source transaction in the JD Edwards EnterpriseOne application. For more information, see Working with the Drill Back Feature

Note: Oracle recommends that anytime you want to modify a report delivered by JD Edwards, you should copy the report to a new name and then modify the copy. By following this procedure, any modifications you make will not be overwritten if JD Edwards delivers an update to the report.