2.341.7.26.6 Function: LookupSet

Applies to RDL 2010/01 and RDL 2016/01

The main difference between Lookup and LookupSet is that the latter returns all matching values instead of only the first match.

Function	Arguments	Type	Description
LookupSet	Return	VariantArray	LookupSet evaluates the Source expression for the current instance of the current scope. It then finds all rows of data in the specified dataset for which the source value equals the Destination expression evaluated for that row. It returns an array containing a list of all values of the Result expression evaluated for each matching row, or an empty array if no matching rows are found. The list retains the order of the rows in the original dataset. Elements of the Return array MUST be the same data type as the Result data type.
	Source	Variant	Specifies the value to look up. The value of the expression result 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 item, or lookup functions.
	Result	Variant	The Result expression MUST NOT reference aggregate functions, report items, or lookup functions.
	DataSet	String ([XMLSCHEMA2/2] section 3.2.1)	Name of the dataset in which to evaluate the Destination expression and Result expression. MUST be a constant, not an expression.