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?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Marcus Aurelius
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
Crystal Reports
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
