You can trick the user. Display a progress dialog of some kind. To the user, it will appear that the actual time it takes for the first pass is much shorter than it really is.
>Hi Craig,
>
>That's exactly what i am doing. It takes almost 6 - 7 seconds with 1000 records to actually view the final report. Thats a bit too much bcoz when the data increases, it will definetly go slower.
>So I wanted to know if there was some better solution.
>
>
>Thanks & Regards,
>JD.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer