Good news for the chap I met on the 'Ask the Experts' desk at TechEd, who was contemplating jumping through all sorts of hurdles to create reports form Sharepoint data. I couldn't really get my head round the (Sharepoint) problems he foresaw, but I was able to tell him that a report pack was in the pipeline to do just what he wanted, without any agro. So here it is, along with a report pack for Axapta (about which I know almost nothing).
Overview of the Report Pack for Microsoft Office SharePoint Portal Server 2003
The Microsoft SQL Server Report Pack for Microsoft Office SharePoint Portal Server 2003 is a set of 8 Microsoft SQL Server 2000 Reporting Services reports that work with a sample database of information extracted from a SharePoint Portal Server environment. This database can be populated from your own SharePoint Portal Server environment using the downloadable Data Extraction Program (DEP). The DEP will read the SharePoint Portal Server data via the object model. You also can use the sample reports as templates for designing new reports. This Report Pack includes the following reports: Storage Report, Storage Trend Report, Site Trend Report, Comprehensive Site Collections Report, Detailed Site Collection Report, Detailed Page Report, Best Bet Keyword, Search Terms.
You can download it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=49159368-544B-4B09-8EED-4844B4E33D3D&displaylang=en
Overview of the Microsoft SQL Server Report Pack for Microsoft Axapta 3.0. This is a set of 8 predefined report definition files that work with a sample database from Microsoft Axapta. You can use the sample reports as templates for designing new reports.
This Report Pack includes the following reports: CRM Recap, Customer Order Delivery Performance, Open Production Orders, Open Sales Orders, Purchase Order Planning, Rolling Invoice, Sub Report - Inventory On Hand, Sub Report - Open Purchase Order Detail.
You can download it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=81592B13-7960-4EF3-9D3C-B10FD325390F&displaylang=en