Configuring Interactive Grid Download Formats

Enable users to download an interactive grid to specified download formats.

To configure interactive grid download formats:

  1. View the page in Page Designer:

    Page Designer appears.

  2. In the Rendering tab, select the region containing the interactive grid.

  3. In the Property Editor, select the Attributes tab.

    The Property Editor displays the attributes. Attributes are organized in groups

  4. In the Property Editor Attributes tab, find Enable User To and edit the following:

    • Download - Select On.

    Tip: Setting Download to Off prevents the Download menu from displaying on the Actions menu. To fully prevent users from downloading data, deselect all Download Formats described in the next step.

  5. Find Download and edit the following:

    1. Authorization - Select an authorization scheme to restrict who can download. To enable an end user to download, this authorization scheme must evaluate to TRUE for that user.

    2. Formats - Select download formats:

      • CSV

      • HTML

      • PDF

      • Excel

    3. Send as Email - Specify whether end users can send an email, with the report download included as a HTML attachment.

      Email is only available to authenticated users, and requires the SMTP to be configured within APEX Administration Services application (Administration Services), by an Instance Administrator.

    4. CSV Separator - (CSV only) Define the column separator. If no value is entered, a comma or semicolon is used depending on your current NLS settings.

    5. CSV Enclosed By - (CSV only) Enter a delimiter character. This character delineates the starting and ending boundary of a data value. Default delimiter is double quotation marks (“ “).

    6. Filename - Enter a name for the downloaded document. Do not specify a file extension, the extension is added automatically. If you leave this blank, the region name is used as the file name.

    7. Supplemental Text - Enter text that displays at the top of the download file. Use this attribute to for data classification, legal, or warning messages about the data in the file.

      WARNING: Do not use the Supplemental Text attribute with CSV download. If you enable CSV download, the defined text will invalidate the CSV file format.

  6. To save your changes click Save. To save and run the page, click Save and Run Page.