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
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 @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
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.