Can those of you who have already been through the .Net application development process give me any feedback on suitable tools for production of documents and reports please?

I have three main requirements to satisfy:

1) Production of listing type reports of a fixed format of a regulatory nature
2) Production of ad-hoc reports, i.e. an end-user driven tool
3) Production of letters, i.e. debt chasers

Data is all in SQL Server 2000 - would SQL Reporting Services be an option to consider?

Thanks
Simon