Reports › The Data Browser › Result Sets › Export a Result Set

Export a Result Set

You can use the Export from Data Browser dialog to export a result set generated by the Data Browser to a comma-separated values (CSV) or HyperText Markup Language (HTML) file. You can also export a result set to RPTwin or another application that supports Dynamic Data Exchange (DDE), such as Microsoft Word.

To export a result set from the Data Browser

1. Click Data Browser on the Standard toolbar.

   The Data Browser opens.

2. Double-click on a report.

   The result set displays.

3. On the File menu, click Export.

   The Export from Data Browser dialog opens.

4. Select one of the following options in the Export format list:
   • HTML

     Generates an HTML file. The resulting output can be displayed in any Web browser or imported into another application such as Microsoft Word or Excel.

   • DDE

     Outputs the result set to another application that supports Dynamic Data Exchange (DDE) such as Microsoft Word.

   • CSV

     Generates a comma-separated values (CSV) file. The resulting output can be imported by most spreadsheet applications including Microsoft Excel.

   • RPT Win

     Outputs the result set to RPTwin.

   • BRS File

     Outputs the result set to a BRS File.

5. Select one of the available options in the Presentation group box:
   • Tabular

     Exports the result set in a tabular format similar to the manner in which the result set is displayed on screen.

   • Tabular with duplicates

     Exports the result set in a tabular format in which all values display, including those that are duplicated.

   • Master-detail

     Exports the result set as a mix of headings and subtables. The Data Browser uses the relationships between model components to determine which values are printed in headings and which values are printed in tables.

   • Indented

     Exports the result set as a mix of headings and lists. The Data Browser uses the relationships between model components to determine how the values are indented.

   • Item per line

     Generates a result set as a list with one item on each line.

6. Select one of the following options in the Export to group box:
   • File

     Exports the result set to a file.

   • Clipboard

     Exports the result set to the Clipboard. This option is not available if you select DDE or RPTwin as the export format.

7. Click Export.

   The result set is exported.