Viewing Report Data

You can view inventory reports in Extensible Markup Language (XML), Adobe Acrobat Portable Document Format (PDF), Microsoft Excel, or text format. If you select PDF or Excel format, depending on the client (browser and operating system) MIME setting, Acrobat Reader or Excel will either appear inside the browser, or run as a standalone application.

XML

To view a report in XML, follow these steps:

  1. Select and open the report you want.
  2. In the Report Result window, click XML. The report appears in the Report Result window in XML. Save it using the File > Save menu of the browser.

Microsoft Excel

To view a report in Microsoft Excel, follow these steps:

  1. Select and open the report you want.
  2. In the Report Result window, click Excel. Microsoft Excel opens and displays the current report. You can manipulate the report in Excel, and save the file in XLS file format.

    When you convert a report such as All Inventory Events to Microsoft Excel format, the time and date records in the Time column may not appear in the correct format. To format the Time column records correctly, follow these steps:

    1. In Microsoft Excel, select the Time column.
    2. Right-click to open the Format Cells dialog box.
    3. Click the Number tab.
    4. Select Time in the Category list box.
    5. Select the correct time and date format in the Type list box.
    6. Click OK.
    7. Adjust the width of the Time column, if necessary, so that the entire value can be displayed.

      If the width of the Time column is narrower than the time value being displayed, a series of #### characters appear.

Adobe Acrobat PDF

To view a report in Adobe PDF, follow these steps:

  1. Select and open the report you want.
  2. In the Report Result window, click PDF. Adobe Acrobat Reader opens and displays the current report. You can manipulate the report in Adobe Acrobat, and save the file in PDF file format.

Text

You can view Inventory Management System reports in text format.

Note: You can view reports in text format for all report types except Hardware Inventory Summary and Licensing Inventory Summary.

Table 30 describes the supported text format.

Table 30: Report Text Formatting Options

Text Format

Option

Description

Encoding

ISO-8859-1

Also called ISO-Latin or Latin-1, this character set is used for HTTP (the transport protocol for Web documents) and is also used in the creation of HTML documents.

US-ASCII

American Standard Code for Information Interchange, the standard character set for use on the Internet.

UTF-8

8-bit Unicode Transformation Format, a lossless, variable-length character encoding for Unicode.

UTF-16

16-bit Unicode Transformation Format, a character encoding form that provides a way to represent a series of abstract characters from Unicode and ISO/IEC 10646 as a series of 16-bit words suitable for storage or transmission by way of data networks.

Line separator

DOS

DOS and Windows operating systems use carriage return and line feed (CR/LF) as the line separator.

UNIX

UNIX uses LF as the line separator.

Separator character

, (comma)

Character used to separate report data columns.

 

; (semicolon)

Character used to separate report data columns.

tab

Character used to separate report data columns.

| (pipe)

Character used to separate report data columns.

space

Character used to separate report data columns.

none

No character used to separate report data columns.

Include titles

Yes

Includes report data column titles.

 

No

Does not include report data column titles.

To view a report in text format, follow these steps:

  1. Select and open the report you want.
  2. In the Report Result window, click the Text options that you want.
  3. Click Get Text.