I have a requirement to restict the no of pages in ssrs data driven subscription. The user wants to limit the no of pages of report to be sent(top 5/top 10) instead of all pages.
Figure out how many rows display on each page of the report, then make a parameter for your query to do a top X to return the right number of rows for the report.