COGNOS Impromptu v7.4.3 - Export to XLS and CSV Issues
Good Afternoon,
We are using COGNOS Impromptu v7.4.3 on a Windows 2003 server with SQL 2005. We have reports that we export to XLS and CSV using a COGNOS macro and are noticing two inconsistent issues:
1) Sometimes the export to XLS creates a corrupt XLS file. The macro does not throw any errors; however, when you try to open the excel file you receive the following MS Excel Error: 'Report.xls' cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.
The version of office we are using is MS Office 2003. We have tried reinstalling impromptu as well as office but the error persists.
We did find a work-around that seems to work by reordering the reports in the macro but this is not a consistent solution (i.e. we still get corrupt files sporadically).
2) When we export to CSV, somtimes partial data is missing in the totals column. The PDF and XLS format does show data but not the CSV? When we generate the report manually using Impromptu and export to CSV (outside the macro) the data is fine.
To provide a little background on the macro, basically it loops through two .IMR reports (outer-loop) and then loops through a list of accounts (inner-loop) to generate the report in PDF, CSV, and XLS format. We have not seen any issues with the PDF version (just XLS and CSV).
Any help on either of the above issues would be greatly appreciated. Thanks!
Solution: COGNOS Impromptu v7.4.3 - Export to XLS and CSV Issues
This sounds like a timing issue. We need to see the macro as mentioned, but I suspect it is running the output before the reports have finished generating.