Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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,


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Why don't you create a view in the backend and use that for the report.

Also if you have SQL server (for example) you could look at profiler to see how it is getting from Crystal to the backend.

I assume that crystal is getting all the data from the servers and dragging it to the report.

do both these queries have the same connection.

Can you post the queries here?

Edited by: AlunJD on Jun 21, 2011 5:55 PM