Working with Crystal Reports and Tivoli Asset Management


Overview

Tasks

Included with

Tivoli Asset Management

Overview

About using Crystal Reports to create asset reports

Use this method when the report you want to create includes data from one or more of the hierarchies.

Before you use this method for the first time, you must add the CSV (Comma Separated Value) file as a data source name through the ODBC Administrator.

To run an asset management report and use the output to create a report in Crystal Reports Professional 7.0, you must:

  1. Define and run the report from the Asset Management Reports dialog box. (Save the output to a CSV file).
  2. Map the CSV file to an ODBC table.
    Note: ODBC acts as an interface between Tivoli Asset Management and Crystal Reports.
  3. Use the ODBC table to create the report in Crystal Reports.

Tasks

Setting up Crystal Reports Click here to read about setting up the Crystal Reports interface for Tivoli Asset Management reports.
Creating a report by inserting fields from your database tables Click here to read about creating a report by inserting fields from your database tables.
Creating a report by mapping a CSV file Click here to read about creating a report by mapping a CSV file.
Creating a report using both methods You can create a report in Crystal Reports that uses both the Tivoli Service Desk database and an exported CSV file.

You must first create the CSV file and map it to the ODBC table, then launch Crystal Reports and open both the database server and the TSD_REPORTS server. You can then activate tables for each server. Refer to the Crystal Reports User's Guide or Crystal Reports Help for more information on opening the database server and the Asset CSV server.

Creating a report using the standard reports Tivoli Asset Management includes a set of standard reports for Crystal Reports Professional. You can generate these reports using the Crystal Reports program or you can compile them into executable files for users to run on demand.

The reports are located in the \TSDRPTS\TAM folder.

Report File Description
assettag.rpt Inventory items by asset tag
fulldepr.rpt Fully depreciated items
futurevt.rpt Future events by type
history.rpt Asset history
ownerbv.rpt Asset book values by owner