Geocortex Printing Help
Open topic with navigation
Expressions specify how to find or calculate a value when the report runs. Properties of a
Expressions allow you to:
Expressions inGeocortex Print Designer can be made up of one or many of the following components:
To see a complete list of the operators, literals, and functions that you can use in expressions, see Operators, Literals, and Functions.
Follow the syntax conventions below when you create expressions:
Type a question mark (?) before query parameter names, for example:
Parameters prefix before
Enclose string literals in single quotes (
'), for example:
The use of quotation marks (
"), for example,
"Quoted Text", results in an error.
To embed an apostrophe into a string literal, type two apostrophes, for example:
'It''s an example'
The Boolean literals are
Enclose date-time literals in hash marks (
#), for example:
[OrderDate] >= #1/1/2016#
Use a question mark (
?) to represent a null reference (one that does not refer to any object), for example:
[Region] != ?
Use round brackets
() to control the order in which an expression is evaluated, for example:
2 * ([Quantity] - 1)
If an expression contains terms of different types, you can use dedicated functions to convert the types, for example:
Refer to Operators, Literals, and Functions for a complete list of supported operators, literals, and functions.
String expressions are expressions that evaluate to a string. A complex string expression combines (concatenates) a number of string literals, and functions using the concatenation operator,
String literals are enclosed in single quotes, for example,
'This is a string literal'. Note that you cannot use double quotes (
") instead of single quotations. To embed an apostrophe into a string literal, type a two apostrophes, for example,
'It''s an example' appears in the report as: It's an example
You can use conditional values in a report by using the logical function,
Iif() function takes three arguments: a Boolean expression, a value to use if the Boolean expression evaluates to
True, and a value to use if the Boolean expression evaluates to
False. The arguments are separated by commas:
Iif(BoolenExpression, TruePart, FalsePart).