Crystal Hangs App With 1800 page report 
Author Message
 Crystal Hangs App With 1800 page report

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



Fri, 20 Aug 2004 02:18:30 GMT  
 Crystal Hangs App With 1800 page report
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.




Quote:
> 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



Fri, 20 Aug 2004 21:09:40 GMT  
 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



Sat, 21 Aug 2004 04:05:16 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Crystal reports 8.0 hangs Crystal Page Server service

2. Crystal Reports v9 hangs in ASP page on Win2K and .NET Server

3. Two App's hanging using Crystal Reports at same time

4. VB app hang after running Crystal Report

5. Dates in the 1800's

6. Crystal Reports ASP Application hangs when running long reports

7. Report displayed using Crystal ActiveX viewer shows blank pages after scroll to last page

8. Crystal Reports New page after gives a blank page

9. App hangs when destroying report objects

10. Crystal Reports hangs Win NT 3.51

11. View Crystal Report From VB on CItrix - HANGS / TLV Error

 

 
Powered by phpBB® Forum Software