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.
- Bursting is
not supported.