When running the report in BIDS all the work (other than the database work) is being done locally on your PC. When running in IE from a report server the report server is doing most of the work and IE is just rendering the HTML.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question