I'm on a data warehouse team, and have been getting many requests for reports consisting of large sets of data (in excess of 1000 rows).

Many are unmanageably large when it comes to usefully rendering a report, resulting in hundreds of pages.

What is the best way to go about (1) cutting down on the data size in an acceptable manner, and/or (2) cutting down on the sheer length of these reports?

In practice, what is the upper limit of a dataset that Reporting Services can work with?

Thanks for your advice.

Mike