Page 1 of 1

SQL2012 Compatability

Posted: Wed Aug 14, 2013 4:44 pm
by tcarter
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"