Report generation takes a LOOOOONG time for 7-page report 
Author Message
 Report generation takes a LOOOOONG time for 7-page report

I am using CR.NET. Here is the subrouting that creates the print
preview. The frmPrint window has only the CR report viewer control on
it. I try to print a small seven page report and display it to the
screen. Each page has 6 line charts on it.

This shows that it takes over two and a half minutes to generate. This
is a very long time especially if you consider a full report printout
for my application would be 20 pages.

Is there any way to show a dialog box form for "Creating report,
please wait..." with a progress bar and status information about which
page it is generating, AND allowing the user to "Cancel" the report,
IMPORTANT: EVEN IN THE MIDDLE OF THE LONG
"CrystalReportViewer1.ReportSource" processing?

For a 20 page report this would take almost 8 minutes while showing
almost nothing to the user. The user might think the command did not
work and select it again! Also, what if they selected the command in
error and after a minute decides to cancel the report. As it is now,
he must wait 8 minutes before he can use the program again!

    Private Sub mnuFilePrintDetail_Click(ByVal sender As
System.Object, ByVal e As System.EventArgs) Handles
mnuFilePrintDetail.Click

        Dim frm As New frmPrint()

        Dim dt As DateTime = Now

        StatusBar1.Panels(0).Text = " Analyzing data..."
        Debug.WriteLine(Now.ToString("hh:mm:ss.fff") & " Analyzing
data")
        MakeTestBlobs()

        StatusBar1.Panels(0).Text = " Setting data source..."
        Debug.WriteLine(Now.ToString("hh:mm:ss.fff") & " Setting data
source")
        Dim report As New CrystalReport2()
        report.SetDataSource(dsEverything)

        StatusBar1.Panels(0).Text = " Setting report source..."
        Debug.WriteLine(Now.ToString("hh:mm:ss.fff") & " Setting
report source")
        frm.CrystalReportViewer1.ReportSource = report
        frm.Show()
        StatusBar1.Panels(0).Text = ""

        Debug.WriteLine(Now.ToString("hh:mm:ss.fff") & " Finished")

End Sub

The Debug windows report:

01:34:02.970 Analyzing data
01:34:15.739 Setting data source
01:34:25.983 Setting report source
The thread '<No Name>' (0x88c) has exited with code 0 (0x0).
01:37:02.579 Finished



Sat, 09 Apr 2005 05:43:38 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Report generation takes a LOOOOONG time for 7-page report

2. Report generation takes a hell of time

3. server time reported on .asp web pages, how do I report client side time correctly

4. Reports, reports, reports, reports.....REPORTS!

5. Cryatal takes too much time for Report Generation ! Help...

6. Crystal Reports (two page reports)

7. Help Multiple page Report with Crystal Report

8. How to take the page totals of a report in Crystal Report 5.0

9. Suppress Main Reports Page Header on sub-report

10. CRYSTAL REPORT, run time query report by date

11. Crystl32.ocx shows blank report at second time report is generated

12. How to set a report time on crystal report

 

 
Powered by phpBB® Forum Software