soonerpride75
Programmer
Has anyone run into an issue with multiple outer joins being used in ReportSmith with a SQL Server 2005 database? We are migrating from ADP Enterprise v4 to v5, and thus are updating our database from SQL Server 2000 to SQL Server 2005. Since SQL Server 2005 no longer supports non-ANSI statements any longer, it appears that RS is having a hard time moving more than one outer join from the where clause up to the from clause, instead creating inner joins for all joins after the first outer join (in the where clause). Has anyone encountered this issue before? I've talked with ADP's ReportSmith support to no avail, as well as emailing SRS about the issue only to have my emails deleted. Is it simply a tweak needed in the RS_SQLIF.ini file?