SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Crystal Reports Object

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Crystal Reports Object
Author Message
Kim



Joined: 12 Jan 2006
Posts: 3

Post Crystal Reports Object Reply with quote

I'm trying to create a Crystal Reports Application object in Visual Basic and I'm not having much luck. In my registry, I believe the crw32.dll is buried in CrystalReports.shell.open.ddeexec.Application and I don't know how to make a registry call that deep in the registry. Please let me know if you have any tips or tricks.

Thanks,
Kim

Wed Jan 11, 2006 4:42 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7970

Post Re: Crystal Reports Object Reply with quote

Here is a copy&paste from the examples

''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'
' Credit: Carla Moreira - 4/19/2001
'
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Sub Main( )

' Declare script variables

Dim AppCrystal, CrystalReport, CrystalOptions

' Create Crystal Report engine Automation Server

Set AppCrystal = CreateObject("Crystal.CRPE.Application")

' Open the report for print -> export

Set CrystalReport = AppCrystal.OpenReport("Report_Path_&_Name")

' Define the export options

Set CrystalOptions = CrystalReport.exportOptions

' What format the report will have:

' Code for crEFTWordForWindows = 14

CrystalOptions.FormatType = 14

' The Subject line and Message

CrystalOptions.MailSubject = "Testing Report Export via E-Mail"

CrystalOptions.MailMessage = "Any message to recipient..."

'The destination list or e-mail address

CrystalOptions.MailToList = "DistributionList@service.xxx"

'What application it's being exported to

'Code for crEDTEmailMAPI = 2

CrystalOptions.DestinationType = 2

'Export the report.

'True means manual intervention will be required.

'False means programatical export.

CrystalReport.Export False
End Sub

: I'm trying to create a Crystal Reports Application object in Visual Basic and
: I'm not having much luck. In my registry, I believe the crw32.dll is
: buried in CrystalReports.shell.open.ddeexec.Application and I don't know
: how to make a registry call that deep in the registry. Please let me know
: if you have any tips or tricks.

: Thanks,
: Kim

Wed Jan 11, 2006 5:43 pm View user's profile Send private message
Kim



Joined: 12 Jan 2006
Posts: 3

Post Re: Crystal Reports Object Reply with quote

: Here is a copy&paste from the examples

:
: ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
: '
: ' Credit: Carla Moreira - 4/19/2001
: '
:
: ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
: Sub Main( )

: ' Declare script variables

: Dim AppCrystal, CrystalReport, CrystalOptions

: ' Create Crystal Report engine Automation Server

: Set AppCrystal = CreateObject("Crystal.CRPE.Application")

: ' Open the report for print -> export

: Set CrystalReport = AppCrystal.OpenReport("Report_Path_&_Name")

: ' Define the export options

: Set CrystalOptions = CrystalReport.exportOptions

: ' What format the report will have: ' Code for crEFTWordForWindows = 14

: CrystalOptions.FormatType = 14

: ' The Subject line and Message

: CrystalOptions.MailSubject = "Testing Report Export via E-Mail"

: CrystalOptions.MailMessage = "Any message to recipient..."

: 'The destination list or e-mail address

: CrystalOptions.MailToList = "DistributionList@service.xxx"

: 'What application it's being exported to

: 'Code for crEDTEmailMAPI = 2

: CrystalOptions.DestinationType = 2

: 'Export the report.

: 'True means manual intervention will be required.

: 'False means programatical export.

: CrystalReport.Export False
: End Sub

Thanks for your response. However, I don't have ("Crystal.CRPE.Application") in my registry, therefore, my VB script is failing. Is there something wrong with my installation or do I need to install a plug-in or something that allows me to have this in my registry?

Thu Jan 12, 2006 10:16 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7970

Post Re: Crystal Reports Object Reply with quote

You may need to reinstall Crystal Reports to fix your registry problems.

: Thanks for your response. However, I don't have
: ("Crystal.CRPE.Application") in my registry, therefore, my VB
: script is failing. Is there something wrong with my installation or do I
: need to install a plug-in or something that allows me to have this in my
: registry?

Thu Jan 12, 2006 10:35 am View user's profile Send private message
Kim



Joined: 12 Jan 2006
Posts: 3

Post Re: Crystal Reports Object Reply with quote

: You may need to reinstall Crystal Reports to fix your registry problems.

I've reinstalled Crystal Reports twice with our network license installation. And that registry key was not created during either installation. Is there a different registry key for a network license as opposed to a single desktop license?

Thu Jan 12, 2006 12:26 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7970

Post Re: Crystal Reports Object Reply with quote

Try CrystalRuntime.Application instead of Crystal.CRPE.Application

If that doesn't help please check with Crystal's support what you need to specify with your license type when accessing CRystal Reports via COM automation methods

: I've reinstalled Crystal Reports twice with our network license installation.
: And that registry key was not created during either installation. Is there
: a different registry key for a network license as opposed to a single
: desktop license?

Thu Jan 12, 2006 1:10 pm View user's profile Send private message
bobby



Joined: 25 May 2006
Posts: 1

Post Re: Crystal Reports Object Reply with quote

Hi,
I am having the same problem. Could you get your code
to work?
Thanks
Shweta

: I'm trying to create a Crystal Reports Application object in Visual Basic and
: I'm not having much luck. In my registry, I believe the crw32.dll is
: buried in CrystalReports.shell.open.ddeexec.Application and I don't know
: how to make a registry call that deep in the registry. Please let me know
: if you have any tips or tricks.

: Thanks,
: Kim

Fri Mar 24, 2006 6:01 pm View user's profile Send private message
Zwala



Joined: 25 May 2006
Posts: 1

Post Re: Crystal Reports Object Reply with quote

Hi
Im working with Crystal Reports.
After running, it was asking for the Crystal Report
logon window n diplaying the message that it cannot
logon to the CrystalReoprt.
Can u please send me the code to avoid this.

--zwala

Thu May 25, 2006 7:55 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7970

Post Re: Crystal Reports Object Reply with quote

Try
http://www.google.com/search?hl=en&lr=&safe=off&q=Crystal+report+COM+Login
or
http://www.google.com/search?hl=en&lr=&safe=off&q=Crystal+report+COM+Logon

: Hi
: Im working with Crystal Reports.
: After running, it was asking for the Crystal Report
: logon window n diplaying the message that it cannot
: logon to the CrystalReoprt.
: Can u please send me the code to avoid this.

: --zwala

Thu May 25, 2006 8:22 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.