Hi @Charith Epitawatta This is my SQL for the report - does this seem ok? select company_id, person_id,emp_no,emp_name, objective_id,objective_description,objective_start_date,objective_end_date,activity_description,activity_start_date,activity_end_date,cost_centrefrom (SELECT a.company_id, (select b.person_id from company_person_all b where a.emp_no = b.emp_no) person_id, a.emp_no, company_pers_api.get_name(a.company_id, a.emp_no) emp_name, a.objective_id, employee_objective_api.get_objective_description(a.company_id, a.emp_no, a.appraisal_year, a.performance_period, a.objective_id) objective_description, employee_objective_api.get_objective_start_date(a.company_id, a.emp_no, a.appraisal_year, a.performance_period, a.objective_id) objective_start_date, employee_objective_api.get_objective_end_date(a.company_id, a.emp_no, a.appraisal_year, a.performance_period, a.objective_id) objective_end_date, a.activity_description, a.activity_start_date, a.activi
Hi @Link The RMB - Output option works. What doesnt work is the RMB - Export to Excel option. When i click ‘ Export to Excel’, excel does open but shows no data whereas in IFS the report shows rows of data
Hi @Link Its the ‘Export to excel’ function when you right click to bring up that option. The Output - Excel/CSV works but for ease of use for the business, the one click of exporting to excel is required
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.