Solved

where to add statement in Crystal Report

Posted on 2013-01-22
12
432 Views
Last Modified: 2013-01-24
I get the error 'cannot resolve the collation conflict between
"Latin1_General_BIN" and "SQL Latin1_General_CP1_CI_AS" in the equal to operation.

The solution was to add COLLATE DATABASE_DEFAULT in the join
I tested the SQL query and the error went away.

But where will I add this line to the Crystal Report?
0
Comment
Question by:zachvaldez
  • 5
  • 3
  • 2
  • +1
12 Comments
 
LVL 15

Expert Comment

by:Ess Kay
Comment Utility
add it to the query or the tables that you import. right click on the side, open the data source, and edit the old data
0
 

Author Comment

by:zachvaldez
Comment Utility
I don't follow the steps.
0
 
LVL 15

Expert Comment

by:Ess Kay
Comment Utility
Go to Database Expert

step1
Find the query that you need to change, and change it there


hope that helps
0
 

Author Comment

by:zachvaldez
Comment Utility
What if it is a View?
0
 

Author Comment

by:zachvaldez
Comment Utility
pLS. PROVIDE SOME MORE DETAILS/
0
 
LVL 18

Accepted Solution

by:
vasto earned 160 total points
Comment Utility
You cannot change the SQL query in Crystal Reports when you use Database expert. You can switch to a command or stored procedure  and then you will have full control over the SQL
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
LVL 15

Assisted Solution

by:Ess Kay
Ess Kay earned 50 total points
Comment Utility
if it is a view, you need to edit it from the SQL server, not from crystal
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 50 total points
Comment Utility
Agree.  This done either in the database or you have to use a Command as the data source.

mlmcc
0
 

Author Comment

by:zachvaldez
Comment Utility
I did it add the collation code in the stored procedure and it worked.
I wonder how it is done in a view? Can I alter the view? How about using the 'Command' as suggested above? thanks. there are options..
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
You can use the SP SQL as the command so long as you start with the SELECT.  Don't include the SQL that creates or alters the SP.

mlmcc
0
 
LVL 18

Expert Comment

by:vasto
Comment Utility
If you are using a view then  you need to right click and "Modify"  the view and add the collation order clause to the join in the same way as in the stored procedure. You can recreate everything in a command , but this is probably not necessary
0
 

Author Closing Comment

by:zachvaldez
Comment Utility
Well explained
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Mask on Parameter CR2008 28 33
.net VBA word safemode 1 23
DataGridview Currency Formating? 22 38
Form design in vb.net 7 18
I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
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…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

743 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