Table

Kalipso - Developing - Report - Controls - Table

A table can be added to a Report.

Properties

Through the window that opens the option presents three tabs: general, content and relations.

Tab - General

The available options are:

Common

• Name - Name of the Control. This Name will be used to identify the Control throughout the Project. The name of the Control can only contain letters, digits or underscore (_).

• Description - Description of the Control. This Description is for your information only, Kalipso does nothing with it.

Layout

• Y - Y position of the Control.

• Height - Height of the Control.

Style

Header (You can trigger or not the header display)

• Font - Font of the displayed Text.

• Size - Font size of the displayed Text.

• Font Color - Font color of the displayed Text.

• Text Position - Position of the Text inside the Control. It can be left, center or right.

• Properties - Font properties of the displayed Text. As bold, italic, underline and cut.

Body

• Font - Font of the displayed Text.

• Size - Font size of the displayed Text.

• Font Color - Font color of the displayed Text.

• Text Position - Position of the Text inside the Control. It can be left, center or right.

• Properties - Font properties of the displayed Text. As bold, italic, underline and cut.

Tab - Content

After the initial settings in the general tab, you must access the content tab to indicate the data source for the table. Thus:

In this tab it is indicated that controls can be loaded through:

• "Load Control with" - Load the control with the data from:

  • Tables

  • Query

To use the tables option, they must already be created in the project.

When selecting the query option, queries already created will appear in the list. There you can operate with the icons that appear on the left:

• Add - Adds a selected query to the report

• Edit - Edit the selected query

• Delete - Deletes the selected query

The table with the queries has the following columns:

• Name - Name of the query

• Title - Column title

• Index - Index of the field on the query

Right below the table you have an option that allows you to add a new query in addition to the existing ones. To do this, just click on the edit button.

Tab - Relations

You can use this option to link tables when you are using more than a Table to fill this object. This option is related to the one defined in the previous tab related to the content.‌

Having database tables associated with the table provided here, these tables will appear in this tabulation to make relations between them.