Table Setup

Note For simplicity, we use "table" throughout this help file to refer to any of database object in the project. A database object can be either a table, a view, a custom view or a report.

After loading the database, the tables will be shown in the database pane on the left pane. To access ALL setting for a table (including Table-specific Options), click the table node of any table in the database pane and then click the [Table] tab to go to the Table Setup page. This is the setup page for a single table.

 

You can also click on the [Tables] or [Views] or [Custom Views] or [Reports] node in the database pane to go to the Tables Setup page which is a grid showing the most frequently used settings for all tables. If you need to set these settings for multiple tables, this page allow you to view and set them quickly. Note that this page does not include Table-specific Options.

The Table Setup pages consists of two section. The upper section is a grid showing available options of all tables. The lower section contain two panels, the [Table-specific Options] panel and the [Report Settings] panel for the selected table.

screen shot


Note For all checkbox or combobox columns, if you want to apply the setting to ALL tables or views, you can choose your setting at the [Tables] or [Views] or [Custom Views] or [Reports] row.

If you prefer to view the tables in alphabetical order, click [Tools]->[Sort Tables Alphabetically] (see Tools).

You can still change the display order of the menu item by drag-and-drop. Select a table by clicking the first column - [Table Name] column, then drag and drop to where you want. Note that a table cannot be moved out of its parent node.

Note that changing the display order of table in this Table Setup page does not change the display order of the tables in the menu. To change the display order of the menu item, click [Tools]->[Menu Editor] (see Tools).

 

The available table level settings are as follows:

Generate Select/unselect a particular table for generation
Caption

To change the caption of a table, click on [Caption] box to make the necessary change.

Note If you use Multi-Language (see ASP.NET Settings), use Multi-Language Property Editor, see Tools for details.
Filter

Specify a filter (WHERE clause) for the table. Click the [...] button in [Filter] column, the Filter Editor will popup. Enter your filter, you can drag the field names from the left pane to the editor, the SQL identifier quote characters will also be added for you automatically.

Note The filter must be a valid VB/C# string as the WHERE clause will be concatenated to the SQL string.

Sort

Specify the sort fields (ORDER BY clause) for the table. Click the [...] button in [Sort] column, the following dialog box will popup. You can choose up to 6 fields, in either ascending or descending order.

Default Set a Table as the Default Table. The Default table is the first table the user see when visiting your site. Select the table you want in the [Default] column.
Export Page Size

Specifies the number of groups (or records if no grouping field) in each page of the exported document (page breaks will be inserted between pages). Default is 0, i.e. disabled, no page breaks. If you enter n (where n > 0), there will a page break inserted every n groups/records.

Notes
  1. Does not work with exporting to Excel.
  2. If the data for each page is too large for one physical page, it may still span more than one page before starting a new page.
Requires Search Criteria

Specifies if the report requires search criteria (filtering). Default is disabled.

Note If enabled, the report always requires search criteria. When the page is initially loaded, no records will be displayed until searching is done. (Remember to enable Filter or Extended Filter or both)
Fields per row (Extended Filters) Specifies the number of fields per row in the Extended Filter panel. Default is 0 (unspecified), one field per row.

 

 

Table-specific Options

Same as the list page options as described in ASP.NET Setup except that the options are table-specific, meaning you can have different list page options for different tables. To use table-specific options, select a table in the grid, uncheck [Use global settings] in the [Table-specific Options] panel, the panel will be enabled for you to setup.

 

Report Settings

 

Show Report

Show both report data (in HTML table) and charts (if any). If you want the report to show charts only, uncheck this setting.

Include Row Sums

Includes row sums for the crosstab report

Note For use with Crosstab reports only
Include Detail

If checked, records belonged to each grouping level will be displayed under the grouping level title, then followed by the summary. If unchecked, the details records are skipped, only the summary will be displayed.

Note NOT applicable to Crosstab reports.
Show Compact Summary View

If checked, the summary will be displayed as columns for each group. If unchecked, the summary are displayed at the bottom of each group (as in previous versions).

Notes
  1. Only applicable when Include Detail and Summary is unchecked (i.e. show summary only)
  2. NOT applicable to Crosstab reports.
Show Page Summary If checked, the summary for the records in the current page will be displayed at the end of the page.
Show Grand Summary If checked, the summary for all the records in the report will be displayed at the end of the page.

 

 

 

 


 ©2007-2016 e.World Technology Ltd. All rights reserved.