Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  data set scope issue in expression

Author  Topic  tking1 Starting Member 22 Posts Posted - 2010-05-27 : 11:07:44 I'm needing to perform a calculation between 4 values. 3 of the values originate from a common dataset, the 4th is from another dataset that is derived from a temp table created by my query (and the field name therefore doesn't exist in the DB). I'm getting this error: "[rsFieldReference] The Value expression for the textbox ‘textbox14’ refers to the field ‘Month_Total’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope." Ideas on how I can get my calculation?