0 Replies Latest reply on Dec 5, 2017 4:05 PM by pawuyulan

    Cannot reset report

    pawuyulan

      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

      select ID,
             IMAGE_NAME,
             DOC_SIZE CONTENT
      from MYIMAGES_TBL
      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:

       

      DECLARE
        v_region_id APEX_APPLICATION_PAGE_REGIONS.REGION_ID%TYPE;
      BEGIN
      
      
        SELECT region_id INTO v_region_id
        FROM APEX_APPLICATION_PAGE_REGIONS
        WHERE application_id = :APP_ID
        AND page_id = :APP_PAGE_ID
        AND static_id = 'Interactive_List_of_Employees'; -- Static ID of your IR
      
      
         APEX_IR.RESET_REPORT(
             P_page_id => :APP_PAGE_ID,
             P_region_id => v_region_id,
             p_report_id => Null
        );
      
      END;
      

       

      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?