Complex Organizational Charts

Can you recommend software for preparing complex organizational charts that can be generated from a database of employee information? I need to develop about 30 pages of charts for a department of 1500 people that show:

1) organizational relationships

2) number of employees by job title category reporting to each manager, and the total for that manager

3) funding classification — indicate for employees in each title category how many are funded as Operating, how many are Capital, and the total

4) summary info — at the bottom of each page, subtotal the number of employees by occupational group and funding classification

I have used Excel for this in the past, but that cannot be the best solution. I need s/w that supports simple arithmetic funtions and numberical displays in addition to the typical organizational design. It would be ideal if the charts could be automatically generated from an employee database, with the data on the lower level charts automatically rolling up to the data on the higher level charts.