How to hide rows without data or all zero?

[Former Member]

Hi.experts:

I have define a query that using query designer,and I have defined structure for both row and column,and then I have a free chatacteristic,such as 0MATERIAL,if I navigate by material then in each row,the material looks like read all the master data and displayed in the result area.

How can I hide these row without data.(or to say all with zero).where to using supress zero etc to avoid this?

Your quick response is highly appreciated!!Thanks in advance.

Best Regards

Martin Xie

[Former Member · Accepted solution]

Hi,

Right click on your query-->All Characteristics >supress zero results rows>select ''Allways''.

Regards

Pcrao.

[former_member181964]

Goto Query Properties and Display and Zero value Display select supress Zeros and Supression = Active.

Thanks

REddy

[Former Member]

Hi,

you have the option of suppress zeroes in the properties of the queries where you can give the option whether you want to supress the rows or columns as well which conatains zeroes.

Thanks

Ajeet