HP 3PAR System Reporter Software - Manual (Page 80)

4.6 Accessing the Optional Excel Client
3PAR System Reporter User’s Guide System Reporter 2.8
4.5 Accessing the Optional Excel Client
The 3PAR System Reporter Excel client is supported on Microsoft® Windows® systems for
creating and accessing custom reports. Microsoft® Excel® 2003 or 2007 is required but is not
provided as part of 3PAR System Reporter.
4.5.1 Starting the System Reporter Excel Client
To start the 3PAR System Reporter Excel client, use your file manager to locate the Excel
worksheet that was saved locally during the installation and access your local version.
NOTE: When using an expression pattern, you should be aware that the Web
interface uses a Regular Expression syntax for filtering whereas the Excel client
uses a LIKE operator syntax. For example, to search for an object with “DB”
anywhere in the name, the filter text would use DB for the web interface and
*DB* for the Excel client. As another example, to search for an object starting
with “DB” and ending with “12”, the filter text would be ^DB.*12 for the Web
interface and DB*12 for the Excel client. For more complex search patterns,
please refer to the Regular Expression syntax for the Web and the LIKE Operator
help in Excel.
CAUTION: Filtering large numbers of objects may exceed the limit for your server,
in which case you should reduce the number of objects being filtered and try
again.
NOTE: In order to use the 3PAR System Reporter Excel client, you must first install
and configure the Excel client as described in Installing the Excel Client (Optional)
on page 3.33.
NOTE: If you have not yet saved a version of the Excel worksheet locally, see
Installing the Excel Client (Optional) on page 3.33 for instructions on saving the
3PAR System Reporter.xls file on your local machine.