Skip to Content
avatar image
Former Member

How to hide rows without data or all zero?

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 20, 2008 at 09:51 AM

    Hi,

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

    Regards

    Pcrao.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 09:48 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2008 at 09:49 AM

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

    Thanks

    REddy

    Add comment
    10|10000 characters needed characters exceeded