
Crystal Hangs App With 1800 page report
Marco,
Thanks for jumping in and offering some help. Here's some additional info.
1. I'm using a form with the CRViewer control and, following the
documentation from Crystal, I'm using the following code:
Private m_objCrxApp As New CRAXDRT.Application
Private m_objReport As New CRAXDRT.Report
Private Sub ShowMe()
Set m_objReport = m_objCrxApp.OpenReport(App.Path & "\reports\" &
m_sRptName, 1)
Me.CRViewer.ReportSource = m_objReport
m_objReport.Database.SetDataSource m_objRst
m_objReport.ReadRecords
Me.CRViewer.ViewReport
m_objRst.Close
Set m_objRst = Nothing
Me.Show
End Sub
You'll note that I have an object variable for the Crystal application.
2. When the form unloads, I set these the two object vars to Nothing. THAT'S
where the application hangs. It takes about 15 seconds for control to return
to the application.
3. I had tried using embedded reports but the result was about the same.
As for the application itself, it lists publishers and their publications.
The particular report in question lists publishers with the most
publications at the top, least number of publications at the end of the
report.
Any ideas? Is it simply a matter of reducing the size of the report?
Jeff
Quote:
> Wow, 1800???????????
> you already said the answer for your question.
> If i were you, i would try to separate the pages, example, call CR
Control,
> 3 times, with 600 pages on each.
> I dont know tour kind of application, so if you tell me more about it, i
can
> help you better.
> > I've run into the following problem. I have a report that is 1800 pages
> > (yeah, it's a big report!). When I unload my form that has the Crystal
> > Previewer, the whole application hangs. This does not happen with
smaller
> > reports. Any ideas?
> > I'm using VB 6.0 and Crystal 8.5.
> > TIA,
> > Jeff