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 |
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. |