In apex 5.1, on a modal page, I made an interactive report, formatted to look like this
On that image, I have hidden, AS AN USER, some columns, and I cannot restore it to the original format (showing all columns).
The report query is
ORDER BY IMAGE_NAME
Where the ID is a "hidden column", and CONTENT is a BLOB image.
the problem is that I want to completely reset the report to his original state at the modal page load, where the images column should be visible.
to do that, I added a dynamic action which triggers at the modal page load, and has this SQL code:
SELECT region_id INTO v_region_id
WHERE application_id = :APP_ID
AND page_id = :APP_PAGE_ID
AND static_id = 'Interactive_List_of_Employees'; -- Static ID of your IR
P_page_id => :APP_PAGE_ID,
P_region_id => v_region_id,
p_report_id => Null
It seems to reset the "Image Name" column on the report, but fails to display the images column. It should reset to this state
How can I programatically reset the report to his original state?