SQL Server Reporting Services also support ad hoc reports: the designer develops a report schema and deploys it on the reporting server, where the user can choose relevant fields/data and generate reports.
SQL Server Reporting Services provides a mechanism for users to generate custom reports by selecting specific data fields from a pre-defined schema. The designer creates the report structure and deploys it on the reporting server for user access.