displaying an entire table on one page with SQL RS2005

Today I'm trying to figure this one out.  I've got this report I put together for my team that has a table which returns records from a database.  Currently, the report automatically creates a table with multiple pages which stores all the returned rows.  What I'm being asked for is if I can get all the rows to show up on one page.

To my frustration I have not been able to get this to work.  I haven't found a single piece of information on any way to set this.  There's a ton of places to set Page Breaks, but they do not seem to affect how the table displays it's data, no matter what the combination.

Anyway, it's a new day and I'm absolutely sure I'll get different results from a search engine today with the answers I'm seaking...hehehe, wishful thinking.  :)

Seriously though has anyone else ever tried anything like this with any success?