Avatar of 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 Reports

Avatar of undefined
Last Comment
Mike McCracken
Avatar of Mike McCracken
Mike McCracken

Blurred text
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.
See Pricing Options
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...

Avatar of Mike McCracken
Mike McCracken

Glad i could help

Crystal Reports
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.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo