Sql Server Reporting Services SSRS: LOOKUP Simple Example - einfaches Beispiel

simple Example:
Lookup("searchstring",KeyColumn,ValueColumn,"Datasetname"):

=Lookup("Key1",Fields!DataKey.Value,Fields!DataValue.Value,"AllDataItems")


searchsring can also be expression, but


other expressions:
=IIF(Count(Fields!MA.Value)>1,"Red","No Color")