Any of this sound familiar to you?
The BizTalk Server 2004 Configuration Management Report Generator supports all of these scenarios and more by saving BizTalk Server configuration information to XML and more importantly making it visible in SQL Server Reporting Services through a custom data extension component. Check out an example report here.
With SQL Reporting Services you get hosted reports, export to a variety of formats such as pdf and excel, and lots of built in design capabilities. Of course every BizTalk Server 2004 requires SQL Server 2000 so you already have access to SQL Reporting Services.
The BizTalk Server 2004 Configuration Management Report Generator is a sample and includes the full-source code to all components. Thanks to Jonathan Moons for his work on this sample. Download it here.