You might be able to put page navigation buttons on the report (clickable images) that call the same report with a specific page number and have the paging logic in your SQL query (Stored Procedure).
BUT: you would not be able to export the report to excel / pdf etc and get anything more than the current page.
The buttons would have a "Go to Report" action and have logic a bit like this in the expression for the value of the "Page number" parameter of your report.
The "Page back" button:
=IIf(First(Fields!Page.Value, "DataSet1")>1,First(Fields!Page.Value, "DataSet1")-1,1)
The "Page forward":
=First(Fields!Page.Value, "DataSet1")+1
Of course, you would need to include the page number in your dataset for this to work and your Query would need good fast paging code to make this worthwhile.
This does work, I have used it myself.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);