2 Replies Latest reply on Mar 15, 2019 8:54 AM by fac586

    percent bar graph

    Sgodavar-Oracle

      I'm using APEX 18.2. I need to generate a custom report with pl/sql dynamic content. Apart from other project details in the report,  one of the report cell should display the percentage of completion of  tasks in the project  and in same cell, below that percent bar , needs to show a series of Task ids as clickable links(within that project) with green check mark(complete) and with  red cross mark(not complete). are there any built-in apex item like percent bar, ui items that can called in the pl/sql dynamic content region?. any ideas are appreciated, thanks for your help.

        • 1. Re: percent bar graph
          Billy~Verreynne

          I use a 1 pixel green or red image, and set the image with using the SQL percentage column value, as the report's HTML expression for that column.

           

          E.g. Simplistic example of column's HTML expression:

          <img src="/images/1px_green.png" height="12" alt="#FREE_PERCENTAGE#" width="#FREE_PERCENTAGE#" /><br/>#FREE_PERCENTAGE#%

           

          This then renders as follows in the interactive report:

          free-percentage.png

          • 2. Re: percent bar graph
            fac586

            Sgodavar-Oracle wrote:

             

            I'm using APEX 18.2. I need to generate a custom report with pl/sql dynamic content. Apart from other project details in the report, one of the report cell should display the percentage of completion of tasks in the project and in same cell, below that percent bar , needs to show a series of Task ids as clickable links(within that project) with green check mark(complete) and with red cross mark(not complete). are there any built-in apex item like percent bar, ui items that can called in the pl/sql dynamic content region?. any ideas are appreciated, thanks for your help.

            Why are you using a Pl/SQL Dynamic Content region? There is virtually nothing that can be done in a PL/SQL Dynamic Content region that can't be done more declaratively and efficiently in a report with a custom template, and reports have a Percent Graph column display type.