I don't remember in which version I created the original reports, it wasn't in CR XI.
I read something about some reports keeping old connections and then displaying the report after timing out the connections on tables, but I doubled checked that everything was pointing to my actual DB. I used to use pervasive, but that was many many years ago, I switch to SQl Server 2005, at least 7 to 8 years ago and all the reports run just fine in XP.

Thanks David, in fact, I recreated two of the troubled reports exactly as the original and now it loads fast. Thanks Again.