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.
- 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.
- 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.