jmurray wrote: There is no such setting in iReport. You could potentially manipulate the resPerPage via a scriptlet. But you could also achieve this using groups as there is a "Start on a new page" parameter in the group settings. In your source query you would configure a new group field based on rownumber. An Oracle example that limits the number of records per page to (say) 35 would be something like this: select trunc(rownum/35) as myGroup, first_name, last_name from turbine_user MySQL is a little different in that it doesn't have any concept of rownum. It needs something more like this: SELECT floor((@rownum:=@rownum+1)/35) as myGroup, t.* FROM (SELECT @rownum:=0) r , (SELECT AccountName from DigiToll.Account) t