Left outer join on two Bex queries in crytal taking hours to give results

Hi all,

I am facing performance problem with left outer join in crstal. According to requirement I have 2 bex queries need to be left outer join in crytal . I tested that Individual queries run fast at backend but when I am doing left outer join in crystal and running the report it takes long..........forever. can you please suggest any solutions to it. user will never accept it....plz

Thanks in advance,

Priyam