VLDB Web App using Crystal Reports

[dinome2000]

We are just looking for any info if anybody out there as tried returning 300mb of data and then generating the crystal report, which is where the process is slowing down. The query returns the results fast to the webserver, but then it is taking over 5 minutes to just create/generate the 1st page of the report. Then when we click on the next page, it takes the same amount of time as the 1st one and on and on. We require the reports use grouping and subtotals. Crystal as already told us this is a problem, we were just wondering if anybody as seen this and been able to resolve it!

On client/server, it runs fine, but using SQL Server/IIS and ASP Dynamic pages for the WEB(which is required) it runs super slow. Any help would be appreciated. Would using ADO Paging be of any help in this situation?

Here is a snippet of the code. Also we are using version 9 of Crystal Reports.

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
Dim report
Dim crReportObject As ReportObject
Dim TextObject As TextObject
Dim query As String

query = strsqlquery2020

Dim conn As SqlConnection = New SqlConnection(connstr_misc)
Dim myDA As SqlDataAdapter = New SqlDataAdapter(query, conn)
Dim myds As DataSet = New DataSet()
myDA.SelectCommand.CommandTimeout = 9999
myDA.Fill(myds)

report = New CR2020()
report.Database.Tables("ado").SetDataSource(myds.Tables(0))

For Each crReportObject In report.Section1.ReportObjects
If crReportObject.Name = "Text24" Then
TextObject = CType(crReportObject, TextObject)
TextObject.Text = date1
End If
Next

CrystalReportViewer1.ReportSource = report
CrystalReportViewer1.RefreshReport()
CrystalReportViewer1.Zoom(120)
End Sub

Hope this helps.

Thanks.
Gabe

[txbakers]

Have you taken a look at Actuate instead of Crystal?