Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: MellBI on 01 Sep 2010 09:01:27 AM

Title: Scheduled report with output to Excel lose data
Post by: MellBI on 01 Sep 2010 09:01:27 AM
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
Title: Re: Scheduled report with output to Excel lose data
Post by: technomorph on 02 Sep 2010 05:50:36 AM
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.
Title: Re: Scheduled report with output to Excel lose data
Post by: MellBI on 02 Sep 2010 06:31:30 AM
The report is scheduled with Excel 2007,

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

/MellBI
Text only | Text with Images