This discussion is archived
3 Replies Latest reply: Sep 13, 2012 6:39 AM by Hari_639 RSS

Export Report to Excel, CSV or Email

Comet Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    SORRY wrong thread
  • 3. Re: Export Report to Excel, CSV or Email
    Hari_639 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points