Report Assistant defines its default JOIN type as multiple. For end users this does not mean much, so they don't change the default, but if you make more than one multi join, then you create a multi path structure, and then wf starts applying its own structure logic to the SQL generated for the rdbms.

I code all joins in rdbms based stuff as unique (rdbms has no concept of multiple or unique in its joins) so that wf does not interfere and make its own decisions.

So I would like the default for joins to be SINGLE so that end users can get the results they expect for rdbms'es. (This should be product defautl as well for the above reasons.)

I am wondering if anyone has mod'ed the RA to do this. Certainly there is stuff on the advanced search on how to set the default display to be tree and the default verb to print etc. So has anyone waded through the javascript to sort this one?


Here is a screen dump of the default screen for joins in report assistant.



(The image hosting provided by imageshack. Can we have image upload capability to the forum some time please?)

This message has been edited. Last edited by: hammo1j,

I would like to let you know, I read all your messages about the upgrade stuff with great interest.

This special case should be a default setting at installation either multiply or unique.

And I fully support your last request.
(The image site you use here gives me a lot of unwanted information.)

John,

In the JavaScript module joindlgj.js there is an attribute of bMultiple which is set to "true". You would have thought that you could change this to "false" and get the desired effect, but no, unfortunately not.

There are actually two instances within this JS module where the value is set to "True" (second one around line 876). In addition there is a function called cleanOutJoinPanel where the selectedIndex for the JOIN Type is set to 0, which gives the default setting of Multiple and not Single. Changing this to document.getElementById("lstMultiple").selectedIndex = 1; will default the join selection to Single for you on creating a New Join.

Normal word of warning, back up the original and because this is not an IB recommended mod, you do this at your own risk

Good luck

T