How to hide rows without data or all zero?
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.