+ Start a Discussion
SwerzSwerz 

Report is timing out

Hi folks,

I am working on a report which should give me all the opportunities which moved back in stages. There are total 5 stages in which the opportunities can be. So I am looking for opportunities which, say, were in stage 5 initially and moved to stages 4, 3, 2 or 1, or were in stage 4 initially and moved to stages 3, 2, or 1 and so on.

I am using the below filters:

1) Opportunity status equals Active
2) From Stage equals 2
3) To Stage equals 1
4) From Stage equals 3
5) To Stage equals 1, 2
6) From Stage equals 4
7) To Stage equals 1, 2, 3
8) From Stage equals 5
9) To Stage equals 1, 2, 3, 4

1 AND ((2 and 3) or (4 and 5) or (6 and 7) or (8 and 9))

Now this report never gets generated. Times out all the time. Maybe due to so many opportunities on which to put these many filters.
Can anyone pls help me optimize the performance.