Changing SQL in Reports from Wizard to User SQL

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
RBittner_(Guest)
Posts: 2
Joined: Tue Oct 10, 2017 12:44 pm

Changing SQL in Reports from Wizard to User SQL

Post by RBittner_(Guest) » Tue Nov 15, 2011 4:48 pm

R&R Writer version 12 Build 12.0.002__SQL 2005 server____We^ve run quite a few R&R reports on a prior database that was migrated from a 2000 server without problems. We^ve just migrated to a SQL 2005 database and can^t change the compatibility value to match 2000 due to application constraints. About half of the old reports run with no change, but the other half have the outer join problem.____We^re looking for the easiest way to move the old Wizard SQL designed reports to User SQL without reinventing the wheel. ____What options do we have?____Thanks.____Ron

Post Reply