I am reporting on a pivot table of 100,000+ records and the pivot process is performing very poorly. It's running into the minutes. Is there a way to pass in which page is being viewed by the report viewer for the purpose of limiting the result set to just those records? Any other suggestions for speeding things up?

Thanks.