Cognos v11 reporr ezportes to Excel versus CSV missing rows

[sanchoniathon]

Hi all,

How can we explain that while using Cognos v11 and exporting report to excel or csv. we are missing rows inbthe result ?!

Is this a bug and fix available ?

Thank you

[dougp]

Your question is not clear.  Are you saying one output format produces complete results and the other doesn't?  Or are you saying that Excel and CSV are both incomplete compared to something else (PDF, HTML)?

[sanchoniathon]

Hi and thanks for your question. EXCE and CSV formats produces report output with LESS rows (data) compared to HTML format.

[dougp]

Excel or Excel Data?

Are you saying that it's not enough rows, or not enough discreet outputs?

I think that Excel Data and CSV output formats return the results of one query.  If the page uses more than one query the output in one of those formats will not look like what is on the page.

[sanchoniathon]

Not enough rows

[sanchoniathon]

I mean is this known from IBM ? Bug ? Anyone knows ?

[dougp]

Excel or Excel Data?

[sanchoniathon]

DougP,

This issue happens for 1 or 2 reports only (that i'm aware of) and it's when we export to EXCEL DATA, we have a little less rows. Weird ? Like 20 rows less. Also, when exporting to CSV, and then opening it with Excel, we have 1 more row compared to EXCEL DATA. So EXCEL data and csv almost have same amount of rows but EXCEL 2007 has more rows. Thanks.

[dougp]

If your report page is more complicated than just a list (like if it has header information, or two lists) Excel and Excel Data/CSV will not match.  The report must be designed for the desired output.

For example, I have a report that builds a report header from some data and displays a list and a chart.  The list has a couple dozen rows.  If I run it to Excel Data, I get a single row that has the report header information.

Unfortunately, users can choose any output format available to their role.  It's too bad that output formats can't be enabled/disabled per report.