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

Empty rows in excel output

Started by Ludijak, 30 Dec 2021 04:15:42 AM

Previous topic - Next topic

Ludijak

Hi,

when I export my report to excel it has empty rows, but in html or pdf that isn't the case.

I'm working with dimensional data where for each position in report I have 3 levels. What I needed to do was to show data grouped for company when level <3 and for level = 3 to have total with custom text. It's supposed to look something like this:

Pos|  C  | Measure
     |  a  |     1
A   |  b  |     2
     |  c  |     3
     |  a  |     2
B   |  b  |     1
     |  c  |     1
C   | NA |   11

where C would normally be like:

     |  a  |     3
C   |  b  |     3
     |  c  |     4

and positions A and B are level 1 and 2 and position C is level 3.

I did this by adding new data item which takes total alongside one which is grouped for company and conditionally formatted first to hide for positions under level 3, and second to hide for level 3 positions.

Now when I export to html i get exactly what I want, but when I export to excel I have something like this:

Pos|  C  | Measure
     |      |
     |  a  |     1
A   |  b  |     2
     |  c  |     3
     |      |
     |  a  |     2
B   |  b  |     1
     |  c  |     1
C   | NA |   11

For each position under level 3 there is empty row on top, when I switch order of those data items then I get something like this:

Pos|  C  | Measure
     |  a  |     1
A   |  b  |     2
     |  c  |     3
     |  a  |     2
B   |  b  |     1
     |  c  |     1
     |      |
     |      |
C   | NA |   11

I've been stuck on this for quite some time now and can't seem to find solution, I hope someone would have some better idea.

Take notice that there are many different positions for each level so solution can't be position specific.

dougp

My guess is that there are rows there (column body cells, blocks, etc.), they just don't have any data.  Take a look at the HTML using the browser's developer tools.