I have a repeating group-based on a select statement with a outer join. This is so it always displays a default value. I have linked a repeating frame to the group but when the group returns rows where the default values occur nothing is displayed in the frame.
The sql for the repeating groupis something close to this since am away from my machine.
select nvl(a.fp_amt,0), b.allw_code
from emp_allowance a, std_allowances b
where b.std_key = '1'
and a.allw_code (+) = b.std_allw_code
;
Its a payroll query,where by not all employees earn std allowance thus the need for an outer join. It returns the allowance values if present.
emp_allowance table
-------------------
emp_code
allw_code
std_allowances table
--------------
std_key
std_allw_code
The sql for the repeating groupis something close to this since am away from my machine.
select nvl(a.fp_amt,0), b.allw_code
from emp_allowance a, std_allowances b
where b.std_key = '1'
and a.allw_code (+) = b.std_allw_code
;
Its a payroll query,where by not all employees earn std allowance thus the need for an outer join. It returns the allowance values if present.
emp_allowance table
-------------------
emp_code
allw_code
std_allowances table
--------------
std_key
std_allw_code