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