Parenthesis (Object)

Member of:

Limits collection, Parentheses collection

Description:

For a Limits collection, returns or sets parentheses around values on limit lines. In Interactive Reporting, parentheses represent enclosed sub-operations. Sub-operations enable you to override the default evaluation order in operations using AND or OR operators.

For an AppendedQueries collection, this object nests parentheses () for the evaluation order of an appended query. The expression must include two queries or more. The default evaluation order is left to right.

Example 1:

This example shows how to remove all parentheses on the Limit line:

ActiveDocument.Sections["Query"].Limits.Parentheses.RemoveAll()

Example 2:

This example shows how to remove the first parenthetical expression:

ActiveDocument.Sections["Query"].Limits.Parentheses[1].Remove();

Example 3:

This example shows how to count the number of parenthetical expressions on the Limit line:

(ActiveDocument.Sections["Query"].Limits.Parentheses.Count);

Example 4:

This example shows how to remove the beginning query in an appended query expression:

ActiveDocument.Sections["Query"].AppendQueries["Parentheses"]["Query,Query2"].BeginQuery.Remove()

Methods:

Remove()

Properties:

Read-only: BeginLimitName as String, EndLimitName as String, Name as String, BeginQuery as String, EndQuery as String