Liveware Publishing Support Forum

>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 cr...

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 out...

__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 ...

Thank you, this resolved the problem

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?