Creating CrossTab reports by using ODBC data sources
With Quattro Pro, you can create CrossTab reports using Open Database Connectivity (ODBC) data sources, such as a Paradox or Microsoft Access database. This allows you to generate a CrossTab report based on the database tables and fields that you choose. In addition, you create a CrossTab report based on a query. You may find it useful to create a query if you are retrieving data from more than one table. For more information about creating queries, see “Querying external databases.”
To create a CrossTab report by using an ODBC data source |  |
|
1.
|
|
Click Tools
 Data tools CrossTab Report. |
|
2.
|
|
Enable the External data source option.
|
|
3.
|
|
Click Next.
|
|
4.
|
|
Choose ODBC from the Data type list box.
|
|
5.
|
|
Choose a Database from the Database list.
|
|
If you want to create a CrossTab report from a new data source, choose New data source from the Database list and follow the instructions in the wizard.
|
|
6.
|
|
In the Select tables dialog box, enable the check boxes next to the database tables you want to add to the CrossTab report.
|
|
7.
|
|
In the Set criteria dialog box, select the fields to import.
|
|
8.
|
|
Click
 to add the fields to the Selected fields list. |
|
If you want to move the fields up or down the list, choose a field and click the Up arrow
 or Down arrow  . |
|
9.
|
|
In the Destination box, type a destination for the import results.
|
|
10.
|
|
Click Finish.
|
|
11.
|
|
In the CrossTab report dialog box, drag any fields from the list in the Fields area into any of the following positions of the Layout area:
|
|
•
|
Rows
|
|
•
|
Columns
|
|
•
|
Data
|
|
•
|
Pages
|
|
12.
|
|
Click Finish.
|
|
•
|
|
When you use data from an external data source, such as an ODBC data source, Quattro Pro handles it as an external data range. An external is a range of data that is brought into a notebook but originates from an outside source, for example a database. If the data range expands in the data source, you can reflect the change in Quattro Pro by refreshing the data. For more information about refreshing data, see “Updating and refreshing CrossTab report data.”
|
|
•
|
|
When creating a CrossTab report, you should not add data to the sheet where you placed the report because the data could be overwritten when the CrossTab report is refreshed.
|