[rsFieldReference] The Value expression for the textbox issue

• skyline_android

  SSC Enthusiast

  Points: 190

  More actions

  August 10, 2012 at 1:16 pm

  #262555

  Hi,

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

  [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

  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.

• rVadim

  Hall of Fame

  Points: 3969

  More actions

  August 11, 2012 at 2:10 am

  #1524746

  Table is probably bound to dataset that doesn't have that field you refer to in text box.

  --Vadim R.