Crystal Report, Schedule a report and send it by mail

[caampaa]

Hi all,

I am running Crystal Reports 8.0,
I am trying to schedule a report and send the result via e-mail with no user interaction.

As far as here I found:
1) Crystal provides a small application to compile the report and is than possible to att the task to the windows scheduler, still this is not the best way suggested, nor it is complitely automatic, need user to trigger the report.

2) Using Crystal Enterprise it should be possible :

******************************************************
Configuration of the Crystal Job Server and SMTP
A. Log on to the Crystal Management Console as an administrator (

http://ServerName/crystal/enterprise/admin/default.htm).

· Replace 'ServerName' with the appropriate server name, domain name or IP address for the web site.

B. Click the 'Manage Servers' icon top open the Servers section.

C. Click the Server Name for the Crystal Job Server. This will open the properties for the Crystal Job Server.

D. Click the 'Destinations' tab.

E. Under the 'Destinations' tab, click 'CrystalEnterprise.Smtp'. This will open the Properties section for the 'CrystalEnterprise.Smtp'.
*********************************************************

The instruction are for CE8.5 and I am running CE8.
the "DESTINATION TAB" seems not to be available.
Is there any other place where this option can be set ?
Am I wasting my time ?

Thanks in advance for your help
Corrado

 

[rhinok]

As you have discovered, 'Set Destination' isn't available until CE 8.5. You're only option, without additional development, third-party products or manual intervention, is to upgrade to CE 8.5 Professional.

 

[synapsevampire]

CE 8 will not automatically schedule a report via email, 8.5 will.

There are numerous less expensive 3rd party solutions, I generally suggest Ido's (one of the strongest contributors here) solution.

http://www.milletsoftware.com

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[chelseatech]

I've also got a report scheduler that may be of interest.

Download the eval of cViewMANAGER from my web site.

There is a problem sending via email if you are running either Outlook2002 or an earlier version with the MS security patch. They require manual confirmation of each email message sent. The only way to avoid this is to use SMTP direct to the mail server.

As far as I'm aware there are only two schedulers that use SMTP to send reports via email (Ido's and mine). All the others require manual intervention for each message. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[synapsevampire]

Sorry, Chelsea, I should have plugged yours too.

Crystal Enterprise 8.5 uses SMTP and does scheduled emailing, but it's much more expen$ive.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[caampaa]

Thanks a log guys.

Corrado.

 

[Garyr999]

Have you tried Report Scheduler by CrystalDesk?

It is an easy to use scheduler that uses MAPI to automaticaly email reports.

You can download a trial version from the web site.

http://www.crystaldesk.com