Display Settings

In Display Settings, you can set the View Type, Currency, and other options. You can also create a composite report or composite XML report.

1. In the report that you are editing, click Report Settings > Display Settings.

2. Select the View Type you want:

   • Spreadsheet: Use the default system browser view of your report. This view is similar to a Microsoft Excel spreadsheet. Each result appears as a row in the report.

   • My Layout: Open the My Layout report view in your browser with a similar appearance to a Summary page layout. You can create your My Layout report layout in the Preview pane.

     To edit Math fields in My Layout reports, either click Pencil icon next to the field name in the Fields pane, or edit the field from the Edit Field-Level Filters and Details window.

     You cannot combine the My Layout output type with the Display multiple values in separate cells setting.

   • Excel: Create a Microsoft Excel file of the report when it is generated. Each result displays as a row in the spreadsheet.

   • XML: Create an XML file of the report when it is generated.

   • Flat File: Create a flat file of the report when it is generated.

     A flat file is a structured text file containing spreadsheet-like data. A flat file is typically composed of a header row followed by data rows with specific characters used to delimit rows and columns within a particular row.

   • Composite: A Composite Report is a report that consists of two or more reports run simultaneously. You can create this when the records need to be filtered with an OR function rather than an AND function.

   • Composite XML: Create a composite report with an XML output.

3. Select the Currency you want.

   This converts currencies based upon the exchange rate specified at the firm-level. If there is no exchange rate specified at the firm level, Report Builder uses the exchange rate listed for the specified currency on Fixer.io.

4. To display the exchange rate used to convert currency columns in the report, select Show exchange rate conversion information.

   This adds a column to the right of a column with a currency value . The column contains the exchange rate to convert the value.

5. Select or clear these options:

   • Display Report Filters: Display report filters in your report output. Java filters do not display in the filter list.

   • Display multiple values in separate cells: Fields with multiple values display each value in a separate cell. If you intend to select Microsoft Excel as your report view type, select this option.

   • Allow field edits on generated report?: Allow edits on certain fields in your report. Editing fields in a report changes the data in your system.

   • Auto Open for sub rows: Automatically display sub rows in a report.

   • Append Run Time Details to Title: Include the run date and time of the report in the name of the report.

   • Hide Border Lines: Hide the grid lines around cells in your report. This option is only available for the My Layout report view type.

   • Show Row Number: Display the row number for each row in the report.

   • Show negative values with minus sign: In Roll Forward Lease Report (RFR), show negative values with a minus sign.

6. Click Finish.

7. To save your changes, click Save in the header of the Report Builder, to the right of the report name.

Configure Flat File Properties

1. After selecting Flat File, click Flat File Properties.

2. Select the options you want:

   • File Begins with SOH and ends with EOH: Use an SOH delimiter to indicate the beginning of the flat file and an EOH delimiter to indicate the end of the flat file.

   • Include Header Row: Include a header row in the flat file.

3. Select the record delimiter from the Record Delimiter field.

   The available options are:

   • CRLF

   • CR

   • LF

   • STX/ETX

4. Select the Delimiter.

   • Field Delimiter Character:

     1. Select Field Delimiter Character.

     2. Enter the Field Delimiter Character.

   • Field Delimiter Hex Value:

     1. Select Field Delimiter Hex Value.

     2. Enter the Field Delimiter Hex Value character.

5. Click Update.

Composite Reports

A composite report is a report that consists of two or more reports run simultaneously. This is usually done when the records need to be filtered with an OR function rather than an AND function. A composite report can be created in Spreadsheet format or XML format. In the sections below, the composite report itself—which contains two or more component reports—will be called the Main report, and any component report will be called a Part report.

Naming Conventions describes our recommendations for naming composite reports and their component reports.

When working with Composite reports, consider the interaction of field filtering criteria between the Main report and the report Parts. Keep the following notes in mind when building your report:

• Both static and search / runtime filtering criteria are passed from the Main report to the report Parts.

• If the field’s report label matches in the Main report and one of the Part reports, the field's filtering criteria from the Main report overrides any filtering criteria (or lack thereof) in the Part report. This is true even if the same label is used for two different fields.

  Despite this, we recommend including search / runtime filters on all relevant fields in the report Parts for clarity.

• If the field's report label does NOT match in the Main and Part, the field’s filtering criteria from the Main report will NOT override static filtering criteria (or lack thereof) in the Part.

• Date fields with the in date filter range option selected in the report Part do NOT need to be added to the Main report to be filtered correctly. However, the Include date range filter in the Edit Runtime Filters window must still be selected in the Main report.

Examples

Create a Composite Report or Composite XML Report

Do not cross tables in composite reports.

1. In the Included Reports table that displays after selecting Composite or Composite XML, select a report you want to run simultaneously in Select Report to Add.

   An additional Select Report to Add displays.

2. Repeat the previous step until you have added all reports you want to run.

   To remove a report from the Included Reports table, click Remove Sub Report in the report title.

3. Select Append Run Time Details to Title to include the report run date and time in the name of the report.

4. Select Show Row Number to display the row number for each row in the report.

5. If creating a Composite XML report

Edit Start / End Tags of an XML or Composite XML Report