Ok so here is the deal.  I'm working on a internal metrics dashboard site.  We have a massive hiearchy that changes fairly frequently.

Right now. I have a html/text module pointing to a SSRS Report, and passing a paramater for the ReportsTo based on a Token from the Page Settings Description field.  I am generating the origional base manually as we need to fast track this to get it out.  However I know that they are going to want to only change the main hiearchy generating the metrics into a totals table and not have to adjust the hiearchy in both the buisness layer and the presentation layer.

So, what I am hoping is possible, if I could just get some ideas or links to point me in the right direction. 

Basically, need to generate dynamically a heiarchy of dropdown menu organized tabs under the main tab Executive. 

Ideas?

(I know page template will probably come into this, right now I am just having the module referenced from the main module.)