I created a paginated report using SQL Server Reporting Services and attached a dataset to pull a specific query from the database. However, I would like when I create a schedule for that report, for the delivery dataset to be used instead of the report dataset. Is this possible?
The reason being I want not only for the scheduled report to output one report per row in the database table but that each report only contains its respective row of data. What would you advise? Do let me know if any additional information is needed.