<div>
What database? &nbsp;What version of Crystal?<br />
<br />
mlmcc
</div>


What database?  What version of Crystal?

mlmcc

<div>
If it is a SQL Server issue, you might see if those can be set as the default. &nbsp;I don't recall having to set them for any view or stored procedure I built for use in Crystal.<br />
<br />
mlmcc
</div>


If it is a SQL Server issue, you might see if those can be set as the default.  I don't recall having to set them for any view or stored procedure I built for use in Crystal.

mlmcc

<div>
Sorry to have flaked out on this -- I was given other projects and didn't even have a chance to even think about the responses.<br />
<br />
(I did talk to the programmer (created the database and original Crystal reports) last week and the solution was to use ADO connection -- he's sending me a quick run down later).<br />
<br />
th1434
</div>


Sorry to have flaked out on this -- I was given other projects and didn't even have a chance to even think about the responses.

(I did talk to the programmer (created the database and original Crystal reports) last week and the solution was to use ADO connection -- he's sending me a quick run down later).

th1434

<div>
<div class="content wysiwyg-content">
I'm trying to write a new Crystal report that involves a SQL view for the data source. Reports created prevously are ADO (for what that's worth). When I go thru Report Expert and try and select the database view I'm getting a<br />
<br />
<br />
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query. <br />
<br />
I can add a table, but not any of the views. But there are previously written reports that use other views.<br />
<br />
(Sorry, I'm forced to teach myself much of this stuff, so I'm pretty clueless ;-) )<br />

</div>
</div>


I'm trying to write a new Crystal report that involves a SQL view for the data source. Reports created prevously are ADO (for what that's worth). When I go thru Report Expert and try and select the database view I'm getting a


Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query. 

I can add a table, but not any of the views. But there are previously written reports that use other views.

(Sorry, I'm forced to teach myself much of this stuff, so I'm pretty clueless ;-) )


Hetorgeneous error when trying to add view to new report

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.