Creating a Crystal Report by Inserting Fields from Your Database


Overview

Task

Included with

Tivoli Asset Management

Overview

About inserting fields from the database tables Use this method when the report you want to run does not contain data for the flexible attributes or data from one or more of the hierarchical data structures (locations, categories, organizations, and connections).

Task

Inserting fields from the database tables To create a report in Crystal Reports using your database tables:
  1. From the Reports menu, choose Start Crystal Reports.
    Result: The Crystal Reports Professional window appears.
  2. From the File menu, choose New.
    Result: The Report Gallery dialog box appears.
  3. From the Report Gallery dialog box, choose Custom.
    Result: Additional report types appear.
  4. Choose SQL/ODBC Data Type.
    Result: The Log on Server dialog box appears.
  5. Select the ODBC Database data source you set up previously.
  6. Choose OK.
    Result: The Logon dialog box appears.
  7. Type your login information.
  8. Choose OK.
    Result: The Choose SQL Table dialog box appears.
  9. From the Choose SQL Tables list, select the table to use for creating the report.
  10. Choose OK.
    Result: The Insert Database Field dialog box appears with the list of fields for the table you selected.

See your Crystal Reports documentation or Crystal Reports Help for instructions on placing the fields in the report.