A] To whether an employee is In-Line Manager or not ?
We have an existing Personnel list BO document.
There are columns Personnel ID as well as Line Manager's Personnel ID;
If for any employee,if Line Manager's ID matches with personnel ID, then we need to provide it by char 'X' in that column
How will I achieve this by adding a new colum to indicate whether the employee is a Line Manager himself/herself?
B] Dynamically Adding Columns based on input contol value
In this existing report, in the current format we have
Org Lvl1 ID | Org Lvl1 Name | Org Lvl2 ID | Org Lvl2 Name | Org Lvl3 ID | Org Lvl3 Name | Soon and so forth until | Lowest Org ID | Lowest Lvl Name and rest columns
Now there is requirement from Business user to have input control on Org Lvl ID which user can enter from 1 to max value of say 20 which are existing in current Productiion env.If user chooses 6, then
Dynamically Add columns which would result in below headers
Org Lvl1 ID | Org Lvl1 Name | Org Lvl2 ID | Org Lvl2 Name | Org Lvl3 ID | Org Lvl3 Name | Org Lvl4 ID | Org Lvl4 Name | Org Lvl5 ID | Org Lvl5 Name | Org Lvl6 ID | Org Lvl6 Name and rest columns
If user chooses 12 then,below would be the output of headers
Org Lvl1 ID | Org Lvl1 Name | Org Lvl2 ID | Org Lvl2 Name | Org Lvl3 ID | Org Lvl3 Name | Org Lvl4 ID | Org Lvl4 Name | Org Lvl5 ID | Org Lvl5 Name | Org Lvl6 ID | Org Lvl6 Name | Org Lvl7 ID | Org Lvl7 Name | Org Lvl8 ID | Org Lvl8 Name | Org Lvl9 ID | Org Lvl9 Name | Org Lvl10 ID | Org Lvl10 Name
There are a max of 15 hierarchies present in the current prod system
How to achieve this too ?