This discussion is archived
3 Replies Latest reply: Mar 14, 2012 7:43 AM by user120006 RSS

Apex 4.1 Print IR Report to PDF

user120006 Newbie
Currently Being Moderated
I wanted to see if I have it correct on Apex and getting data out in either printed form or to Excel.

Unlike previous dev tools like Discoverer which would make printing things out to PDF and paper almost an exact duplicate of what was done on the screen report,
Apex chose another route and making it harder to get things out.

Now if you have $150,000 laying around you can purchase BI-Publisher and get "Nicer" output that of which I have only seen in a demo.

What about those of us that don't have 150K to spend?

I have my FOP server up and running but this give the most basic output available.

So Far I see no way to get Break Groups, total amounts or anything even remotely approaching charts out using FOP.

Do I have this correct. I just want to make sure.

I wanted to use one tool to do my development from the Data Warehouse, and was led to believe that Apex was it.

What are the "Real" solutions in getting better formatted output to a printed page. Is there anything that can take the rendering on the page and print it out, or down load it for Excel and/or other output.

I am going to have to now go back to my supervisor and say I am going to have to code in discoverer as well as Apex to get viable printed output on our project thereby increasing my time and footprint and tools the user must use.

I am not getting a warm fuzzy feeling about this.

I know that I am going to have to open an SR to get a response on this from anyone even remotely connected to oracle, but I wanted to get some other thoughts out there, and see if I am missing something easy in the way of getting output and leveraging my work in apex to the printed page in anything that resembles what you see on the screen in apex.

Any help or advise is appreciated.
greG
  • 1. Re: Apex 4.1 Print IR Report to PDF
    scott.wesley Guru
    Currently Being Moderated
    Sorry mate, Apex doesn't score well when it comes to generating reports out of the box - however it does integrate with other options.

    BI Publisher - I thought the figure was more like $50k, but I guess it depends on your currency.

    Configuration details direct from Oracle
    http://www.oracle.com/technetwork/developer-tools/apex/application-express/configure-printing-093060.html
    Setting up reports
    http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/apex/r31/apex31nf/apex31rpt.htm

    You can set up Cocoon using Carl's viewlet
    http://carlback.blogspot.com/2007/03/apex-cocoon-pdf-and-more.html

    If you want to use Cocoon or Apache FOP and you don't have a skilled XSL developer, you can spend a small amount cash for this WYSIWYG editor
    http://www.java4less.com/fopdesigner/fodesigner.php

    There are some PL/SQL alternatives
    http://ora-00001.blogspot.com/2011/02/working-with-office-2007-ooxml-files.html
    http://monkeyonoracle.blogspot.com/2009/07/dynamic-rtf-documents-revisited.html

    A popular option that I haven't explored is Jasper
    http://jasperforge.org/index.php?q=project/ireport
    Dietmar Aust loves it
    http://daust.blogspot.com.au/2009/06/odtug2009-pdf-printing.html

    It is also possible to link into Oracle Reports - quite easily actually - but I don't have that link with me.

    Scott
  • 2. Re: Apex 4.1 Print IR Report to PDF
    user120006 Newbie
    Currently Being Moderated
    Thanks Scott,
    I was wrong ;-)
    I will look into those options today.
    Much Appreciated.
    greG
  • 3. Re: Apex 4.1 Print IR Report to PDF
    user120006 Newbie
    Currently Being Moderated
    Thanks so much for all the info. I think the info on Jasper looks like a "Real" option for us. With the amount of detail in the posts and other info already on OTN, We are going forward in this direction.
    THanks much.
    greG

Legend

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