Crystal Reports with VS.Net slow

[steve_c]

Hi all - my crystal reports with vb.net take an age to load - I'm using datasets. Having looked around - I can see a lot of people saying I should use OLE or connect to the SQL Server Directly - I've about 20 reports so fa r- how would I go about changing the way in which they are created? At the moment I have a prefview form with this code:


Dim orpt As New rptlibrarylist()

'Fill Dataset
Me.SqlSelectCommand1.Parameters("@customerid").Value = global.selectedlibrarycustomerval
DAPrintLibrarylist.Fill(DsPrintLibraryList1)


orpt.SetDataSource(DsPrintLibraryList1)

'Set Report
CrystalReportViewer1.ReportSource = orpt

I've got around it slightly by adding a hidden report onthe startup form so that crystal starts when a person logs into the windows app and the wait is obviously less noticeable - is this the best workaround?

Thanks.