You can use Formula fields to include data that does not exist in any ClearSCADA database fields. By writing a formula, you can calculate additional data that you want to use or display in a report.
You typically write formulas using Crystal syntax—for information, see the documentation provided with the Crystal Reports application. For examples of how a formula (rather than a Formula field) can be used in a report, see Point Listing that Uses Color to Indicate Alarm Status, and see Restrict the Amount of Data that is Queried in a Report.
When writing formulas, use the Check button
to test that the syntax is correct.
As an alternative to using formulas in Crystal Reports, you can use Data Grids to specify the information that you want to include in a report. A Data Grid is in effect a ‘custom’ table. ClearSCADA can perform a variety of calculations on the data in a Data Grid and display the results of those calculations in the report. For further information, see Configuring Data Grids in the ClearSCADA Guide to Core Configuration. For an example of how a Data Grid can be used in a report, see Embedded Data Grid Content.
Further Information