Kiran,
Do a search here on TekTips about caching servers. We had the same problem and got a tip towards the resolution from the forum. We wound up reinstalling several times without success. We never had a problem on a Compaq server running Win2K but boatloads of problems on a Dell server (go figure). In any case, your search will turn up mention of changing the caching time on Crystal to 10,000. We tried that and it worked but the number seemed high. Crystal suggests a setting of 10! Somewhere in between seems to work best (so we're no tying up threads for expired processes). After (much) prodding, Crystal support they fessed up to the fact that there is a patch (that they don't list on their support board) which allows you to change other web server time-out and caching values (something the base product without the patch won't let you do). A combination of changing both these values resolved the problem for us. I'm off this week so I don't have my notes with me but if this doesn't help let me know and I'll dig them up when I get back.
Regards,
Jerry Capute
jcapute1@hotmail.com