3 Replies Latest reply: Sep 13, 2012 8:39 AM by Hari_639 RSS

    Export Report to Excel, CSV or Email

    Comet
      I created an APEX 4.1.1.00.23 application with a few pages which contain an interactive report. The reports worked fine but the user wants the report changed to a classic report with search parameters in another region to control the display of report results. I created the new report but now the CSV export and email features from the Actions button on the interactive report are unavailable. The Print and Export function on the browser tool bar only allow printing /export of the current page rather the entire data set which can go on for several pages plus the formatting is way off. Is there a page item available I can add to the page to allow the user to export to Excel, CSV or email the report?
        • 1. Re: Export Report to Excel, CSV or Email
          BillArms_GS
          This is what was in debug view
          0.06200     0.00000     ...Execute Statement: begin begin insert into "PDOCMDOCS"."FILE_FUNCT_VIEW" ( "NAME","DESCRIPTION","GLOBALS","MULTIPLE_IN_TYPES","MULTIPLE_OUT_TYPES","SIDE_EFFECTS_NUM","SUB_FUNCTION_NUM","IDENTIFIER","PERL_CODE","PLSQL_CODE") values (:DML_BV0001,:DML_BV0002,:DML_BV0003,:DML_BV0004,:DML_BV0005,:DML_BV0006,:DML_BV0007,:DML_BV0008,:DML_BV0009,:DML_BV0010) returning rowid into wwv_flow.g_dml_rowid; end; end;     4     
          0
               0.06200     0.01600     ...Execute Statement: begin begin insert into "PDOCMDOCS"."FILE_FUNCT_VIEW" ( "NAME","DESCRIPTION","GLOBALS","MULTIPLE_IN_TYPES","MULTIPLE_OUT_TYPES","SIDE_EFFECTS_NUM","SUB_FUNCTION_NUM","IDENTIFIER","PERL_CODE","PLSQL_CODE") values (:DML_BV0001,:DML_BV0002,:DML_BV0003,:DML_BV0004,:DML_BV0005,:DML_BV0006,:DML_BV0007,:DML_BV0008,:DML_BV0009,:DML_BV0010); end; end;     4     
          34
               0.07800     0.01500     Add error onto error stack     4     
          32
               0.09300     0.00000     ...Error data:     4     
          0
               0.09300     0.00000     ......message: ORA-01400: cannot insert NULL into ("PDOCMDOCS"."PERL_FILE_FUNCT_ASSOC"."FILE_ID") ORA-06512: at "PDOCMDOCS.FILE_FUNC_VIEW_FULL_TGR", line 53 ORA-04088: error during execution of trigger 'PDOCMDOCS.FILE_FUNC_VIEW_FULL_TGR' ORA-06512: at "SYS.WWV_DBMS_SQL", line 992 ORA-06512: at "APEX_040100.WWV_FLOW_DYNAMIC_EXEC", line 649 ORA-06512: at "APEX_040100.WWV_FLOW_DML", line 1309 ORA-22816: unsupported feature with RETURNING clause     4     
          0
               0.09300     0.00000     ......additional_info: ORA-01400: cannot insert NULL into ("PDOCMDOCS"."PERL_FILE_FUNCT_ASSOC"."FILE_ID") ORA-06512: at "PDOCMDOCS.FILE_FUNC_VIEW_FULL_TGR", line 53 ORA-04088: error during execution of trigger 'PDOCMDOCS.FILE_FUNC_VIEW_FULL_TGR' ORA-06512: at "SYS.WWV_DBMS_SQL", line 992 ORA-06512: at "APEX_040100.WWV_FLOW_DYNAMIC_EXEC", line 649 ORA-06512: at "APEX_040100.WWV_FLOW_DML", line 1309 ORA-22816: unsupported feature with RETURNING clause     4     
          0
               0.09300     0.00000     ......display_location: INLINE_IN_NOTIFICATION     4     
          0
               0.09300     0.00000     ......is_internal_error: false     4     
          0
               0.09300     0.00000     ......ora_sqlcode: -1400     4     
          0
               0.09300     0.00000     ......ora_sqlerrm: ORA-01400: cannot insert NULL into ("PDOCMDOCS"."PERL_FILE_FUNCT_ASSOC"."FILE_ID") ORA-06512: at "PDOCMDOCS.FILE_FUNC_VIEW_FULL_TGR", line 53 ORA-04088: error during execution of trigger 'PDOCMDOCS.FILE_FUNC_VIEW_FULL_TGR' ORA-06512: at "SYS.WWV_DBMS_SQL", line 992 ORA-06512: at "APEX_040100.WWV_FLOW_DYNAMIC_EXEC", line 649 ORA-06512: at "APEX_040100.WWV_FLOW_DML", line 1309 ORA-22816: unsupported feature with RETURNING clause     4     
          0
               0.09300     0.00000     ......error_backtrace: ORA-06512: at "PDOCMDOCS.FILE_FUNC_VIEW_FULL_TGR", line 53 ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1926 ORA-06512: at "SYS.WWV_DBMS_SQL", line 966 ORA-06512: at "PDOCMDOCS.FILE_FUNC_VIEW_FULL_TGR", line 53 ORA-06512: at "SYS.WWV_DBMS_SQL", line 992 ORA-06512: at "APEX_040100.WWV_FLOW_DYNAMIC_EXEC", line 649 ORA-06512: at "APEX_040100.WWV_FLOW_DML", line 1309 ORA-06512: at "APEX_040100.WWV_FLOW_DML", line 1515 ORA-06512: at "APEX_040100.WWV_FLOW_PROCESS", line 354      4     
          0
          Perhaps I was mis-reading the error messages.

          Regards,
          Bill
          • 2. Re: Export Report to Excel, CSV or Email
            BillArms_GS
            SORRY wrong thread
            • 3. Re: Export Report to Excel, CSV or Email
              Hari_639
              Hello,

              For CSV export,
              Classic Report -> Report Attributes -> Report Export
              Set "Enable CSV output" to YES. So users can download report data into CSV.
              email the report
              You may have to build it manually.

              Regards,
              Hari