This feature may not be available in every package. Not sure if you have this feature or you want to learn more about it? Send us a message at email@example.com.
These terms are important to understand when creating reports with Cartegraph's Report Engine.
A function that is applied to the field level within a report. Most commonly, expressions are applied within the Table Contents window of the Report Designer and are specific formatting, functions, or calculations on one field or column. An example is the Sum(Tasks.Total_Cost). This expression is a sum function to give us the total cost for all tasks within a group. The function itself is sum around the field of tasks total cost.
A constraint that the report user will populate. This constraint is then used as a filter. Parameters can be compared to prompts used on legacy reports or layer filters. Examples of common parameters are the Start Date and Stop Date parameters. These parameters take manual input of dates by the user and apply those as filters to the report to show data with the applicable dates.
Expressions that are applied at the table or report level for the entire report. Filters are applied using the Properties window for a specific table in the bottom left, or using the Filter option on the Project tab of the Report Designer. An example is a Date In Range filter along with an Is Not Null statement. The filter can be read as "Show me data where the Task Actual Start Date is in the range of our parameters, and the Task Actual Stop Date is in that same range of our parameters, and where the Task Department is filled out—that it is not null or empty."
A value that can be one of two types: true or false. In Cartegraph Reports, nearly all filters and expressions will evaluate to a value of True or False. Booleans are used within Cartegraph reports in many filters and expressions to control the outcome of the filter or expression.
Specific data types
Values expressed as text, dates, or numbers. The text data type is also known as a string data type. These values will be surrounded by quotes—single or double—which tells us they are simple text. Date data types are simply that—dates. An example of this would be the Task Actual Start Date. Numeric data types are numeric values—for example, Tasks Total Cost.