It's not the first that I'm using this function, but for unknown reasons to me it doesn'T work in this instance. My formula is as follows:
=Lookup(Fields!No__dossier.Value, Fields!Dossier_détail.Value, Fields!DMS_jours.Value, "DMS")
My source key is:
Fields!No__dossier.Value
Btw it the data in this fields looks like this: 12345.
My destination key is:
Fields!Dossier_détail.Value
The data in this field looks like 12345 too, so no difference in it's format.
My actual data that I want to return from the Lookup is:
Fields!DMS_jours.Value
Finally, the dataset where I'm returning the data from is:
"DMS"
As mentionned above, it seems to me that my key's format is identical, and the formula is correct, but once I run the report I get blank fields in that column. Can any1 plz hint me what could be the cause of the malfunction? Thanks a lot!!
P.S. I'm using Lookup function in that same tablix but at another column with another source and it works perfectly.