How to set Multiple Dataset fileds in SSRS Reporting Expressions

Posted by Self-Innovator under ASP.NET on 7/21/2014 | Points: 10 | Views : 1146 | Status : [Member] | Replies : 0
How to set Multiple Dataset fields in SSRS reporting Expressions

here My Scenario,

Avg Handle Time My Column Name appears 2 times in my report

Where I need to Display 10 and 20 respective,y from dataset 1 and dataset 2 on my expressions i got the value 10 by this expression

but i am not getting the value 20.
Itried my Expression to fetch the value 20 but it was failed...and i don't know about the 3rd parameter which need to pass

=Lookup(Fields!AI_Average_Handle_Time.Value,Fields!AI_Average_Handle_Time.Value,Fields!Employee_ID.Value, "DataSet2")

Any one pls find a solution...

Join Hands Change lives
Thanks & Regards
Straight Edge Society


(No response found.)

Login to post response