To Export to an ODBC data source

1. With the report you want exported active, click Export on the Standard toolbar.

   The Export dialog box appears.

   {bmc bt_expor.gif}

2. 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.
3. 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.
4. 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.
5. 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.

6. 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.