VS2008 SSRS using to query Oracle: How do I stop {oj} for outer Joins?

Question

I am using VS2008 SSRS to query and report a Oracle Database. Whenever I the query Designer to add an outer join it adds {oj} e.g.

OJ Added

SELECT A.*,B.*
FROM {oj A LEFT OUTER JOIN B On A.id = B.id}

OJ Not added(How I want it)

SELECT A.*,B.*
FROM A LEFT OUTER JOIN B On A.id = B.id

The only way I can get the query to run is to "Edit as Text..." and remove the {oj...}

Is there any way of stopping Visual Studio 2008 from adding the {oj} when I want an outer join, without having to "Edit as Text"

Answer 1

I assume you have yet to find a solution. I am pretty sure the Oracle driver for SSRS is just plain wrong - there is no problem with SQL Server data sources. I can't believe there aren't more people complaining about it.

It used to work, but used the old style (+) syntax for outer joins, until a year or so ago. I guess at that point there was some update which attempted to change it to the newer syntax, but blew it by including the curly bracket oj, which seems to be the normal syntax for some other sources, but it certainly doesn't work with Oracle.

Yes, of course you can edit it in the text query designer, but if you switch to the graphical designer it immediately re-inserts the curly brackets etc. I like to have the graphical option and it really ought to work!

The issue has been with our suppliers since it first occurred, but they seem quite unable to grasp the problem. They occasionally email me to ask if the problem still exists! I guess they are hoping for a miracle.