none
SSRS Reporting Binding Multiple Same Field Name with Datasets RRS feed

  • Question

  • Dear Friends,

    I am New to SSRS Reporting Services...Kindly provide me a soln...

    Here My Scenario,
     
    Avg Handle Time My Column Name appears 2 times in my report
     
    Where I need to Display 10 and 20 respectively(dynamically) 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.
    I tried my Expression to fetch the value 20 but it was failed...and i don't know about these parameters which need to pass

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

    Please find any soln...

    Monday, July 21, 2014 7:46 PM

Answers