March 5, 2013 at 7:13 am
Hi,
I'm working with Report Builder, I should do a sum of many values from different columns (this clumns are from a list in sharepoint )
This is my expressio which does the sum :
=(Lookup(Fields!Ele_Crs_Har_Q1_Ans.Value,Fields!Answer.Value,Fields!Value.Value,"Coefficient"))+(Lookup(Fields!Ele_Crs_Har_Q2_Ans.Value,Fields!Answer.Value,Fields!Value.Value,"Coefficient"))+(Lookup(Fields!Ele_Crs_Har_Q3_Ans.Value,Fields!Answer.Value,Fields!Value.Value,"Coefficient"))+(Lookup(Fields!Ele_Crs_Har_Q4_Ans.Value,Fields!Answer.Value,Fields!Value.Value,"Coefficient"))+(Lookup(Fields!Ele_Crs_Har_Q5_Ans.Value,Fields!Answer.Value,Fields!Value.Value,"Coefficient"))+(Lookup(Fields!Ele_Crs_Har_Q6_Ans.Value,Fields!Answer.Value,Fields!Value.Value,"Coefficient"))
My problem is with this Expression, it wroks but i wanna assign it to a variable !!! i get an error :
When the report contains multiple datasets, field references outside of a data region must be contained within aggregate functions which specify a dataset scope.
I think because i use the lookup !! but i don't know how do i resolve this ?
Any idea Plz ?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply