• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

Hetorgeneous error when trying to add view to new report

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 ;-) )
0
th1434
Asked:
th1434
  • 2
1 Solution
 
mlmccCommented:
What database?  What version of Crystal?

mlmcc
0
 
vidruCommented:
Pretty sure this is a SQL Server issue.  Found this thread with a potential solution:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20331456.html

It points to re-creating the view, setting ANSI_NULLS and ANSI_WARNINGS before the CREATE VIEW statement.

-dave
0
 
mlmccCommented:
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
0
 
th1434Author Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now