Brian Knight et al., "Professional SQL Server 2005 Integration Services"

If you are using visual studio 2005, try integration services.

You might find a solution in "Microsoft SQL Server 2005 Reporting Services Step by Step" by Stacia Misner.

Could you tell me, what did you select in Report Parameters window?...

there is a data flow pivot transformation in ssis:

http://msdn2.microsoft.com/en-us/library/ms140308.aspx

ListAvailableSQLServers method is to be deprecated:

http://msdn2.microsoft.com/en-us/library/ms140744.aspx

PercentComplete event is to be abandoned:

http://msdn2.microsoft.com/en-us/library/ms135685.aspx

About files and filegroups, also here:

http://msdn2.microsoft.com/en-us/library/ms189563.aspx

ssrs 2005 is not limited to one column sort.

http://msdn2.microsoft.com/en-us/library/ms144275.aspx

about Editions and Components of SQL Server 2005 (Updated: 14 April 2006)

In SQL Server 2005, the restriction is kept in place:

"Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table."

http://msdn2.microsoft.com/en-us/library/ms180800.aspx

From Designing DDL Triggers

http://msdn2.microsoft.com/en-us/library/ms186406.aspx

Server-scoped DDL triggers are stored as objects in the master database. However, information about server-scoped DDL triggers can be obtained from the sys.server_triggers catalog view...

nice improvement of the interface.

http://www.microsoft.com/sql/editions/enterprise/comparison.mspx

In this "Comparison Between SQL Server 2005 Standard and Enterprise Editions", it is stated a limitation to 64 of the number of CPUs.

If the current solution doesn't have e-mail subscriptions, the users might be delighted to have some Reporting Services.