2 Replies Latest reply on Sep 11, 2017 5:42 AM by user12138829

    Bar Chart Report in html

    user12138829

      SQL Developer v.4.2

      Bar Chart Report in "html" get error in "report.js", running from SQL Developer works fine.

       

       

       

      Any ideas ?

       

      Regards

      PGutierrez

        • 1. Re: Bar Chart Report in html
          thatJeffSmith-Oracle

          Sorry, you need to show us what you're doing. Where's your query or report properties, or even your report working in SQL Developer?

           

          chart-salary.png

           

          Query:

          select sum(salary), department_id from employees

          group by department_id

          order by sum(salary) asc

           

          Style: Chart

          Chart Type: Bar Vertical Cluster

          • 2. Re: Bar Chart Report in html
            user12138829

            Hi Oracle,

             

            Yes, the report works fine from sqldeveloper

             

            Query:

            /*

            CREATE TABLE ESP_DD_DISCO_HISTORY (

              FECHA          DATE          NOT NULL

            , TBS_NAME       VARCHAR2(30)  NOT NULL

            , OCUPADO_MB     NUMBER        NOT NULL

            , USADO_MB       NUMBER        NOT NULL

            )

            ;

            ALTER TABLE ESP_DD_DISCO_HISTORY ADD CONSTRAINT ESP_DD_DISCO_HISTORY_PK PRIMARY KEY (FECHA, TBS_NAME)

            USING INDEX TABLESPACE TS_CAUDAL_IND

            ;

            ALTER TABLE ESP_DD_DISCO_HISTORY ADD CONSTRAINT ESP_DD_DISCO_HISTORY_CHK01 CHECK ( FECHA = TRUNC(FECHA) )

            ;

            */

            SELECT FECHA, TBS_NAME, OCUPADO_MB FROM (

            SELECT H.FECHA                 FECHA

                 , H.TBS_NAME              TBS_NAME

                 , ROUND(H.OCUPADO_MB, 2)  OCUPADO_MB

              FROM ESP_DD_DISCO_HISTORY H

            WHERE TRIM(TO_CHAR(H.FECHA, 'DD'))  IN ('01', '02')

            ORDER BY H.FECHA DESC, H.TBS_NAME

            )

            ORDER BY FECHA, TBS_NAME

             

            Style: Graph

            Type: Bar: Vertical Stacked

             

            Regards

            PGutiérrez