Software

Ask something
Discussion Locked

Crystal Report 10 and Excel

0 helpful
3 replies

by jtestado

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by james.artisensi

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.

by jtestado

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.ViewReport
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.

This discussion is closed to new replies.