The Chart control
Chart is a new control which can be used to display information in two different ways:
As a Pie Chart
As a Bar Chart
Type : Chart
Name
Provides a unique name for the control.
Enabled for new records
Sets if the control will be enabled or disabled when the forms handles a new record
Enabled for existing records
Sets if the control will be enabled or disabled when the forms handles an existing record
Required
Marks the cotnrol as Required.
By default, the system recognizes required fields and marks them with this flag. Additionaly, controls can be marked as required event if the bound column is not.
Enabled Formula
Set an expression then will be evaluated during run-time and enable or disable the control.
The expression must be in javascript and should return a boolean value.
Dependencies between controls are automatically identified and the expression is re-calculated every time a control affecting the formula changes.
Example :
form.GetControl(“c_Status”).GetValue() != “Open” && form.UserInGroup(“Administrators”)
Visibility Formula
Define a valid formula (using javascript) that will be evaluated during runtime to show or hide the control.
The expression should return a boolean value.
For example :
form.FieldValue(“c_Status”) != “Rejected” || form.UserID() == “1”
Value
Note:
Chart needs data which contains two fields: one field should contain text i.e. months, and another field which contains numbers i.e. income. For an example list, take a look at the following picture:
To supply data to the Chart Control, use the following options :
- Chart values will be retrieved from a list query
- Chart values will be provided by a web service call
- Chart values will be provided by an SQL query
List Query
A List Query that returns text and numbers should be used, like the picture below:
To bind the Chart control to the above list query, do the following:
Web Service
The same as above, a web service that returns text and numbers should be used.
SQL Query
Works the same way as ListQueries and Web Service.
Width
Defines the width of the control.
When the value is zero, the maximum allowed width will be used.
Height
Defines the control height.
If the value is zero, the height property will not be set.
H.Alignment
Defines the horizontal alignment of the parent cell (values : left, right, center)
V.Alignment
Defines the vertical alignment of the parent cell (values : top, bottom, center)
Fore Color
Defines the fore color of the control
Back Color
Defines the Background color of the control.
Cell Color
Defines the color of the parent cell.
Font Size
Declares the font size of the text
Margin
Sets the margin applied to the control, that is, the spacing between the control and the cell borders.
Font Bold
Changes the weight of the font used
Italics
Changes the font style for the control text
No lookup details are used with this control.
Type
The chart type. Can be Pie or Bars.
DisplayMember
The field name that represents the display property of the data source, i.e. Months
ValueMember
The field name that represents the value property of the data source (numeric), i.e. Income
Color1
The first color of the bar geadient, i.e. #FCA
Color2
The second color of the bar geadient, i.e. #C70
Leave a Reply
Want to join the discussion?Feel free to contribute!