Table
Kalipso - Developing - Report - Controls - Table
Last updated
Kalipso - Developing - Report - Controls - Table
Last updated
A table can be added to a Report.
Through the window that opens the option presents three tabs: general, content and relations.
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.
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.
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.
