To Export to an ODBC data source
-
With the report you want exported active, click Export on the Standard toolbar.
The Export dialog box appears.
{bmc bt_expor.gif}
- From the Format drop-down list, select the ODBC data source for the format in which you want to export your report. For example,
ODBC - CRSS allows you to export your report to a Microsoft SQL Server database.
- Destination is ignored when you are exporting a report to an ODBC data source. You do not need to make any changes to the Destination edit box. Click OK in the Export dialog box.
- If your ODBC data source specifies a particular database, the report will be exported to that database. Otherwise, the Select Database dialog box appears. Select the database to which this report will be added as a new table, and then click OK.
- If the ODBC data source you selected requires a Logon ID and password, the Login or SQL Server Login dialog box appears. Enter your ID and Password, and then click OK.
The Enter ODBC Table Name dialog box appears.
- Enter the name you want to give to the new table in the database, and then click OK.
The program exports the report as a new table to the database you specified.
Note: If your report contains a binary field, you will be unable to export it to an ODBC data source successfully.