TO any guru out there... HELP!
Okay here is the problem -
I have matrix report and the sql behind the report runs fine. But the problem arises in my RepeatingFrame for the Matrix format Trigger. My results return beautiful matrix report. My format trigger on the matrix repeating frame tells the report to return false on the column if there is no result in the current row. But what I want is that if all the rows returned is null for a specific column then hide that specific column. but what happens is that the entire column is hidden if the first row is null for that column even if the subsequent columns are not null. HELP!
My system configuration:
Oracle 7.3
Oracle Reports 2.5
Thanks in advance
Sal
Okay here is the problem -
I have matrix report and the sql behind the report runs fine. But the problem arises in my RepeatingFrame for the Matrix format Trigger. My results return beautiful matrix report. My format trigger on the matrix repeating frame tells the report to return false on the column if there is no result in the current row. But what I want is that if all the rows returned is null for a specific column then hide that specific column. but what happens is that the entire column is hidden if the first row is null for that column even if the subsequent columns are not null. HELP!
My system configuration:
Oracle 7.3
Oracle Reports 2.5
Thanks in advance
Sal