Solved

Hetorgeneous error when trying to add view to new report

Posted on 2004-09-29
5
245 Views
Last Modified: 2012-05-05
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
Comment
Question by:th1434
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 12185731
What database?  What version of Crystal?

mlmcc
0
 
LVL 13

Accepted Solution

by:
vidru earned 250 total points
ID: 12186237
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 12186898
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
 

Author Comment

by:th1434
ID: 12435029
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question