I have an web application written in vs2008 which allows users to select certain criteria and then print a report. To do this I build a dataset and then pass this to a crystal report. Recently due to the increase in number of records in the database this report has become extremly slow to produce. Does anyone have experience of using sql stored procedures or sql views as opposed to building a dataset and the effect on the speed of production of a report