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
=IIF(Sum(Fields!AI_Average_Handle_Time.Value)=0,0.00,Sum(Fields!AI_Average_Handle_Time.Value))
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