Structure - suppress zero rows

[#1]

Hi BW people,

I found very similar topics on this forum concerning suppressing zero rows in structures but not exaclty the same case nor an answer.

<u><b>Query</b></u>

I have a structure in the rows with several selections (S1, S2, S3) and beneath that structure a characteristic. To keep it simple: there is only one key figure in the columns.

<u><b>Aim</b></u>

I would like to have the <i>non-zero</i> key figure for all materials (M1, M2,...) for each selection in the structure.

So it should look like this:

S1   M1   50
S2   M2   100
S3   M3   90

Unfortunately I get this:

S1   M1   50
S1   M2
S1   M3
S2   M1
S2   M2   100
S2   M3
S3   M1  
S3   M2   20
S3   M3   70

So, even if the key figure for M2 and M3 (for selection S1) is zero, it is shown because these materials have a non-zero key figure elsewhere in the selection.

<u><b>Condition</b></u>

I tried about every possibility of 'conditions', but again the same problem: they are evaluated on the whole structure AND material, and not on every separate line of the report.

Anybody a solution? I would be grateful as I have tried quite a lot of work arounds.

Thanks in advance!

[Former Member]

Probably you have tried this already, but just to make sure...

If you right-click on the structure in the query designer and select properties. There's a checkbox there that allows you to supress zero rows.

Does that not help you either?