General discussion


Crystal Report 10 and Excel

By jtestado ·
Hello everyone

i'm working on a Performance to Plan Report with data comming form a n excel worksheet using Crystal Report Viewer called inside Excel. The Rpt file has been previously designed. Now I managed to view the report but when I close the report it hangs and excel stops responding. I could be possibly caused this? Anyone please.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by jtestado In reply to Crystal Report 10 and Exc ...

Point value changed by question poster.

Collapse -

by james.artisensi In reply to Crystal Report 10 and Exc ...

could i get more specific details about this. I run similar things and have only run into this once before and it was after I edited the crystal.

Collapse -

by jtestado In reply to

okey, i used the following code :

Dim crxApp As New CRAXDRT.Application
Dim crxRpt As CRAXDRT.Report

Private Sub UserForm_Activate()
Me.Top = 1
Me.Left = 2
Me.Height = Application.Height - 5
Me.Width = Application.Width - 5
Set crxRpt = crxApp.OpenReport("C:\work\p2pengl.rpt")
CRV.Top = 2
CRV.Left = 2
CRV.Height = Application.Height - 10
CRV.Width = Application.Width - 10
CRV.ReportSource = crxRpt
CRV.Zoom (120)
End Sub
of course with a userform where the crystal report viewer object is placed. The Data source used by the rpt is a worksheet within the current workbook. There is no problem displaying the report itself. But when I try to close the report viewer and get back to excel, it hungs up, including the excel application.

Related Discussions

Related Forums