How to add empty row in query

[Former Member]

Hello

I need to enter empty row in query in order to maske report more readable :

vvv bbb ccc

margin 6 8 55

sales 4 44 22

How its possible to do?

I created formula (1-1)/0 with empty description. It shoes x x x but I dont like this approach.

[Former Member]

Maybe not the best solution, but you can adjust the way it displays those xxx

In IMG:

SAP Netweaver > Sap BIW > Report relevant settings > General report settings in Bex > Presenting the numeric value in Bex

[Former Member]

Thanks

But... it will effect all other numeric values what I dont want.

[Former Member]

Have you tried the zero suppression options in the query properties?

**Ofcourse you would have to change the formula to "=0" and it would supress all zeroes...