Search found 5 matches

by tcarter
Mon Sep 16, 2013 4:15 pm
Forum: R&R ReportWorks Users
Topic: SQL2012 Compatability
Replies: 2
Views: 2754

==> RE: SQL2012 Compatability

>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...
by tcarter
Wed Aug 14, 2013 4:44 pm
Forum: R&R ReportWorks Users
Topic: SQL2012 Compatability
Replies: 0
Views: 2895

SQL2012 Compatability

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...
by tcarter
Mon Aug 12, 2013 4:44 pm
Forum: R&R ReportWorks Users
Topic: SQL2012 Compatability
Replies: 2
Views: 2754

SQL2012 Compatability

__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 ...
by tcarter
Thu Apr 25, 2013 5:36 pm
Forum: R&R ReportWorks Users
Topic: SQL2012 Compatability
Replies: 3
Views: 3234

==> RE: SQL2012 Compatability

Thank you, this resolved the problem
by tcarter
Wed Apr 24, 2013 9:08 am
Forum: R&R ReportWorks Users
Topic: SQL2012 Compatability
Replies: 3
Views: 3234

SQL2012 Compatability

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?