Analysis Grid Developers - Configuring Exporting Data

The Analysis Grid can be configured by the developer to include options to export table data to three formats: Excel, CSV, and PDF:

In all cases, the exported file is written to a temporary file, which is then opened in the browser or related application for display, manipulation, printing, or storage.

Developers can optimize Excel exports by adding an Excel Column Format element to each grid column, as shown above. This provides developers with full control over the layout and appearance of exported data in the worksheet. The element's Data Type attribute is especially useful for ensuring that data is correctly formatted when it arrives in Excel. There are no export-specific elements for the other export formats.

Export Threshold

When working with very large data sets, exports may not be practical. Developers can control this using the Analysis Grid element's Max Rows Export attribute specifies the maximum number of data rows that can be exported.

When the number of rows in the Analysis Grid's main table is equal to or less than this value, exports will be enabled; if the number of rows exceeds this value, exports are disabled. This allows developers to prevent users from running export requests that will take an unacceptable amount of time. The default value for this attribute is 100,000 rows.

If the special value -1 is entered, the default maximum limit is removed, allowing allrows to be exported.

At runtime, users can reduce the number of rows in the Analysis Grid's main table, and thus enable exports, by adding one or more Analysis Grid filters.

Rapid Export Options

Excel and CSV exports can also be configured for Rapid Export, which provides a faster mechanism for exporting large datasets. The Rapid Export feature honors basic formatting (bold, font, italics, etc), but it does not apply custom styling or group aggregation.

You cannot export a report with more than one Data Table.

In Info Studio, you can set the new attribute on the Target .NativeExcel and Target.CSV elements called ExportDataPreference (Formatted, Empty {default}, or Rapid ). This preference can be set on a global application level by setting a restricted constant called rdExportDataPreference to Rapid, like below:

The default value for the above constant is empty.

For more information, see Rapid Excel Export and Rapid CSV Export.