Ranges


Range functions allow you to determine the type of range with which you are working. For example, HasUpperBound will return True if the range you're working with contains an upper limit and False if the range does not have an upper limit.

Table C-9: Range functions

Function

Description

Arguments

HasLowerBound (x)

Returns True if the range is not of the form "Is<a" or "Is<=a". On any array, HasLowerBound returns True if HasLowerBound evaluates to True on every element of the array.

x can be a single range or a range array.

HasUpperBound (x)

Returns True if the range is not of the form "Is>a" or 4"Is>=a". On any array, HasUpperBound returns True if HasUpperBound evaluates to True on every element of the array.

x can be a single range or a range array.

IncludesLowerBound (x)

Returns True for ranges of the form "a To b", "a To_ b", and "Is>=b". IncludesLowerBound returns True on any array if the range that is the Minimum element of the array IncludesLowerBound.

x can be a single range or a range array.

IncludesUpperBound (x)

Returns True for ranges of the form "a To b", "a _To b", and "Is<=a". IncludesUpperBound returns True on any array if the range that is the Maximum element of the array IncludesUpperBound.

x can be a single range or a range array.




Mastering Business Analysis with Crystal Reports 9
Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)
ISBN: 1556222939
EAN: 2147483647
Year: 2004
Pages: 177
Authors: Chris Tull

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net