|  Organizer Advantage HowTo/Help  |  Designer HowTo/Help  | 

Advantage Help > Statistics, Custom Views > Custom Views Window

Custom Views Window

The Custom Views window allows you to display predefined custom views or define a new custom view. You can display results from one, two, or several tables.

The Custom Views window opens with the empty view box or with the first custom view selected (if there is already a predefined one).

opens empty:

opens with the predefined view:

How to define a new view?

Delete the content of the Custom View Definition box (just highlight the text and use the Delete button on your keyboard, you can also use popup menu commands).

Enter an SQL query (view definition) into the Custom View Definition box:
1. Enter your SQL query manually (view definition).
2. You can load an SQL query from the View Assistant.
3. Maybe you can copy and paste from our samples and then modify it.

Click Display to see the result. Click Save View to display the Save Custom View window.

In the Save Custom View window enter your view name into the Save Custom View As box. Click Save.

The new custom view is added to the Custom Views list. Click on the Custom Views list and select the new view.

The new predefined view is accessed from the Views dropdown box in the Main toolbar section.

Organizer Advantage, Simple Database Solutions

Organizer Advantage, Business Database Solutions

Organizer Advantage Free Service

Organizer Advantage Support

Database Blog:
Advantages of Database Software over Spreadsheet Applications
Firebird SQL Tutor
Custom Wine Inventory Database

Free Database Templates