I wanted to thank everyone again for your help, I rebuilt the stats and it works like a dream every report in 1-2 seconds. Your all the true heroes!
Thank you for reporting back. Sometimes we never find out what the problem was or what fixed it. This is very useful.