Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    121

    Question Unanswered: Outputting an Oracle report 6.0 results to txt file

    Hello,
    I have an Oracle report 6.0 runtime file. I want the user to be able to output the results to a text file.

    I have the parameter form set to the following properties...

    DESTYPE = file
    DESFORMAT = dflt
    DESNAME = c:\test_report.txt
    MODE = character

    I then get the following error...

    REP-1804 - "Unable to open the printer definition file 'dflt' "

    I'm puzzled by this, since the report runs in Report Builder without any problem and can output to txt format. However, the runtime report can't seem to do it.

    Alternatively, changing the MODE = bitmap, is useless because the outputted file is not readable by MS Excel.

    Anyone have any suggestions?
    Last edited by tmalone; 05-17-07 at 10:05.

  2. #2
    Join Date
    Aug 2002
    Posts
    121
    Quote Originally Posted by tmalone
    Hello,
    I have an Oracle report 6.0 runtime file. I want the user to be able to output the results to a text file.

    I have the parameter form set to the following properties...

    DESTYPE = file
    DESFORMAT = dflt
    DESNAME = c:\test_report.txt
    MODE = character

    I then get the following error...

    REP-1804 - "Unable to open the printer definition file 'dflt' "

    I'm puzzled by this, since the report runs in Report Builder without any problem and can output to txt format. However, the runtime report can't seem to do it.

    Alternatively, changing the MODE = bitmap, is useless because the outputted file is not readable by MS Excel.

    Anyone have any suggestions?
    As it turns out, all that was required was the abolute path of the "dflt" file in the DESFORMAT parameter. Grrrg!!

    Oracle dosumentation leads one to believe that the path is defaulted to...

    C:\ORANT\REPORT60\PRINTERS\dflt.prt

    ...However, the entire path has to be in the DESFORMAT parameter for the file to output to text. Otherwise, you get an Oracle REP-1804 error.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •