Dynamic Joins

Is there a way to make the joins between two tables in Designer using case statements? For example if a user from from one group runs a report use a regular inner join, but another group would use a left outer join. Is this possible?


billbejeck (BOB member since 2004-06-03)

I’ve done this in a weird way (suggested by either this forum or its predecessor). I use Aggregate Aware, with two sets of tables, one with the regular join and one with the outer join.

My users have to select a certain object to avoid the outer join. That object is incompatible with the “regular join” table. This doesn’t make it automatic but most of my users want the outer join.

Is there a way to make two objects, one only visible to the one set of users who want the regular join and one only visible to the other set who want the outer join?


KSG :us: (BOB member since 2002-07-17)

Probably this presentation from the Integra Site:

User Selectable Outer Joins


Dave Rathbun :us: (BOB member since 2002-06-06)

You’re right! I think it was the old forum and I remember poring over the presentation. It was way cool when it finally worked for me. . . :smiley:


KSG :us: (BOB member since 2002-07-17)