How can I schedule a report to run

[terenceb]

Hi All,

I am run Crystal 8.5 connecting to a SQL table from Cashe database. We own a version of Crystal Enterprise 8. And would like to schedule a report to export a file in the format of Character seperated-values to a shared folder on a NT platform.

 

[Grelber]

What part of this process is causing you a problem?

Mike S

 

[MJRBIM]

First of all, is Crystal Enterprise installed and working already - or is it still a CD in a box on a shelf? If it's not installed yet, you may not want to install CE 8.

I'm not sure if you can publish Crystal Reports 8.5 reports into a Crystal Enterprise 8.0 environmnet, normally the version of Enterprise has to be the same of higher. I think you will either have to save your RPT files back as Version 8, or upgrade your Enterprise to 8.5.

Also, you should "hold off" on moving Crystal Enterprise 9 unless you want to upgrade your reporting too, as 9 is not able to save-back into earlier versions.

That being said, once you have installed Crystal Enetrprise on a webserver (DEFAULT server is usually OS = Windows2000 running I.I.S.), and are able to publish your RPT files to the Enterprise environment you will want to do the following.

1.) Enable and configure the destination CrystalEnterprise.DiskUnmanaged on your Job Server.

2.) Use the default ePortfolio interface to Schedule your Report Object with a Recurring (eg. Daily, Weekly, Monthly) run-time, an Unmanaged Disk destination, and a Character Separated Value format.

This is covered in the PDF documentation that ships with Crystal Enterprise, but in covered in more detail in the book Special Edition - Using Crystal Enterprise 8.5 from Que publishing.

Hope it helps...

 

[synapsevampire]

terenceb : Nothing prevents you from doing this, however I don't think that the CE 8 Standard that came with CR 8.5 allowed scheduling.

You'll need to upgrade or write code.

-k