LEFT JOIN MS SQL

[Guy]

Hello,__I have a problem with LEFT join on a report with r&r sql edition. __A error say that ms sql can^t join a externe because it^s use in intern. Why ? i don^t understand, i just want records in fileA who exist or not in fileB. I have a relationship many to one. This report work fine in xbase edition. What^s happens ?__sorry for my english so poor ?__Thanks

[kfleming]

If your report has just two tables, this should work. However with more than one join in the report you may indeed run into problems.____Kathleen__R&R Support

[Guy]

Kathleen, with two tables it^s ok. But how can i do with my report with 4 relations ? It^s very strange because with rsw.exe (designer) when i preview the report it^s ok, but when i integrate my report with my application and i use rswrun.exe (runtime) i have a report of jointure. The same report with only 2 tables all is ok designer and runtime !__What^s happens with runtime ?__Guy

[Guy]

Kathleen, with two tables it^s ok. But how can i do with my report with 4 relations ? It^s very strange because with rsw.exe (designer) when i preview the report it^s ok, but when i integrate my report with my application and i use rswrun.exe (runtime) i have a ERROR of jointure. The same report with only 2 tables all is ok designer and runtime !__What^s happens with runtime ?__Guy__sorry 2 msg because there had a error

[kfleming]

Are you running runtime from a different directory than the designer? If so copy the file RSWSQL.INI from the designer directory to the runtime directory.____Kathleen__R&R Support

[Guy]

rswsql.ini is in runtime directory.__In fact when i use a relation A==>B and B=>C i have a error but if i use a relation A=>B and A=>C it^s ok __it doen^t like the 2 relations indeep in designer mode and runtime mode. How can i do this ? I need it ? I have a lot of reports with this configuration !__thanks Guy__

[kfleming]

You could create a view table in the database and then have R&R report against that view.__Or you could create a User SQL report in R&R where you would write the SELECT statement.____Kathleen__R&R Support

[Guy]

hummm the solution is not very engaging !