Organisation hierarchy - how to view all in one report?
We are trying to clean up and re-organise some of our data (the downside of a data import process) and i would like to see one report where I can establish the 'head office' or 'parent' organisation and any child organisations under it.
When i've looked at some of the existing reports it shows every org ID for every site address and it's not clear which is the parent. I've also tried using versions of orgs.lvl1 etc but can't get anything to work. I tried to use Organisation Hierarchy in a report but the org_id remains the same throughout - is there any way to show the different org IDs for each level, e.g: Level 1 - org ID 1234 > Level 2 - org ID 567 etc