VLDB Web App using Crystal Reports

Question

VLDB Web App using Crystal Reports

dinome2000

Grasshopper

Points: 13
More actions
March 11, 2003 at 9:21 am

#79737

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 fast, but then it is taking over 5 minutes to just create the 1st page of the report. 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.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

jpipes SSChampion Points: 12230 More actions · Answer 1

My guess is that you are using a connected recordset in the Crystal Session object? Am I correct? Can you post some snippets of the ASP code you are using to generate the report. We have developed ways around some major performance problems using Crystal...also, what version of Crystal are you using?

dinome2000 Grasshopper Points: 13 More actions · Answer 2

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

CrystalReportViewer1.RefreshReport()

CrystalReportViewer1.Zoom(120)

End Sub

Hope this helps.

Thanks.

jpipes SSChampion Points: 12230 More actions · Answer 3

I don't have adequate experience with the .NET to comment on your code, however, I would first analyze the difference between you client-server code-base and your ASP.NET code-base. I did notice you are Dimming report without a strong type:

quote:
Dim report
Dim crReportObject As ReportObject

Perhaps the lack of strong typeing is affecting performance? Let me know your results!

dinome2000 Grasshopper Points: 13 More actions · Answer 4

Well we tried what you said and it didn't make a difference. We are also still waiting for a call back from Crystal support......will let you know what we hear back from them.