Report and attached table of the database with the records. Note that in Detail1 have a page break when Table1 beyond the first page on the second page not the page break occurs, if you edit query Table Dataset 1 to: select case uf when 'SP' then 'São Paulo' else 'Rio de Janeiro' end as estado, cidade from cidade where uf = $P{UF} order by cidade limit 10 with "limit 10" the page break occurs because Table1 don't beyond the first page. Do you understand? Any suggestion?