During the widget creation process, you can specify the widget type as table. You can select the connection and data model, select columns, define data sets, and design the table.
To create a table widget:
On the Add Widget page of the Create Dashboard menu, click Create Widget. The Connection & Data Model page is displayed.
From the Connection drop-down list, select the connection. The database name is automatically populated in the Database text box and the data models are displayed in the Select Data Model(s) section.
If you need to increase the number of records retrieved from the database during widget design, do one of the following:
Modify the number of records in the Max. Records for Preview text box. The default number of records (1000) indicates that the first 1000 records returned by the data model are used during the widget creation process.
-Or-
Select the All Records check box.
Note:
During widget design, data is retrieved from the database for determining the columns available and for use in presenting a preview of the widget. The Max. Records for Preview text box and the All Records check box define the number of records that are retrieved during widget design.
Selecting the All Records check box loads all records. This may delay widget design time. You cannot enter a value in the Max. Records for Preview text box if the All Records check box is selected. You must clear the check box to enter the value.
Select the Sort Columns check box, if you want to list the columns in alphabetical order.
Note:
The columns are displayed in the order they are returned from the database. Listing the columns in alphabetic order makes it easy for you to find the column you need from the column listing, even if you are not familiar with the database.
In the Select Data Model(s) section, click 
next to the data model to select it. The selected data model appears on the right.
Note:
You can add only one data model for a table widget
Click Tables the widget type. Selection is denoted by a mark that appears next to Table.
Click Next. The Select Columns page is displayed.
<<Table Overview | Select Columns>>