Buy your DBA cookies, make them tea, do whatever it takes to get friendly procedures written to make adding datasets to a paginated report easier.
Table of Contents:
00:00 - Introduction
00:31 - Looking at dataset with custom SQL
01:39 - Create dataset based on stored procedure
02:55 - Change the dataset the table uses
03:33 - Preview the Report
04:03 - Publish the Report