Firstly, I am using the version of Oracle Apex 5.1.2 and Apex 18c i need to create department wise employee line chart dynamically.Like that....
Here i create a classic report for department. And then i create four region for line chart every line chart query are static where condition.But in need to create a dynamic line chart where a department has an employee line chart.is it possible?
Help me.....
Here is my department query
SELECT DNAME FROM DEPT
and is line chart query
SELECT ENAME,SAL FROM EMP WHERE DEPTNO = 10
SELECT ENAME,SAL FROM EMP WHERE DEPTNO = 20
SELECT ENAME,SAL FROM EMP WHERE DEPTNO = 30
SELECT ENAME,SAL FROM EMP WHERE DEPTNO = 40