<div>
I suspect not. &nbsp;I have no confirmationof that.<br />
<br />
It may have to do with the fact that a COMMAND is similar to a stored procedure.<br />
<br />
mlmcc<br />

</div>


I suspect not.  I have no confirmationof that.

It may have to do with the fact that a COMMAND is similar to a stored procedure.

mlmcc


<div>
<div class="content wysiwyg-content">
I have a report basing a view. Now I need to test the report for the data on the production d/b where i do not have permission to create the view. So i am trying to replace the view with the command from the other d/b using 'Set Datasource Location'. For some reason the command is not being updated as the new datasource either on a different d/b or even the same d/b. So a view cannot be replaced by the command? How can I make report work for the new datasource without recreating the report?<br />
<br />
TIA..<br />
Gary
</div>
</div>


I have a report basing a view. Now I need to test the report for the data on the production d/b where i do not have permission to create the view. So i am trying to replace the view with the command from the other d/b using 'Set Datasource Location'. For some reason the command is not being updated as the new datasource either on a different d/b or even the same d/b. So a view cannot be replaced by the command? How can I make report work for the new datasource without recreating the report?

TIA..
Gary

Set Datasource Location

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.