My requirement is below. I have a classic Report based on SQL query.
select A,B,C,D from table1;
I need to Show the column D only when the value is NOT null. Output when D have value
Col Val A -- 1 B -- 2 C -- 3 D -- 4 Col Val A -- 1 B -- 2 C -- 3 D -- NULL
I dont want to show the Row D when D is not null.
I tried to use server side condition in Column D. But I am not able to refer the value of column D. Cannot use Item is not null because D is not a page item.
Thanks,
Kokila