> Making reports look good / Properties / CSV Options properties

In this section

Include sections

CSV Options properties

Find these properties

Select the information on your report you want to work with, then from the Properties pane view the CSV Options area. If you can't see the CSV Options title, click the Categorized button at the top of the pane.


Property

Description

Auto Arrange Z-Order

Specifies if the Z-Order of the elements are reordered in the exported file.

  • When set to False, the variables are output in their natural order in the report.
  • When set to True, the variables are output in the following order:
    1. Left to Right (X-axis).
    2. Front To Back (Z-axis).
    3. Top to Bottom (Y-axis).
Delimiter

The delimiter is the character used to separate fields in an exported CSV file; by default this is a comma (,).

Tip: Use \\t for a tab character.

Fixed Length

This property is only used when you export the file in the format CSV - Length Delimited Files.

When Fixed Length is set to True, values will be padded with extra characters to their default length; when set to False, the values will not be padded.

Include Sections

Use this property to select which sections start a new row in the exported CSV file.

See Include sections.

Numeric Qualifier

Sets the character(s) to use on either side of a number in the exported CSV file.

Output Length

The maximum length of the field when it is exported to CSV format. This is useful if you intend to import the CSV file in another application, and the field must be constrained to a certain length.

Text Qualifier

Sets the character(s) to use on either side of a text field in the exported CSV file.


Go to top