APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hide / Show Sql report column conditionally

TauceefJan 25 2012 — edited Jan 25 2012

Hello All,

I have a sql report in which I want to show or hide some columns wrt there value.

If in a column any row have value != 0 then I want to show that column else not. Means if all the rows have value = 0 then that column should not display at all.

I tried to give condition to the column in column attributes "Value of Item / column in Expression 1 = Zero" but its not working.

one more thing my report has "Use Generic Column Names (parse query at runtime only)" radio button checked.

Plz let me know If anyone has done this before.

Apex 4.1
Oracle 11gR2

Regards
Tauceef

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 22 2012

Added on Jan 25 2012

#apex-discussions

4 comments

1,867 views