Does that help at all?

Daniel Bowlin (6/23/2011)

---

And just a bit of personal opinion.....no one really looks at reports with that much data. If anything they want to do some additional number crunching and...

Daniel Bowlin (6/23/2011)

---

Are you trying to get exports to Excel to be limited to 65000 rows per tab regardless of natural grouping or do some groups need to be broken...

If this is a known limitation of SSRS, some advice on how to restructure the report would also be helpful. 😉