Author Topic: RESOLVED: Excel Output List Content Missing  (Read 6266 times)

Offline locus

  • Senior Member
  • ****
  • Join Date: Nov 2012
  • Posts: 53
  • Forum Citizenship: +1/-0
RESOLVED: Excel Output List Content Missing
« on: 04 Feb 2016 12:50:37 am »
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.
Nothing.

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?

CHeers,
Locus
« Last Edit: 12 Feb 2016 04:45:51 am by locus »

Offline locus

  • Senior Member
  • ****
  • Join Date: Nov 2012
  • Posts: 53
  • Forum Citizenship: +1/-0
Re: Excel Output List Content Missing
« Reply #1 on: 04 Feb 2016 02:32:10 am »
Also,

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
Code: [Select]
The file format and extension of '.xls' don't match. The file could be corrupted or unsafeThis option takes an eternity to come back

Locus


Offline locus

  • Senior Member
  • ****
  • Join Date: Nov 2012
  • Posts: 53
  • Forum Citizenship: +1/-0
Re: RESOLVED: Excel Output List Content Missing
« Reply #2 on: 12 Feb 2016 04:47:10 am »
Rebuild everything from scratch.

ETL
Framework Manager
Report

Sometimes that's what it takes!