title: Collation Conflict in SSRS
body: <p>Currently using SQL Server 2014 and having an issue with the Collation on a stored procedure.  I currently have a report that runs a stored procedure, the code works fine when run in SSMS but I have noticed that while it is being run as part of a SSRS report there is a collation issue between <code>Latin1_General_CI_AS_KS_WS</code> and <code>Latin1_General_CI_AS</code>.</p>
  
  <p>My database is set at <code>Latin1_General_CI_AS</code> as well as all my table columns so I am at a loss as to where it is pulling this <code>Latin1_General_CI_AS_KS_WS</code> inconsistency, can anyone offer any suggestions?</p>
  
  <p>Thanks</p>