Data displaying in a gadget is a result set from the gadget’s data source. Report and data visualization gadgets can export these result sets in the following formats: Comma (CSV), Pipe (PSV), Tab (TSV), and Semicolon (SSV). This data downloads as a file.

If you export column headers with the data, you can select to export the column name or the display name. For example, if you export aggregated data from a flex table gadget and the column name is SUM(sold), exporting the column name gives the header name sold and exporting the display name gives the header name SUM(sold). Seeing the display name is useful when there are multiple aggregations of the same column data, such as SUM(sold), AVERAGE(sold) and MAX(sold).

Exported data can open in the user’s default viewing software for the selected data format. For example, after viewing a report of orders by a specific customer, the user wants to export a list of the order numbers to include in an e‑mail.

Exporting data from data visualization gadgets displays all result sets from all of your gadgets. Choose the name of the gadget from Available Resultsets to download the selected data. Chart gadgets export only their result set data while they are in minimized form.

Exporting data from report or reportlet gadgets displays all result sets within the displayed BIRT document. Choose the result set from Available Resultsets to download the selected data.

Table 4‑4 lists gadgets that support exporting their data in different formats.

For more information about exporting data from a gadget, select Online help in Export Data, as shown in Figure 4‑56.