asked on

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?

Ess Kay

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

zachvaldez

ASKER

I don't follow the steps.

Ess Kay

Go to Database Expert

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

hope that helps

zachvaldez

ASKER

What if it is a View?

zachvaldez

ASKER

pLS. PROVIDE SOME MORE DETAILS/

ASKER CERTIFIED SOLUTION

vasto

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Ess Kay

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

zachvaldez

ASKER

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..

Mike McCracken

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

vasto

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

zachvaldez

ASKER

Well explained