[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

Not able to add field to SSRS report

Hello

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.      

Thanks,
0
Sanjeet
Asked:
Sanjeet
1 Solution
 
planoczCommented:
Have to tried to delete the dataset from the report and readd it again?
0
 
SanjeetAuthor Commented:
This worked!
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now