Skip to Content
0
Former Member
Jan 13, 2010 at 04:41 AM

Dynamically hiding row based on value

15 Views

I have a situation where if value of column2 (which is calculated KF) value is 0 then I need to hide a complete row. This should happen dynamically through query. How to achieve it?

I know zero suppresion and display/hide option in query designer. But this will not work here as my condition is specific to a value in certain column

If :

Column1        Column2     Column3

A              30             500
B              0              84
C              400            432
D              0              321

Then:

Column1        Column2     Column3

A              30             500
C              400            432