Tuesday, March 15, 2011

Making an org chart from Exchange, part 2

So what I want to do is, like I said before, is build a report that displays an org chart for my organization.

In order to do this, I'm think I'm going to need to
  • Figure out SSRS - I've done lots of Crystal Report writing in a previous life, so this should be more a matter of learning the UI
  • Find the data lurking somewhere inside of Outlook
  • Write a VBScript extraction routine inside of Outlook to push the data to a database source somewhere
  • Write the report, being cognizant of the org structure of my organization, and how the data is grouped