Hi,
I am new to Crystal Reports and DTS. What I need to do is schedule a Crystal
Report to run thru DTS package. Here is a sample code that I found on google
but it doesn't seem to be working.
'****************************************
' Visual Basic ActiveX Script
'****************************************
Function Main()
Dim CrystalApp
Dim CrystalReport

Set CrystalApp = New CRAXDRT.Application
Set CrystalReport = CrystalApp.OpenReport("C:\Documents and Settings\....rpt")

CRviewer1.ReportSource = CrystalReport
CRviewer1.ViewReport

Main = DTSTaskExecResult_Success
End Function

I am getting the following error:
ActiveX Component can't create object 'CRAXDRT'

Can anyone please help me with the error that I am getting?
Any help is greatly appreciated.
Thanks,

Is Crystal Reports installed on the server? Is it installed on your local
PC?

Rick

"P S via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

No, Crystal Reports is not installed on the server but its installed on my PC.

Do I need to install Crystal Reports on the server? Do you think the code
looks Ok?
Appreciate your response.

ps_newbie
Thanks,

Rick Gittins wrote:

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200508/1