I have a Summary report with Graph Chart included.
That reports perfectly show data according to User ID hierarchy.
When we are using Dashboard Report as Vertical / Horizontal, it works fine
but when we use Dashboard Report as Custom then Hierarchy lost and showing all users data.
Please advise ?
I have checked the SQL, it is ok in Dashboard Report and the Original Report.
Actually, if we show Graph and List both on Dashboard, then List loads according to User ID Hierarchy,
but graph ignores the User ID Hierarchy
sql: SELECT employees.employees_user_id, employees.employees_user_name, employees.employees_user_password, employees.employees_user_level, employees.employees_complete_name, employees.employees_mobile_number, employees.employees_email, employees.employees_activated, employees.employees_profile, employees.employees_reports_to, employees.employees_photo, employees.desig_id, employees.dept_id, employees.job_stastus, employees.employees_hire_date, employees.gross_salary, employees.leaves_sick_allowed, employees.leaves_sick_availed, employees.leaves_casual_allowed, employees.leaves_casual_availed, employees.job_nature, employees.kpi_calls, employees.kpi_meetings, employees.bank_accountno, employees.leaves_casual_balance, employees.leaves_sick_balance FROM employees WHERE (employees.employees_user_id = 17) OR (employees.employees_user_id IN (SELECT employees.employees_user_id FROM employees WHERE employees.employees_reports_to = 17)), executionMS: 0.0029709339141846
sql: SELECT employees.employees_user_id, employees.employees_user_name, employees.employees_user_password, employees.employees_user_level, employees.employees_complete_name, employees.employees_mobile_number, employees.employees_email, employees.employees_activated, employees.employees_profile, employees.employees_reports_to, employees.employees_photo, employees.desig_id, employees.dept_id, employees.job_stastus, employees.employees_hire_date, employees.gross_salary, employees.leaves_sick_allowed, employees.leaves_sick_availed, employees.leaves_casual_allowed, employees.leaves_casual_availed, employees.job_nature, employees.kpi_calls, employees.kpi_meetings, employees.bank_accountno, employees.leaves_casual_balance, employees.leaves_sick_balance FROM employees WHERE employees.employees_reports_to IN (17, 65, 14, 42, 26, 64, 74, 82, 86, 87, 95), executionMS: 0.00083279609680176
Please update to the latest template (Tools -> Update Template) and try again.
Thanks. It works now.
Can template also update for Version 2022 ?
Any advise on this issue ?
I suggest you to contact Support. I have the best experience each time I contact them. Excellent support, as always.