Challenge #12: Creating an HR Hierarchy

[kbwissi]

This one was more difficult for me. Although I understand the logic behind it, I have never created a macro, or iterative macro before. This was very helpful!

[JustinBabbitt]

Thanks!

[Caveman88]

Spoiler

Solved!

[MarMu]

Very nice challenge. Definitely a tough nut to crack and had to read up on iterative macros. My first practical application of this highly specialized macros type.

well done.

Spoiler

[kat]

Spoiler

Always need to think twice when it come to iterative macros! Looking at the solution that union was unnecessary, but somehow mine wasn't working before - probably where I placed my hierarchy formula.

[tammybrown_tds]

Full disclosure....I had to look at others' solutions to get this macro to work right.  So I used it as a self-learning exercise.  The next macro challenge, I will try to do on my own!

[mceleavey]

Wow, that hurt my brain.

I definitely need to brush up more on iterative macros as I struggled with this one (keep forgetting about the interface designer).

Spoiler

I eventually got there:



Basically, I split the data into two streams, which essentially joins the element to it's parent, with the iteration allowing for multiple levels, rather than creating a join in a join in a join and so on, as I would have had to do back in my Crystal Reports days (*shudder...flashbacks...breathe...*).

The iteration is the nice bit (once you REMEMBER TO DO THE SETTINGS IN THE INTERFACE DESIGNER WINDOW)

I then simply embedded the macro, sorted the records on the output and Robert's your father's brother.

M.

[OllieClarke]

this one took a bit of trial and error. I need to practice my iterative macros....

Spoiler

[danilang]

Another challenge that involved lots of trial and error.  It once only once I realised that CEO was not in the output list that I came up with a solution

Spoiler

The solution involved returning all the lower employees at each iterations as opposed to returning the topmost one.

Dan