[rsFieldReference] The Value expression for the textbox ‘All_Custom_CPI_1’ refers to the field ‘All_Custom_CPI’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

Question

Hi, 

I'm working on a report right now, and I am receiving this error message when querying.

[code="plain"][rsFieldReference] The Value expression for the textbox ‘All_Custom_CPI_1’ refers to the field ‘All_Custom_CPI’.  Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
Build complete -- 1 errors, 0 warnings
[/code]

What I did was I created a new dataset that will pull the total count of agents so that I can compare it with the total count of agents with issues so in order to get the percentage.. 

The new Dataset (AllCustom) has the following data fields 
 + Region
 + Domain
 + SiteID
 + SiteName
 + All_Custom_CPI

The other Dataset that has the total count of all agents with issues (NoCustom) has the following data fields
 + Region
 + Domain
 + SiteID
 + SiteName
 + DateEffective
 + No_Custom_CPI

The only changes I did when dragging and dropping the All_Custom_CPI data field into the layout table is I changed the expression to =Fields!All_Custom_CPI.Value since it initially appearing =SUM... and the error is experienced, I hope to hear anyone from the community. I'm clueless on what I might done wrong.

Answer 1

Hello RiseHigher,

Thank you to post your question on TechNet forum.

From the error message, it is possible that you drop the field All_Custom_CPI into different dataset scope. Please try to change the expression of the textbox "All_Custom_CPI_1" to:

=First(Fields!All_Custom_CPI.Value, "AllCustom")

Note: The above expression works if the data set name is "AllCustom" (case sensitive), and the first value of the result is expected value.

I hope it is helpful to you.

Regards,

Edward

---

Edward Zhu

TechNet Community Support