nickfatool
IS-IT--Management
Using:
CR 8.5 Dev
Access 2000
Access 2000 Runtime
NT 4.0 sp5
I'm trying to determine whether I can distribute an Access 2000 app inclusive of the ActiveX CRViewer object.
I've shelled out for developer versions of both CR 8.5 and Office 2000 and now want to make something-simple work.
I've created a simple Access app with a single form, which includes the CRViewer; it works just fine on the design PC (which has Crystal already installed).
I have attempted to simply run the app on a PC with a full version of Access (but no Crystal Reports at all), I copied craxdrt.dll & crviewer.dll into the same dir path's as the PC it was designed on.
'Code behind the form **********************
Dim crApplication As New CRAXDRT.Application
Dim crReport As CRAXDRT.Report
Private Sub cmdViewReport_Click()
Set crReport = crApplication.OpenReport("\\Server\Share\sample.rpt"
CRViewer1.ReportSource = crReport
CRViewer1.ViewReport
CRViewer1.EnableGroupTree = False
CRViewer1.DisplayGroupTree = False
CRViewer1.EnableExportButton = True
CRViewer1.Height = 18500
CRViewer1.Width = 13000
End Sub
'Code Ends *********************************
When trying to execute cmdViewReport I receive the error: "ActiveX component can't create object"
The CR library objects are visible on the target PC, but it looks as if the libraries themselves just haven't "stuck".
I know I'm missing something truly obvious..
Has anyone successfully distributed the viewer on Access?
The Crystal site has little info on MSOffice integration.
Any help would be greatly appreciated,
Thanks,
Rob.
CR 8.5 Dev
Access 2000
Access 2000 Runtime
NT 4.0 sp5
I'm trying to determine whether I can distribute an Access 2000 app inclusive of the ActiveX CRViewer object.
I've shelled out for developer versions of both CR 8.5 and Office 2000 and now want to make something-simple work.
I've created a simple Access app with a single form, which includes the CRViewer; it works just fine on the design PC (which has Crystal already installed).
I have attempted to simply run the app on a PC with a full version of Access (but no Crystal Reports at all), I copied craxdrt.dll & crviewer.dll into the same dir path's as the PC it was designed on.
'Code behind the form **********************
Dim crApplication As New CRAXDRT.Application
Dim crReport As CRAXDRT.Report
Private Sub cmdViewReport_Click()
Set crReport = crApplication.OpenReport("\\Server\Share\sample.rpt"
CRViewer1.ReportSource = crReport
CRViewer1.ViewReport
CRViewer1.EnableGroupTree = False
CRViewer1.DisplayGroupTree = False
CRViewer1.EnableExportButton = True
CRViewer1.Height = 18500
CRViewer1.Width = 13000
End Sub
'Code Ends *********************************
When trying to execute cmdViewReport I receive the error: "ActiveX component can't create object"
The CR library objects are visible on the target PC, but it looks as if the libraries themselves just haven't "stuck".
I know I'm missing something truly obvious..
Has anyone successfully distributed the viewer on Access?
The Crystal site has little info on MSOffice integration.
Any help would be greatly appreciated,
Thanks,
Rob.