Setting Up Crystal Reports for Asset Management


Overview

Tasks

Included with

Tivoli Asset Management

Overview

About setting up Crystal Reports for Tivoli Asset Management Before you can access Crystal Reports Professional 7.0 through an ODBC table for each licensed workstation, you must install Crystal Reports Professional 7.0 and set up the required ODBC driver.

Tasks

Installing Crystal Reports You must install a licensed version of Crystal Reports 7.0 on each report writer's workstation. Follow the installation instructions provided with your Crystal Reports 7.0 software.
Adding Crystal Reports to the PATH statement After you install Crystal Reports, you must add the path for crw32.exe to your autoexec.bat PATH statement. This allows Tivoli Service Desk to launch Crystal Reports from the Reports menu. In the following example, the PATH statement indicates that crw32.exe resides in the \CRW folder.
PATH=C:\TIVTSD\WINASE32;D:\ORAWIN\95\BIN;C:\CRW;
Installing the Microsoft text driver The compressed file for the Microsoft Data Access Pack is automatically installed with Tivoli Asset Management.
To install the Microsoft Text and HTML driver:
  1. From the Start menu, choose Run.
    Result: The Run dialog box appears.
  2. In the Open box, type the path for the Microsoft Data Access Pack compressed file:
    <drive>:\TIVTSD\TAM\MSFTODBC\Wx1350.exe
    (where <drive> is the drive letter where your TSD99 folder resides)
  3. Choose OK.
    Result: The file contents are extracted.
  4. From the Start menu, choose Run.
    Result: The Run dialog box appears.
  5. In the Open box, type the path for the Microsoft Data Access Pack:
    <drive>:\TIVTSD\TAM\MSFTODBC\dataacc.exe
    (where <drive> is the drive letter for where your TSD99 folder resides)
    Result: The Microsoft Data Access Pack dialog box appears.
  6. Choose Yes.
    Result: The Microsoft Data Access Pack Setup dialog box appears.
  7. Choose Add/Remove.
    Result: The Microsoft Data Access Pack - Maintenance dialog box appears.
  8. If you do not want to install the SQL Server driver, under Options, clear the SQL Server Driver check box.
    Note: If you clear the SQL Server Driver check box and you are currently using the driver on your system, the Data Access Pack program attempts to remove the driver.
  9. Under Options, select the Data Access Drivers check box.
  10. Choose Change Option.
    Result: The Microsoft Data Access Pack - Data Access Drivers window appears.
  11. Select the Microsoft Text and HTML Driver check box.
    If desired, clear the check box for any other drivers you do not use or need.
    Note: If you clear a check box for a driver and you are currently using the driver on your system, the Data Access Pack program attempts to remove the driver.
  12. Choose OK.
    Result: The Microsoft Data Access Pack - Maintenance dialog box appears.
  13. Choose Continue.
    Result: If you cleared the check box for any installed drivers, a Confirm Component Removal message appears.
  14. Choose Yes.
    Result: The Microsoft Data Access Pack Setup dialog box appears, indicating the setup was completed successfully.
  15. Choose OK.
Creating a TSD_REPORTS data source You must create an ODBC text driver data source to use when working with asset management reports or other CSV files in Crystal Reports.
  1. In Windows 95, Windows 98, or Windows NT 4.0, from the Start menu, point to Run, type odbcad32.exe, then choose OK.
    Result: The ODBC Data Source Administrator dialog box appears.
  2. Choose the System DSN tab.
  3. Choose Add.
    Result: The Create New Data Source window appears.
  4. From the table, select Microsoft Text Driver (*.txt;*.csv).
  5. Choose Finish.
    Result: The ODBC Text Setup dialog box appears.
  6. In the Data Source Name box, type TSD_REPORTS.
  7. In the Description box, type a description of the data source name.
  8. Choose OK.
    Result: The ODBC Data Source Administrator dialog box appears.
  9. Choose OK.
    Result: The ODBC Data Source Administrator dialog box closes.
Creating an ODBC data source You must create an ODBC data source to use when working with your database tables in Crystal Reports.

To create a data source:

  1. In Windows 95, Windows 98, or Windows NT 4.0, from the Start menu, point to Run, type odbcad32.exe, then choose OK.
    Result: The ODBC Data Source Administrator dialog box appears.
  2. Choose the System DSN tab.
    Result: The System DSN tab appears.
  3. Choose Add.
  4. Result: The Create New Data Source window appears.
  5. From the table, select the driver for your database.
  6. Choose Finish.
    Result: The ODBC driver setup dialog box for your database appears.
  7. In the Data Source Name box, type DBCRYSTAL.
  8. In the Description box, type a description of the data source name.
  9. In the Server Name box, type name of your database server.
  10. Choose OK.
    Result: The ODBC Data Source Administrator dialog box appears.
  11. Choose OK.
    Result: The ODBC Data Source Administrator dialog box closes.