Reports (with export functionality to PDF/Excel) are generated using Microsoft Report Viewer, which is not part of .NET Framework 2.x. In order to use the report and export functionalities, you have to install Microsoft Report Viewer first. Installation and usage of Microsoft Report Viewer is free.
Generate T-SQL data scripts
Export data to Text/CSV
Export data to PDF
Export data to Excel
Download reporting services files in a single step