4 Replies Latest reply: Apr 5, 2013 2:52 PM by Marc Sewtz-Oracle RSS

    PDF standard report attributes - change margins?

    804111
      We just installed the standard PDF reporting with Apache FOP and the apex_fop.jsp script. I am able to set a variety of Report Attributes and download the PDF reports (both interactive and standard report pages).

      It appears that there is no setting for margin, and also if I change landscape letter to landscape legal, the report content is still sized for letter, with the extra 3 inches on the right blank.

      Is there any way to adjust the margins? It looks like the default setting is 1" top, bottom, left, right and that eats up a lot of real estate on the page.

      I would want to (a) find out how to set it per report, or (b) adjust the default.

      I have no clue about how Apex invokes the PDF engine or where the settings are stored.

      We're running in a hosted environment and I don't have ready access to the pieces outside of Apex and the Oracle DB.

      Thanks for any pointers or solutions.

      Skip
        • 1. Re: PDF standard report attributes - change margins?
          804111
          Trying again.

          Anyone understand the basics of adjusting the main parameters of the standard template?
          • 2. Re: PDF standard report attributes - change margins?
            Marc Sewtz-Oracle
            Hi Skip,

            There are two ways to format your PDF - using the built-in generic layout, along with the formatting options available on the print attributes or using custom XSL-FO report layouts. The generic layout option does not provide a way to adjust the margins, so you would need to use a custom layout. The easiest way to do this would be to create a Generic Columns (XSL-FO) layout (See Shared Components -> Report Layouts). This type of layout matches the built-in generic layout, but allows you to manually customize anything you like, while still keeping the substitution strings in place for the attributes exposed on the print attributes page. You can use this technique for Classic Reports and Report Queries. For Interactive Reports though, we currently only support the built-in generic layout.

            Regards,
            Marc
            • 3. Re: PDF standard report attributes - change margins?
              804111
              Marc,

              Thanks. That was enough to get me to the template. Changing some of the obvious parameters, I was able to get the idea. Next steps will be to find a formal syntax guide (any pointers?) and then see about customizing for individual reports.

              The customer-oriented problem is the inability to do this with Interactive Reports. IRs are what users like. They can't get from their tailored IR reports on screen to PDF output, including control breaks, highlights, etc., which is what they are used to and which creates a permanent record. (I work with auditors.) And they don't want to license BI Publisher.

              Setting margins is a tactical step, and you have helped. Can you also point me in the direction of a solution to the strategic goal, to get PDF output of what we see on IR pages?

              Skip
              • 4. Re: PDF standard report attributes - change margins?
                Marc Sewtz-Oracle
                Skip,

                For the template customization, any documentation on XSL-FO should help with some of the basics, like for example:

                http://www.w3schools.com/xslfo/

                Regarding the Interactive Reports requirement, we're aware that many customers are looking to have PDFs generated from IRRs that reflect their customizations and formatting choices, including break columns, and a looking into addressing this in APEX 5.0. Until then, your best option might be to create a separate Report Query (using the same query as your IRR), and create a custom XSL-FO Report Layout for that. And then add a PDF Export button to your IRR page that calls that Report Query. This would still not reflect 100% all the customizations a user might have done to the IRR, but at least you would have more control over the output.

                Regards,
                Marc