<div>
<div class="content wysiwyg-content">
Hello <br />
<br />
I have an existing report which has multiple groups. I need to add an additional field to one of the rows which &nbsp;has a group on it.<br />
<br />
When I add the field I get the error message below. What can I do to fix it?<br />
<br />
This is the field I added: =&quot;Date Recovery: &quot;&nbsp;&amp; First(format(Fields!date_o<wbr />f_recovery<wbr />.Value,&quot;MM<wbr />-dd-yyyy&quot;)<wbr /> )&amp; &quot;&quot;<br />
<br />
Error &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[rsFieldReference] The Value expression for the textbox ‘textbox123’ refers to the field ‘date_of_recovery’. &nbsp;Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />
Thanks,
</div>
</div>


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,

Not able to add field to SSRS report

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.