Dear All,
After searching extensively SDN since the past couple of weeks, I'm posting this requirement.
My client requirement is, since one of their report is taking long to execute in foreground, has asked it to be executed in background. But here is the catch:
1. Report must be executed in background, but since with OPEN DATASET, the report would be dumped in CSV format on the application server
2. I need the report to be dumped in excel format, alongwith color legends (OLE concept) but not sure how OLE can be used to convert a CSV file into an XLS file on the application server
3. The converted XLS file need to be transported to an FTP server (using FTP protocols)
So dear alll, please help me in the possibility of the scnerio, whether the requirements is possible and if yes, what should be the sequence of technologies used OPEN DATASET-OLE-FTP???
My final requirement is, that the report executed in background, must automatically dump the XLS file with color legends on the FTP server!!!!
Thanks in advance