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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
Glad i could help
mlmcc
mlmcc