Solved

Not able to add field to SSRS report

Posted on 2014-09-09
2
291 Views
Last Modified: 2014-09-15
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
Comment
Question by:Sanjeet
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 27

Accepted Solution

by:
planocz earned 500 total points
ID: 40312891
Have to tried to delete the dataset from the report and readd it again?
0
 

Author Comment

by:Sanjeet
ID: 40323410
This worked!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question