If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Scheduled report with output to Excel lose data

Started by MellBI, 01 Sep 2010 09:01:27 AM

Previous topic - Next topic

MellBI

Hi,

I have got a report scheduled to run and save as Excel every night and sometimes the result is not complete.
There are missing rows in the Excel file.

When I run the report interactively (to Escel) the rows are allways included.

Any ideas of where to start looking for a solution.
The recipients are not that happy when they cannot trust the scheduled report

Regards
MellBI

technomorph

Assuming you're using 8.4, and if appropriate, you could try saving as Excel 2007. This has resolved quite few issues for me. If the users are using an old version of Excel I there is a conversion patch you can download for Office.

MellBI

The report is scheduled with Excel 2007,

Right now we are testing if scheduling as .csv is more reliable

/MellBI