Datasheet

Exporting to an ODBC data source allows you to:
• Change data from a centralized database format into a format compatible with a local DBMS
application.
• Change data from a local database format into a format compatible with a centralized database.
• Create a new database table that can be used as a separate data set in future reporting.
• Create a mini data-warehouse.
• Manipulate database data by filtering records, adding formulas, and removing fields to create a new
database table that provides the data you need most for your work.
To export to an ODBC data source
1.
With the report you want exported active, go to the File menu, point to Export, and then click Export
Report.
Tip:
Another way to do this is to click the Export button on the Standard toolbar.
The Export dialog box appears.
2.
From the Format drop-down list, select ODBC.
Note:
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.
3.
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 ODBC Formats 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, a Cross-Tab, or an OLAP grid, you will be unable to export it to
an ODBC data source successfully.
18.1.3.2 Destination
2011-05-16387
Printing, Exporting, and Viewing Reports