You can achieve the desired layout with report groups.  Groups support filtering and sorting that allows you to limit and order the data of the group according to your needs.

Adding-filter-and-Grouping-data