SQL2012 Compatability

[tcarter]

Hi__Recently moved to SQL2012 and many existing reports no longer work with R&R version 12.0.0.2, the error message complains about the syntax.Is this resolved in 12.5 or do the reports need a rewrite?

[cstrasser]

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 ;;;__;;; ;;;__;;;;;;;;;;;;;;;;;;;;;;__[SQLServer]__DataSourceDBMS = Microsoft SQL SERVER__DataSourceOuterJoinStyle = 1______*********************__Comment out the DataSourceOuterJoinStyle line by adding a semicolon at the beginning of the line.

[Terry_(Guest)]

Thank you this resolved the problem

[tcarter]

Thank you, this resolved the problem