Can you upgrade to Blueprint 5.2? This would give you the new data warehouse and the new reports. It is possible that the new reports could help you. If not, you would have the ability to connect your own reporting tools to the data warehouse to slice and dice the data as you wish. Furthermore, we could provide you with a utility for extracting data from the warehouse in CSV format grouped on department within a specified date range.
5.2 also fixes issues with local currency.
I will look into your request for Active Directory scripting.