WebFOCUS Online Help > ReportCaster Development and Administration > ReportCaster Formats for Scheduled Output > EXL2K PIVOT

Format: EXL2K PIVOT (.xls)

Description: Scheduled output opens within Excel 2000 or higher.

Used to analyze complex data much like the OLAP tool in WebFOCUS. It allows you to drag and drop data fields within a PivotTable, providing different views of the data, such as sorting across rows or columns.

Suggested Uses: E-mail, Library

Considerations: Microsoft Excel 2000 or higher must be installed. The format is ASCII.

The procedure you are scheduling must contain the SET WEBARCHIVE=ON command. This command ensures that the WebFOCUS Reporting Server creates a single output file rather than a main file and a cache file.

All EXL2K output with an .xht extension is dynamically changed to .xls for e-mail or FTP distribution. You must edit your Web server MIME table so that the .xls extension is ascii/application data instead of binary.

Bursting is not supported.

Must be using Microsoft Office 2000 at a minimum release level of 9.0.3821 SR-1 in order to open in the Report Library.