Arrays


Arrays are a list of values separated by commas. The most common arrays are found in fuctions such as Average and Maximum, where you're finding one value stemming from a group of values.

Table C-8: Array functions

Function

Description

Arguments

Array (x,...)

Creates an array, initializes it with the given array elements, and returns it.

The given arguments are array elements with which to initialize the array. The number of array elements can be any number from 1 to 1000. All the arguments must be of the same type. Unlike Visual Basic, you may not have zero elements.

MakeArray (x, ...)

Creates an array, initializes it with the given array elements, and returns it.

The given arguments are array elements with which to initialize the array. The number of array elements can be any number from 1 to 1000. All the arguments must be of the same type.

UBound (array)

Returns a Number containing the largest available subscript for the given array.

array is an array value, expression, or variable.

SummaryFunction (x)

Summarizes the values in an array of constants, data field values, or formulas (a*b, c/d, and so on) separated by commas.

x is an array of values that can be evaluated by the function being used.




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