Hi Sean

Thanks for your response.

But the query runs fine in 47 seconds.

It just doesn't run in SSRS or Report Builder.

It used to work before.

So if you can help, please let me know what info are you looking for?