so my problem was that each record was short and it was printing one small record on each page I found a way to print multiple small records on each page It sounds like you have a different problem, with one record needing more than one page to print...

so it does work to set the record size different than the page size, this is not intuitive at all but it appears to be the answer.