VB Crystal Report >> Infinite loop with crystal control viewer

by Martin » Wed, 11 May 2005 02:10:15 GMT

Hi:
Here in my company we have been trying to figure out (for several days
already) what is the weird reason that is doing the crystal control
viewer (crviewer.dll) act this way.

When we are previewing a report (that is using an Access Database as it
source), we call this snippet of code...

With CRViewer1
.EnableDrilldown = False
.EnableGroupTree = False
.Top = 0
.Left = 0
.Height = ScaleHeight
.Width = ScaleWidth
.Zoom (100)
.DisplayBackgroundEdge = True
.DisplayTabs = False
.ReportSource = m_crReport
.ViewReport 'Here, the VB.EXE Process jumps to 100% usage
End With

Just after we call CRViewer1.ViewReport method, the application hangs
and VB6.EXE jumps in the CPU Usage (verified through Task Manager).

There is no way to close the app (or Stop VB6), the only way to start
again is kill the process and start again... It's getting us crazy!

Here is some information about our environment
- Running on W2K
- Applied latest set of MDAC and OLEDB JET libraries (just in case it
was an Access problem) - Jet 4.0 Service Pack 8 -
- This error happens regardless whether we are in the VB IDE or if the
app is compiled.

Please, if anyone had experienced a similar problem, I would really be
thankful for your help.

Any idea would be appreciated.



VB Crystal Report >> Infinite loop with crystal control viewer

by Dale » Wed, 11 May 2005 04:38:41 GMT

Martin, does the report run fine on it's own - if you open it in Crystal
Reports, does it run without problems? If it has problems, did you
doublecheck how you have linked the tables together?




Similar Threads

1. API VBA: Infinite Loop

Why doesn't escape end an infinite loop in SolidWorks VBA Editor.  It works
in the one for excel.  Is there something else I could do.

Corey Scheich


2. Problem with Form.ValidateChildren (infinite validation loop?)

3. Infinite loop querying remote WMI

I am using a GetObject statement to read the WMI on a remote pc. 

If the WinMgmt service is not working properly (remotely) the VB code hangs 
with a message ("waiting for an OLE.." etc etc).

As this is not an error message the VB code is not capturing it and will 
progress no further and not allow me to quit out.

Any Ideas?

Otherwise - is there a way to return the remote RAM of a pc without using WMI?

Matt

4. Calling code in DLL that has an "infinite Loop" - Visual Basic/VB

5. Infinite While Loops

Try this...

     While ucase(right(select.text, 10) <> "EVENT DATE"
             Selection.MoveRight Unit:=wdWord, Count:=1, Extend:=wdExtend
     Wend

Mark



6. Weird infinite loop - Visual Basic/VB

7. XP Setup in an infinite loop

I tried to repair XP by upgrading it.  Hoping to install a good copy over a 
suspect one and not have it destroy all my installed programs and files.  At 
the 39th minute of the setup procedure I received a Fatal Error warning.  The 
setup stop, shows me the setup error log, then it closes out and reboots the 
computer.  The computer starts at the exact same place and repeats the 
process.  It is like an infinite loop.  I have pushed every F-key and I have 
shut off the computer and turned it back on to no avail.  It startsd the 
process over.  How can I stop this?  I would rather run a buggy version of XP 
than to be in this infinite-loop Hell.

8. GetWindow - Infinite Loop?