The importance of parameter ordering in SSRS Lookup LookupSet

When you use Lookup or LookupSet function in SSRS expression, make sure that the "destination dataset" is loaded before your "source dataset" starts the expression lookup

There is where it got me. I had one parameter for each set, and somehow put the one for destination set second. In that setup, none of my lookup returned anything. Once I switched the parameter order, everything works perfectly again

Print | posted on Thursday, September 25, 2014 3:20 PM

Feedback

No comments posted yet.

Your comment:





 

Copyright © Kevin Shyr

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski