Display Missing column

[Anonymous]

Hi all

I have one table (T1) as below

System

  Report    12a  12c  12f   12h

P                5     1       3      2

Q                2     4       5      1

R                3     2       2      4

Here we can notice columns 12b, 12d, 12e, 12g are missing. I want to display with 0 amount. I'm unable to insert QV file.

So if anybody can guide me.

Thanking you in advance

[sunny_talwar · Accepted solution]

Are those values missing or null for the reports that are visible? May be try unchecking 'Suppress Zero Values' on the presentation tab and see if that helps

[Anonymous]

It's suppressing some other rows which already have zero/null amount

[sunny_talwar]

Not sure I understand your comment/question?

[Anonymous]

Let take this way

I have one table (T1) as below

System

  Report    12a  12c  12f   12h

P                5     1       0      2

Q                0     0       0      0

R                3     2       0      4

-                  0     0       0      0

In fact columns 12b, 12d, 12e, 12g are not exists at all, so I added through inline statement.

By this I am getting blank row at the end as above; now if I try to suppress It suppress all column and rows having null/zero values

Thanks

[sunny_talwar]

Try to 'Suppress When Value Is Null' on the dimensions tab for Report dimension