HP System Reporter Media Kit Customizing Excel Reports, Adding Custom Columns to a Data Sheet

System Reporter 2.8 3PAR System Reporter User’s Guide

1Click on the appropriate tab at the bottom of the screen to access the report you want to save as an executable file.

2Click on the Windows Office Button in the upper right corner.

3Choose Save As, then select Microsoft Office Excel Workbook (for Excel 2007, you also have the option of saving as (Excel Macro Enabled Workbook).

4Assign a name to the file and click Save.

5.4.5Customizing Excel Reports

Read this section for information on customizing the charts used to plot the results of database queries initiated with the 3PAR System Reporter Excel client.

To customize a chart, you must edit the data sheet associated with that chart. Customized charts typically make use of custom columns added to a data sheet.

NOTE: The Visual Basic code for the Excel client is password protected to prevent accidental modification. For customers who would like to add their own code, the password is “password”. Please observe caution when considering using another password other than the default, since subsequent access would not be possible if knowledge of the altered password were to become unavailable for some reason.

5.4.5.1 Adding Custom Columns to a Data Sheet

The following instructions illustrate how to add custom columns to a data sheet. In this example, you will add the custom columns Non-failed spare and Percent spare used to the Dly PDSpace (1) sheet. In the following section, Creating a Custom Chart on page 5.58, you will create a custom chart using one of these new columns.

NOTE: User defined columns can only be added as the last column in the data sheet.

To add custom columns to the Dly PDSpace (1) sheet:

1 On the PD Space reporting tool sheet, create a chart with data that spans any time range.

Working with Excel Charts

5.57