2 Replies Latest reply: Apr 19, 2014 4:45 AM by Bhramar RSS

    Set Column Width to 0 while Printing to PDF

    Bhramar

      Oracle Application Express Version : 4.2.0.00.27 

       

      Apex Listener Version : 2.0

       

      We have a classic report with 20 columns. Out of them, few are conditional.

       

      We are using Print Attributes to print the report to PDF. The problem with the PDF thus printed is, it keeps the column width of all the columns in the PDF even if they are hidden. We have set the column width for all 20 columns in Print Attributes section.

       

      Can we set the column width to 0 in the PDF output for the columns which got hidden due to the condition?

        • 1. Re: Set Column Width to 0 while Printing to PDF
          Marc Sewtz-Oracle

          Hi - so what is it that you are trying to accomplish? The conditional columns are not included in the PDF. And the column width for the PDF is defined in percentage of the available space. So I assume what you need is for the remaining columns, i.e. those that are included, to fill up the available space, however they don't because even though the conditional columns are not shown, they still use up space. Unfortunately there is currently no way to conditionally set the column width, or update the column width based on conditions. You could try your own custom report layout, or use the print APIs for export, and conditionally use different report layouts.

           

          I'll take a note though to see if we can improve the logic using the built-in report layouts to be a bit smarter about use of space when columns are conditionally excluded.

           

          Regards,
          Marc

          • 2. Re: Set Column Width to 0 while Printing to PDF
            Bhramar

            Thanks for your response.

             

            I guess we have to find some other way to achieve this like you said then.