Hi,
I'm looking for a way to change (in run time) the direction of the link between 2 tables... (table1 --> table2 to table1 <-- table2)

If not possible changing the left join to inner join should do it (I like more first option), but it also has to be done in run time...

I also have a third option in mind with another table(that I should be able to find by myself) but since my report already 3tables, this would be my last option...

I'm open to do it in vb.net or in crystal report since I'm pushing my tables from vb anyway...

Thanks in advance
Pink

Ps. Please  dont mind my spealing, I'm french and it's friday

Thank a lot Dell for your time and your answer...

This sentence(in the web site you gave me) made me choose another path : "Notice of Deprecation: The RAS COM SDK is deprecated, and will not be available in future releases of BusinessObjects Enterprise and Crystal Reports Server. It is supported in XI Release 2 and earlier."

To solve my problem, I kept the left join but made sure that the concerned table was filled (I intentionnally sent wrong informations into it...)

The main reason why I asked for this option while knowing how to do it in an other way is because with this crystal report (.rpt), I've created over 120 reports(choices) for my clients and I was asked to double this amount... I've wanted to keep it simple...lolll

Ps. If someone find a way to bypass the readonly option mention by my friend Dell, please dont be shy and speak up!!!

Pink