HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Building Reports Using the Web Intelligence Java Report Panel 399
• Microsoft Excel spreadsheets
• Adobe Acrobat PDF files
Saving Web Intelligence documents as Excel Spreadsheets
Creating a copy of your documents as a Microsoft Excel file is especially useful if you want
to combine the information in your Web Intelligence document with other data in an Excel
spreadsheet.
Unlike Web Intelligence documents, the Excel files are not connected to the database. This
means you cannot refresh the data in the Excel file. To display up-to-date data in Excel
format, refresh the Web Intelligence document and then save it as a new Excel file.
Note: When you name reports in a document that you want to save as an Excel
spreadsheet, the names of reports must not include more than 31 characters or include
spaces or the following special characters: * : \ / [ ]
Note: Dates prior to 1900 do not display correctly in Excel.
Saving a Web Intelligence document as an Excel spreadsheet
To save a Web Intelligence document as an Excel spreadsheet:
1. Click the arrow next to the Save button on the Web Intelligence toolbar.
2. From the Save menu, select Save to my computer as...
The Excel and PDF format options appear.
3. Select As Excel.
Web Intelligence generates a copy of your document in Microsoft Excel Format. Each
report within the Web Intelligence document converts to a separate Excel worksheet
within the Excel file.
You can save the document using the Excel Save menu. The file has the standard
Microsoft Excel file extension: xls.
NOTE: Some Web Intelligence chart formats do not exist in Excel format. These
charts are automatically converted to the closest corresponding chart format
available in Excel.
To share Excel files with other users, you can save them to InfoView. For more
information, see the BusinessObjects Enterprise InfoView User’s Guide.
Generating Web Intelligence documents to PDF
Creating a copy of your documents as a PDF file is especially useful if you want to provide
other users with the document information in a printable format. The page layout and
formatting of the Web Intelligence document is retained in the PDF file.