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 enables you to drag data fields within a PivotTable, providing different views of the data, such as sorting across rows or columns.

Suggested Uses: Email, Report Library.

Considerations:

• When the format of an EXL2K PIVOT report is not overridden in the schedule, the Report Library will display EXL2K as the format.
• Microsoft Excel 2000 or higher must be installed.
• 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.
• The format is ASCII.
• Requires the WEBARCHIVE=ON command so that the Reporting Server creates a single output file, rather than a main file and a cache file. The default Reporting Server configuration is WEBARCHIVE=ON.
• All EXL2K output with an .xht extension is dynamically changed to .xls for email or FTP distribution. You must edit your web server MIME table so that the .xls extension is ASCII application data, instead of binary.
• Cannot be used to schedule a compound report.
• The scheduled procedure must contain a PCHOLD statement, such as the following:

  ON TABLE PCHOLD FORMAT EXL2K PIVOT

• Bursting is not supported.