Types Lookup Function in SSRS

This function primarily we can use when we need to join with another dataset to bring the data. Where this function available in SSRS.?

1. Right click on Texbox Properties
2. Click Expression
3. Select “Common Function”
4. Again Select “Miscellaneous”

There is different type of Lookup Functions are available.

1. Lookup
2. LookupSet
3. MultiLoopup

Lookup

This function retrieves the values from specified dataset, and it refer 1 – to – 1 relationship.

Syntax:

Lookup (source_expression, destination_expression, result_expression, dataset)

source_expression: it specifies the current scope of the source column dataset.
destination_expression : it specifies the value where you want match the destination dataset.
result_expression : this is return result which result are you looking from the destination dataset.
dataset: its destination dataset.

LookupSet

This function retrieves the values from specified dataset, and it refer 1 – to – N relationship, Same parameters as Lookup function.  

Syntax:

LookupSet (source_expression, destination_expression, result_expression, dataset)

MultiLoopup

This function retrieves the values from specified dataset, and it refer N – to – N relationship.

Syntax

MultiLookupSet (source_expression, destination_expression, result_expression, dataset)

In upcoming article we can discuss about these function.