Not able to add field to SSRS report
Posted on 2014-09-09
I have an existing report which has multiple groups. I need to add an additional field to one of the rows which has a group on it.
When I add the field I get the error message below. What can I do to fix it?
This is the field I added: ="Date Recovery: " & First(format(Fields!date_of_recovery.Value,"MM-dd-yyyy") )& ""
Error 1 [rsFieldReference] The Value expression for the textbox ‘textbox123’ refers to the field ‘date_of_recovery’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.