This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 31st, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,899 Users
  • 2,269,649 Discussions


APEX Email Custom PDF Report

Baonerges Member Posts: 115 Blue Ribbon
edited Mar 11, 2020 10:03PM in APEX Discussions

Hi Everyone,

We are working on an invoicing application which can take a reports and email it as a PDF. Currently we run a crystal report which generates the invoice, then we save as a PDF and email it.

I have been trying to figure out how to create a custom report format which matches my invoice format and can be emailed as a PDF from my APEX application. Currently I am playing around with APEX Office Print (AOP) to see if this will do what I need. Its somewhat expensive though with the volume.

The following link discusses how to integrate with Crystal but it needs a Crystal Server. I am willing to redevelop my report in any format as long as I can customize the formatting and location of data on the page. I don't want the APEX downloadable report which spits out a table.

How to generate a PDF report from APEX using Crystal Reports

Is there a simpler way for me to use built in APEX functionality to generate a custom PDF and then send it with an email?

Any guidance would be appreciated.


Best Answer

  • Scott Wesley
    Scott Wesley Systems Consultant & Trainer Perth, AustraliaMember Posts: 6,272 Gold Crown
    edited Mar 11, 2020 11:03AM Answer ✓

    If you have high volumes, you can always go on-premise. Either way, it's far cheaper than enterprise scale BI Publisher or Jasper. And AOP is the most tightly coupled to APEX.

    Lino has a great comparison of options here

    If your reports are relatively basic, just printing lots of them, you might consider one of the PL/SQL options - it just requires more time to build.

    Everything's a trade-off.