Explain the architecture of reporting services.- Reporting Services runs as a middle-tier server as part of the existing server architecture.
- SQL Server 2000 should be installed for the database server, and Internet Information Services 6.0 as a Web server.
- The report server engine takes in report definitions, locates the corresponding data, and produces the reports.
- Interaction with the engine can be done through the Web-based Report Manager, which also lets you manage refresh schedules and notifications.
- End users view the report in a Web browser, and can export it to PDF, XML, or Excel.