Found a problem in my code.

Syntax is correct for lookup. Dataset was not returning anything to SSRS renderer because I was passing the wrong parameters.

Thanks