2.341.7.26.7 Function: MultiLookup

Applies to RDL 2010/01 and RDL 2016/01

The following are the arguments and types of the MultiLookup function.

Function	Arguments	Type	Description
MultiLookup	Return	VariantArray	MultiLookup evaluates the Source expression for the current instance of the current scope. Then, for each item in the Source array, it finds the first row of data in the specified dataset for which the item in the Source array equals the Destination expression evaluated for that row.<194> It returns a Variant array containing a list of values of the Result expression evaluated for each such first matching row. MultiLookup returns an empty array if no matching rows are found for any item. The items in the array retain the order of the items in the Source array. Elements of the Return array MUST be the same data type as the Result type.
	Source	VariantArray<195>	The value to look up. Items in the array MUST match the data type of the Destination expression. The expression MUST NOT reference lookup functions.*
	Destination	Variant	Specifies the value to compare the Source expression to. The Destination expression MUST NOT reference aggregate functions, report items, or lookup functions.*
	Result	Variant	The expression MUST NOT reference aggregate functions, report items, or lookup functions.*
	Dataset	String	Name of the dataset in which to evaluate the Destination expression and Result expression. MUST be a constant, not an expression.

* "Lookup functions" refers to all types of lookup functions (such as Lookup, LookupSet, and MultiLookup).