This discussion is archived
1 5 6 7 8 9 10 Previous Next 146 Replies Latest reply: Dec 2, 2009 10:18 PM by user786836 Go to original post RSS
  • 90. Re: Export Excel instead of .csv
    676122 Newbie
    Currently Being Moderated
    Well I am also trying the same SQL query. I downloaded it and executed but it then opens up a popup window which asks me values for Bind Variables. some of them are :DOCUMENTPROPERTIES, :AUTHOR, :LASTAUTHOR, :CREATED. When I put some dummy value for all these variables then it gives me the error "ORA-00922: missing or invalid option"

    2 questions:
    1. What value should I put for all these variables ( Though I put dummy values)
    2. How to remove this error.

    Any Clues???

    Thnx in Advance.
    Amit Arora
  • 91. Re: Export Excel instead of .csv
    688570 Newbie
    Currently Being Moderated
    Excellent work Denes on the package, it has help us all!

    I am not sure if this question was answered yet, I have been going through all of the responses in this thread, and didn't find a distinct answer.

    The question is, is there a way to have the numeric values as numeric in excel and not as text?

    It seems when I am download the excel file all of the cell values are formatted as text, when I would like them to be numeric.

    I also noticed that happening when I download your excel file from your site. The numbers are stored as text.

    Thanks!

    Edited by: user8000793 on Mar 2, 2009 7:49 AM
  • 92. Re: Export Excel instead of .csv
    630728 Newbie
    Currently Being Moderated
    Hello,
    Its possible same things in html means Export html file insted of excel file,if yes then give me details of this.
    Thanks in advance.

    Edited by: user627725 on Apr 23, 2009 5:06 AM
  • 93. Re: Export Excel instead of .csv
    698667 Newbie
    Currently Being Moderated
    Deleted

    Edited by: user11111878 on May 1, 2009 9:31 AM
  • 94. Re: Export Excel instead of .csv
    704127 Newbie
    Currently Being Moderated
    Edited by: user11111878 on May 1, 2009 9:31 AM
    hello , when am downloading, in excel file i got error.

    user11111878 wrote:Report Values Error: ORA-06550: line 1, column 165: PL/SQL: ORA-00936: missing expression ORA-06550: line 1, column 157: PL/SQL: SQL Statement ignored / -6550 / select from (SELECT "OEHR_ORDERS"."ORDER_ID" "ORDER_ID", "OEHR_ORDERS"."ORDER_DATE" "ORDER_DATE", "OEHR_ORDERS"."ORDER_MODE" "ORDER_MODE", "OEHR_ORDERS"."CUSTOMER_ID" "CUSTOMER_ID", "OEHR_ORDERS"."ORDER_STATUS" "ORDER_STATUS", "OEHR_ORDERS"."ORDER_TOTAL" "ORDER_TOTAL", "OEHR_ORDERS"."SALES_REP_ID" "SALES_REP_ID", "OEHR_ORDERS"."PROMOTION_ID" "PROMOTION_ID" FROM "OEHR_ORDERS" )
    Edited by: user11146125 on May 29, 2009 1:56 AM
  • 95. Re: Export Excel instead of .csv
    Denes Kubicek Oracle ACE Director
    Currently Being Moderated
    If I read the error message I see

    select from (select ...)

    This is not a correct SQL statement.

    Why don't you try with this (removed the alias column names generated automatically):
    SELECT order_id, order_date, order_mode, customer_id, order_status,
           order_total, sales_rep_id, promotion_id
      FROM oehr_orders
    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.opal-consulting.de/training
    http://apex.oracle.com/pls/otn/f?p=31517:1
    -------------------------------------------------------------------
  • 96. Re: Export Excel instead of .csv
    704127 Newbie
    Currently Being Moderated
    still same problem :(

    Report Values Error: ORA-06550: line 1, column 163: PL/SQL: ORA-00936: missing expression ORA-06550: line 1, column 155: PL/SQL: SQL Statement ignored / -6550 / select from (SELECT order_id, order_date, order_mode, customer_id, order_status, order_total, sales_rep_id, promotion_id FROM oehr_orders)

    this error is displayed in excel file :(
  • 97. Re: Export Excel instead of .csv
    Denes Kubicek Oracle ACE Director
    Currently Being Moderated
    I can't say much about this error. Looks like the report can't be located so it doesn't get the columns from your report - this is why it says "select from (...)". Go through the "how to" document and make sure there are not things you left out. Especially the application item naming.

    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.opal-consulting.de/training
    http://apex.oracle.com/pls/otn/f?p=31517:1
    -------------------------------------------------------------------
  • 98. Re: Export Excel instead of .csv
    PedroMendez Newbie
    Currently Being Moderated
    Hi Denes,

    Thank you very much for your package it works a charm, good job.
    I tested too your package - "export_xml_pkg", Export to XML. I works fine too (of course). I'm trying to use this package with Interactive Reports but with no success. Is it possible to alter your package to allow this or already exists a package for XML export of an Interactive Report?

    Regards Pedro.
  • 99. Re: Export Excel instead of .csv
    Denes Kubicek Oracle ACE Director
    Currently Being Moderated
    Pedro,

    I don't have anything for the interactive reports. However, you may try to modify it.

    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.opal-consulting.de/training
    http://apex.oracle.com/pls/otn/f?p=31517:1
    -------------------------------------------------------------------
  • 100. Re: Export Excel instead of .csv
    PedroMendez Newbie
    Currently Being Moderated
    Thank you Denes for your fast reply,

    do you think it's feasible to change your package for Interactive Report exports to XML??

    Regards Pedro.
  • 101. Re: Export Excel instead of .csv
    Denes Kubicek Oracle ACE Director
    Currently Being Moderated
    Pedro,

    I simply don't know :)

    Denes Kubicek
    -------------------------------------------------------------------
    http://deneskubicek.blogspot.com/
    http://www.opal-consulting.de/training
    http://apex.oracle.com/pls/otn/f?p=31517:1
    -------------------------------------------------------------------
  • 102. Re: Export Excel instead of .csv
    704127 Newbie
    Currently Being Moderated
    Denes Kubicek

    hello, I'm filtering my table by date, i have code like this:

    -------------------------------------------------------------------------------------------------------------
    select * from vizit_full

    where REG_DATE BETWEEN :P1_DATEPICKER
    AND :P1_DATEPICKER2
    -------------------------------------------------------------------------------------------------------------



    without "where - AND" it works , but when i'm using where excel gives me error , here it is:



    -------------------------------------------------------------------------------------------------------------
    Report Values Error: ORA-06550: line 1, column 329: PL/SQL: ORA-00907: missing right parenthesis ORA-06550: line 1, column 157: PL/SQL: SQL Statement ignored / -6550 / select ID,REG_DATE,GVARI,SAXELI,MASPINZELI,PERSON_ID,MISAMARTI,OTHER_PERS,BEGIN_DATE,END_DATE,STATUS,VIZKAR_N,TANAMDEBOBA_ID from ((SELECT v('P1_DATEPICKER2') FROM DUAL)om vizit_full where REG_DATE BETWEEN (SELECT v('P1_DATEPICKER') FROM DUAL) AND (SELECT v('P1_DATEPICKER') FROM DUAL)2 )
    -------------------------------------------------------------------------------------------------------------
    can u help me plz :(((
  • 103. Re: Export Excel instead of .csv
    627206 Explorer
    Currently Being Moderated
    Hi Regent1904 ,

    Try this instead of "between"
    or check the date format date_items choose "Date Picker (DD-MM-YYYY)" it should work ..

    select * from vizit_full
    where
    REG_DATE >= :P1_DATEPICKER
    AND
    REG_DATE <= :P1_DATEPICKER2

    Regards,
    Benz
  • 104. Re: Export Excel instead of .csv
    704127 Newbie
    Currently Being Moderated
    oh it doesn't work :(
    \

    thx anyway :))
1 5 6 7 8 9 10 Previous Next