In report builder can you page break by one of your groupings/columns. I'm running a sales order report and need to break by my customer for distribution.

depending on what you are going to do with the output. if it's for human to review, data output that big is going to be troublesome, set filter to shrink it. if it's for computer to process, then length doesn't matter.