Solved

Hetorgeneous error when trying to add view to new report

Posted on 2004-09-29
5
243 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

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. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

932 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now