Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2012

    Question Unanswered: Can't generate SPREADSHEET output in Reports

    We are using Reports I want to generate in my (Not deployed in the AS) PC a simple tabular report but in spreadsheet format. I use this command line command in a batch file.

    d:\OracleDevR1\bin\rwrun.exe USERID=user1/user123@db1
    DESNAME=c:\temp\rpt_10gr2_101202_1_excel_output.xl s

    I get this error in the log file

    REP-0826: Invalid printer driver
    'spreadsheet' specified by parameter

    However, I can generate DESFORMAT=HTML, DESFORMAT=PDF output. The HTML and PDF files are created.

    I even installed Excel 2007 but still gives the same error.

  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    DESFORMAT can be case-sensitive, depending on your OS. Have you tried using uppercase?

    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Aug 2012
    Sorry, I have used the release 1 exe. With release 2 (forms) exe this works. BUT, the output is useless. i.e. It's not a 100% match with the PDF output. lots of lines between records and no graphics and it's not useful as an excel sheet.

  4. #4
    Join Date
    Oct 2002
    Cape Town, South Africa
    Hmmmm.... yes... There's an explanation though... Oracle Reports sucks! I am currently battling with Oracle Reports and it's utilisation of fonts (or the lack thereof). Very frustrating component. Actually, Oracle does not do anything UI well.

    If you want nice Excel output from Oracle, then either develop a .NET Stored Procedure (only available on windows) that automates Excel to produce output, or use POI.

    I have been using POI for around two years now with varying degrees of success.

Posting Permissions

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