Changing SQL in Reports from Wizard to User SQL
Posted: 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