Liveware Publishing Support Forum

__Some time back you provided this fix for outer joins and it successfully resolved my report at the time. However it doesn^t seem to work for an old report when there are two separate tables linked to the main table with asterisk outer joins. 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.

Yes. The old style join was *= and =* to indicate left / right OJ____This isn^t supported by SQL Server anymore and it needs to be re-written.

>Yes. The old style join was *= and =* to indicate left / __>right OJ __>__>This isn^t supported by SQL Server anymore and it needs to __>be re-written. ____If the report is rewritten, does the latests version of R&R create correct outer joins for SQL2012 or does a "view" have to be created to feed the report