This content has been marked as final. Show 3 replies
just some ideas :
But maybe you can return the number of column in the query itself ? For example in #COL01# (don't display it).
Then in each other report columns, use a display condition #COL01# != 2, #COL01# != 3, #COL01# != 4, etc.
So the last column of the report will be hidden automatically.
Or another solution is to get your report region source from <font face="courier">apex_application_page_regions</font>, then get the number of columns using DBMS_SQL to be able to use it in the conditions.
as suggested you can use jQuery selector.
In your report set static id to let's say MYTABLE, then in same region in footer section put
The 'tricky' part in Apex is that when you set static id you actually set it for region (which is a defined as a table) and not for table which is actually displaying data. This table is inside the table for which you set up static id. So that's why you have to use "table table" selector.
<script> $('#MYTABLE table table td:last-child').hide(); $('#MYTABLE table table td:last-child,th:last-child').hide(); </script>