A script-enabled browser is required for this page to function properly.

Generating delimited output

You can generate a report to delimited output using either of the following methods:

To generate delimited output from Reports Builder:

  1. In the Object Navigator, select or open the report, then click the Run Paper Layout button in the toolbar to run the report.

  2. To preview your delimited report output in a spreadsheet, choose Fileright arrowPreview Formatright arrowDelimited or
    Fileright arrowPreview Formatright arrowDelimitedData (for large volume reports).

  3. To save your delimited report output to a file, choose Fileright arrowGenerate to Fileright arrowDelimited or Fileright arrowGenerate to Fileright arrowDelimitedData (for large volume reports).

  4. In the Delimited Output dialog box or DelimitedData Output dialog box, choose from the list or type the delimiter that will separate the cells in your report output.

  5. If you want to use formatting options, choose from the list or type a Date Format Mask or a Number Format Mask.

  6. If you want to use a cell wrapper, choose from the list or type the cell wrapper that will be placed around the cell data in your report output.

  7. Click OK.

  8. In the Save dialog box, specify a location and file name. Click Save.

To generate delimited output from the command line:

You can open your delimited output file (.csv) to display it automatically in Microsoft Excel. Or, you can import the output file into an existing Excel worksheet.

Usage notes

Limitations

See also

About delimited output

Running and dispatching a report from the user interface

Running a report from the command line

Running a report using a command file

Running a report to a remote Reports Server

Generating HTML or HTMLCSS output

Generating PDF output

Generating XML output

Generating RTF output

Generating text output

Generating spreadsheet output

Distributing a report to multiple destinations

Deploying a report