This is probably an elementary question, but for the life of me I can't decide the proper direction to go with it.
I simply need to create a report which shows only ten records per page. The incoming selection is unknown - may be only a few records, may be hundreds. Regardless of number of pages, must show only ten records per page.
Is there a table limiting function in SSRS that I can use, or should I approach this with a stored procedure?
Just looking for a kick in the right direction.