<div>
<div class="content wysiwyg-content">
Hi!<br />
<br />
I have a VB6 project using Crystal Report 8.5. &nbsp;There is a report inside my VB project that is using a Data Environment Command.<br />
<br />
I went to the command, modified the SQL query so that it would add a few fields. &nbsp;When I open my Crystal Report (dsr file), when I toggle the field view and I can see<br />
<br />
Database Fields -&gt; DataEnv_Command11 -&gt; My command fields<br />
<br />
However, the new fields are missing. &nbsp;If I add a new database to my project and reselect this command, I can see the new fields.<br />
<br />
The problem is all the fields are linked to this object, so if I rename the object, the fields follow. &nbsp;If I delete the object, all the fields in my report are also deleted.<br />
<br />
Is there any way to refresh the existing connection so that it sees the new fields?
</div>
</div>


Hi!

I have a VB6 project using Crystal Report 8.5.  There is a report inside my VB project that is using a Data Environment Command.

I went to the command, modified the SQL query so that it would add a few fields.  When I open my Crystal Report (dsr file), when I toggle the field view and I can see

Database Fields -> DataEnv_Command11 -> My command fields

However, the new fields are missing.  If I add a new database to my project and reselect this command, I can see the new fields.

The problem is all the fields are linked to this object, so if I rename the object, the fields follow.  If I delete the object, all the fields in my report are also deleted.

Is there any way to refresh the existing connection so that it sees the new fields?

Crystal Report 8.5 / VB6 - New command field is missing

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.