where to add statement in Crystal Report

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?
zachvaldezAsked:
Who is Participating?
 
vastoConnect With a Mentor Commented:
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
 
Ess KayEntrapenuerCommented:
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
 
zachvaldezAuthor Commented:
I don't follow the steps.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Ess KayEntrapenuerCommented:
Go to Database Expert

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


hope that helps
0
 
zachvaldezAuthor Commented:
What if it is a View?
0
 
zachvaldezAuthor Commented:
pLS. PROVIDE SOME MORE DETAILS/
0
 
Ess KayConnect With a Mentor EntrapenuerCommented:
if it is a view, you need to edit it from the SQL server, not from crystal
0
 
mlmccConnect With a Mentor Commented:
Agree.  This done either in the database or you have to use a Command as the data source.

mlmcc
0
 
zachvaldezAuthor Commented:
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
 
mlmccCommented:
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
 
vastoCommented:
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
 
zachvaldezAuthor Commented:
Well explained
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.

All Courses

From novice to tech pro — start learning today.