Creating the CSV source file |
To create a Tivoli Asset Management
report source file:
- From the Asset Management Reports dialog box, select a report.
- Choose Run.
Result: The Run Report dialog box appears.
- Under Destination, select File.
- Choose File.
Result: The Save As dialog box appears.
- In the File name box, type a path and name for the CSV file.
- Choose Save.
Result: The file path and name you specified appear in the File Name box
in the Run Report dialog box.
- Choose Run.
Result: A Successful message appears.
- Choose OK.
Result: The Successful message closes.
|
Mapping the CSV file to an ODBC table |
To map a CSV file to an ODBC table:
- Choose ODBC from the Run Report dialog box.
Result: The ODBC Data Source Administrator dialog box appears.
- Choose the System DSN tab.
Result: The System DSN tab appears.
- From the System Data Sources table, select TSD_REPORTS.
- Choose Configure.
Result: The ODBC Text Setup dialog box appears.
- Clear the Use Current Directory check box.
- Choose Select Directory.
Result: The Select Directory dialog box appears.
- Select the directory where your CSV file resides.
- Choose OK.
Result: The ODBC Text Setup dialog box appears.
- Choose Options>>.
Result: The Files section of the dialog box appears.
- Under Extensions List, select *.csv.
- Choose Define Format.
Result: The Define Text Format dialog box appears.
- Select a CSV file.
- Select the Column Name Header check box.
- Choose Guess.
Result: The header fields from the CSV file appear in the Columns list.
- Choose OK.
Result: The ODBC Text Setup dialog box appears. The fields in the CSV
file are automatically mapped to the ODBC driver.
- Choose OK.
Result: The ODBC Data Source Administrator dialog box appears.
- Choose OK.
Result: The Run dialog box appears.
- Choose Close.
Result: The Inventory Reports dialog box appears.
|
Accessing the ODBC table from
Crystal Reports |
To access the ODBC table from
Crystal Reports:
- From the Reports menu, choose Start Crystal Reports.
Result:The Crystal Reports window appears.
- From the Crystal Reports toolbar, choose the Create New Report button.
Result: The Create New Report dialog box appears.
- Choose Custom.
- Choose SQL/ODBC Data Type.
- Result: The Log on Server dialog box appears.
- Select the TSD_REPORTS server to log on to the server.
- Choose OK.
Result: The Choose SQL Table dialog box appears.
- From the SQL Tables list, select the CSV file you created.
- Choose OK.
Result: The Insert Database Field dialog box containing the list of
fields for the file you selected appears.
Refer to the Crystal Reports User's Guide or Crystal Reports Help for instructions on
placing the fields in the report. |