Thanks a lot for the immediate response.

Here are the Details of my SQLServer,

Edition Enterprise Edition

ProductLevel SP3

ProductVersion 9.00.4035.00

ResourceVersion9.00.4035

Yes, all are running on the same server.

Yes, i can see the result of the query in 10 to 20 sec in BIDS as well as Management studio.

I'm just running this in Report Manager (HTML) or Reportserver.

It is a normal chart report and its just using embedded T-SQL.

I've not used any network trace utility, can u suggest me how to use that?

Hope these details will help you to understand the problem.

Please let me know if you have any suggestions.

Thanks,

Ramu