Link to home
Start Free TrialLog in
Avatar of aninec
aninec

asked on

Automatically Create Crystal Reports on set schedule and send report to a server

Is the following scenerio possible - and if so how?
Crystal 8 or 9 or 11 are avaiable

I need to send data in text form to a server and then off through a FTP utility.  I have created a file that I manually export out and use pipeline and delete the delimited ".  . How do I get Crystal to create this text file in the mentioned format and move the information to my server on a set schedule?
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Yes you'll need the Crystal Reports XI Server...this is their latest and greates Crystal "enterprise" product.
As indicated by mlmcc and CRXIuser2005, you can accomplish this through a combination of Crystal Reports (version XI) and Crystal Reports Server.

Essentially, the steps would be:

1) Create a report that formats the data for .csv output
2) Schedule the report in Crystal Reports Server to run, export to .csv format and set destination to FTP

If you purchase a copy of Crystal Reports XI Professional or Developer then you will get a free copy of Crystal Reports Server with five non-expiring named-user licenses.  You will need a server upon which to run the software unless this job is the only job you'll be running (in which case, a spare XP Pro desktop should work just fine).  If you decide that this is what you want to do, please post a new question regarding installation tips, guides, etc...

~Kurt
Avatar of Mike McCracken
Mike McCracken

Glad i could help

mlmcc