Escape Quotes

If enabled, this setting adds an extra pair of double quotes around any part of a field value that’s already double quoted. This ensures that the double quoted portion is treated as part of the same field, and displayed with quotes, rather than a separate field.

Include Headings

Use this to show or hide report table headings. If enabled, the first row of the CSV file will be the column heading names. This also works for cross tab reports, in which case the row heading names are also included.

Character Set

Select the character set with which to encode the export file. Using the right character encoding set is essential if the exported file is to be reused in other applications that use a particular file encoding. 

Tip: Yellowfin uses the standard UTF-8 for storing double-byte characters.

Select from CR, CRLF and LF as line break characters for carriage returns. This is a useful setting when working with third-party tools which may require a specific carriage return type to correctly process CSV files.

Field Separator

This is the character that will be used to separate individual fields (or data values) in the exported CSV file. Choose predefined separators, such as comma, semicolon, tab, or define a custom separator character.

Field Separator Character

If the ‘Other’ option was selected for Field Separator definition, then specify a character to be used to separate values.

This could be any character, alphabet, number; you are also able to specify multiple characters.

Quote Commas

This will add Field Enclosure characters around any field value which contains commas, if enabled. This ensures that values containing commas are not treated as separate values before and after the comma. 

This is ideal for numeric values such as invoices that contain commas, eg: $6,328,754.

Quote all Values

This toggle will add Field Enclosure characters around all individual fields. 

If this toggle is enabled, the Quote Commas option will be switched off.

Field Enclosure

This is the character used to quote individual field values if either the Quote Commas or Quote all Values settings are switched on. 

Choose pre-defined enclosures such as single or double quotes, or define a custom enclosure character.

Field Enclosure Character

If ‘Other’ is selected for the Field Enclosure character then specify a character to be used to quote fields in. This could be any character, alphabet, number; you are also able to specify multiple characters.

Conditional Formatting Icon Export

If your report uses conditional formatting to display icons instead of data, enabling this option will ensure that those icons are exported. Disabling this option will ignore any conditional formatting and instead use the original data values.

Page Size

Select the page size for your PDF file. This allows other layout settings to be configured properly.

Orientation

Choose the orientation of your file.

Use Default Layout Values

This toggle lets you alter the default system layout settings for this exported PDF. It does not update the system defaults.

If disabled, the options below will appear.

Shrink to Fit Page Width

If enabled, the report content will be shrunk to fit the page width.

Report Section Page Break

If enabled, this option creates page breaks for report sections. This ensures that each new section in a report will start at the top of a new page.

Note that Yellowfin splits the report table when report sections are defined, creating a separate table for each report section.

Co-Display Report Page Break

If enabled, this option creates page breaks for co-display reports. This ensures that each co-display report will start from the top of a new page in the exported PDF.

Secure PDF

Allows you to secure a PDF with password protection.

PDF Password

If Secure PDF is enabled, enter a password to open secure files. 

Keep Formatting

This allows any formatting done on values to be retained when they are exported. Formatting includes prefixes, suffixes, or thousand separators in numeric values, a date format applied to date fields, or links added to text fields.
Note that formatting in numeric values will be retained, however the values will be exported as text. For example, invoice data with currency prefix and separators ($100,000,000) will be exported as text instead of a numeric value.

Disable this to export raw values, without any formatting. In the above example, the values will be exported as numbers - provided Excel identifies them as numeric values. For instance, the above example will be exported as 100000000.

Format Column and Row Size

Enabling this will adjust the column widths and row heights to best fit the content in the Excel file. This allows all the content to be visible without opening the cells to see more in case of long text values. This will take longer to export content, however will make the file look neater and easier to read.

Disable this to save export time in case of a large file.

Export Tabbed Co-Displays

This setting is suitable for tabbed co-displayed reports that have separate reports that are brought up by navigating through tabs. The toggle will enable such reports to be exported in the same way, where each report will be in a separate Excel tab.

If this is disabled, then only the main report will be exported.

Wrap Text

Enable this toggle to  wrap long lines of text when exporting a report to XLSX. The text limit can be defined by the user in the Wrap Length field. Note that this is not supported for merged cells.
This ensures that if a text is too long, the line will be broken after a specified limit, moving the remaining to the next line. In case of long text, the cell height will be expanded vertically to display the entire text.

Wrap Length

If text wrapping is enabled, provide the maximum number of characters in a column after which the line will break and move the remaining text to the next line.