SQL2012 Compatability

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
tcarter
Posts: 5
Joined: Tue Oct 10, 2017 12:44 pm

SQL2012 Compatability

Post by tcarter » Wed Aug 14, 2013 4:44 pm

Hi a while ago you kindly gave me this response when running pre-existing reports with SQL2012, however this doesn^t seem to work when two separate tables have outer joins in the report. Does this mean a rewrite of the report?____"The issue is probably with the syntax used for handling left outer joins. Are you using SQL Server?____If so, edit the file RSWSQL.INI and search for the SQL Server section:____;;;;;;;;;;;;;;;;;;;;;;__;;; ;;;__;;; SQL Server ;;;__;;; ;;;__;;;;;;;;;;;;;;;;;;;;;;____DataSourceDBMS = Microsoft SQL SERVER__DataSourceOuterJoinStyle = 1______*********************__Comment out the DataSourceOuterJoinStyle line by adding a semicolon at the beginning of the line"

Post Reply