I liked the technique of using the parameter in the connection string.
Didn't think that was possible,
Just a couple of small problems though:
1) Your creation script does not match the xml sample report:
CREATE TABLE [dbo].[ServerList]
( [ServerName] [nchar](50) NULL )
2) Reporting Services doesn't like extensions of XML for reports,
It prefers RDL.
Rename the example file to RDL and it will be easier to integrate.
Thank you for including the sample files!
Really made life easier!
A+, ITIL, MCAD, MCDBA, MCITP: Sql Server 2005 Adminstration, MCT,
MCTS: Sql Server 2005, MCP, MCSA, MCSE, MOUS, PMP
President and Founder S3oLV.Com: Sql Server Society of Las Vegas
President and Founder LVXUG.Com: Las Vegas XNA Users Group