Skip to Content
0
Former Member
Jun 25, 2009 at 08:37 PM

how to overrule a exception on the line items?

23 Views

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.