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



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

Main Menu

RESOLVED: Excel Output List Content Missing

Started by locus, 04 Feb 2016 12:50:37 AM

Previous topic - Next topic


Hi Folks,

This old chestnut has been queried many times in one way or another over the years, across different versions of Cognos.
In this case 8.4.1

I have reports that run fine in HTML, but on export to any spreadsheet format, including CSV, they are blank.
Now when I say blank, the header, footer, page#, date/time stamps are all there, but the list area is blank. No column headings either.
Just an empty space in the report.

Worth noting that PDF also has the same result.

I have downgraded the version of IE, testing each one, from IE11 to IE7.
Added parameter overrides for xls/xlsx to the environment settings in administration.

The one change I did notice as I was going down the versions of IE, was that an error message I have seen several times before was cropping up.
Along the lines of "The file type and extension don't match", with a corrupt file warning, but proceeding has the same file content as above. No data.

I have recently inherited a Cognos solution, that is, to say the least, dirty and disorganised so I have little history of how it was put together.
I am systematically pulling it back into shape by working through a list of logged issues, and others that I have come across during my analyses.
What I do see is that the company has been having this particular issue since July 2015.

Has anyone come across this before?




The Parameters are displaying in the output "ParamDisplayValue" - The prompt criteria selected.

For different formats, different responses but same result:

1. Excel 2007 - Straight to empty report
This option comes back in a few seconds

2. 2000 Single Sheet - Warning message and then to empty report The file format and extension of '.xls' don't match. The file could be corrupted or unsafe
This option takes an eternity to come back



Rebuild everything from scratch.

Framework Manager

Sometimes that's what it takes!