Hi,
Any suggestion will be appreciated.
I have a query where I apply a couple exceptions, one to show all the lines with key figure (KF1) not equal to zero and the other one to hide all the lines with KF1 equal to zero. Is there any way, in the 2nd exception in which I need to hide all the lines with KF1 equal to zero yet leave the subtotal (currently equal to zero) in the query? This way I can have a nice summary report with all the zero subtals and for those non-zero subtals I can show all the line details.
Thanks.