## Export to Text dialog

This dialog appears when you click File > Export To > Text. It helps you to export a report to a Text file. See the dialog.

The following are details about options in the dialog:

Export to

Specifies the directory in which to place the exported Text file.

Delimited Format

Specifies whether to use the delimited format to export the report result.

- Format
  Specifies the delimiter to separate fields.
  - CSV Delimited
    Fields in the exported Text file will be separated by a comma.
  - Tab Delimited
    Fields in the exported Text file will be separated by a tab.
  - Customize Delimited
    Fields in the exported Text file will be separated by a user defined delimiter. You can type your own delimiter in the Delimiter box (note that the delimiter should be only one character).
- Use Quote mark
  Specifies whether the fields in the exported Text file will be marked with quotation marks.
- Repeat Last Column Value If Null
  If checked, when a cell in the exported CSV Text has no value, value of the previous cell in the same column will be used.

User Defined Density

Specifies whether to use user defined density to export the report result.

- Horizontal Density
  Specifies the value for each unit of the horizontal density between columns. The resulting density is a direct ratio of the value you specify. That is, the greater the value, the smaller the width between columns.
- Vertical Density
  Specifies the value for each unit of the vertical density between columns. The resulting density is a direct ratio of the value you specify. That is, the greater the value, the smaller the height between columns.

Notes:

- By exporting using user defined densities, if the densities are not set appropriately, the fields in the report may overlap each other, so you are not recommended to use this way to export the report result to Text.
- When setting the value of Horizontal/Vertical Density, you need to pay attention to the following:
  - The value of Horizontal/Vertical Density must be greater than the character's width/height of the smallest field in the report (smallest field is the field with the smallest font size), otherwise, the value you set will not be applied.
  - If the value of Vertical Density is greater than 0 and the value of Horizontal Density is less than 0, the value that you specify for the Vertical Density will be applied and the value of Horizontal Density will be specified by JReport.
  - If the value of Vertical Density is less than 0 and the value of Horizontal Density is greater than 0, the value that you specify for the Horizontal Density will be applied and the value of Vertical Density will be specified by JReport.
  - If the values of Vertical Density and Horizontal Density are both greater than 0 and the value of Horizontal Density is less than 11, the specified value of the two densities will be applied. Otherwise, they will be specified by JReport.
  - If the values of Vertical Density and Horizontal Density are both less than 1, these densities will be specified by JReport.

Compress

Specifies whether to generate the report result to Text format in a compressed size, that is to say, there will be no clearance between the columns.

Header and Footer

If checked, the exported file will contain all headers and footers in the report, including Report Header/Footer, Page Header/Footer and Group Header/Footer. Otherwise, the exported file will only contain data in Detail panel.

Windows End-of-line (CR-LF)

Specifies whether to use the CR-LF in Windows convention as the end-of-line character.

Unix End-of-line (LF)

Specifies whether to use the LF in Unix convention as the end-of-line character.

OK

Applies all changes and exits the dialog.

Cancel

Cancels the changes and exits the dialog.

Help

Displays this help document.