To develop reports we need BIDS (Business Intelligence Development Studio). It is free and available as part of SQL Server Express editions. The BIDS is available for SQL Server 2005 and SQL Server 2008.
Here is more detail about BIDS
Microsoft SQL Server 2005 Express Edition Toolkit
Microsoft® SQL Server® 2008 Express with Tools