To view a report in Excel format
Depending on the version of Microsoft Excel that you are using, after generating a report, click the View format icon on the Reports toolbar, click View in Excel Options and select View in Excel 2007 Format, View in Excel 2002 Format, View in Excel 2000 Single Sheet Format, or View in Excel 2000 Format from the drop-down list. A new window opens. You see a window asking whether you want to open or save the file.
To view the report without saving it, click Open. The report displays as a single page in Excel format.
To save the report, click Save. The Save As window opens. Navigate to the location where you want to save the file, and enter a name in the File name field. Click Save. When the file has finished saving, you see the Download complete window.
Copyright IBM Corporation 2012. All Rights Reserved.