report in xls output and page breaks every 40 rows of table data..

thelcd

<p>hi,</p><p> </p><p>When I output my report in xls format, the table only shows 40 rows of data before creating a new excel sheet.</p><p> </p><p>How can I present all my table data on only one sheet.</p><p>ie. no page breaks.</p><p> </p><p>I can't find the property in the report designer..</p><p> </p><p>Thanks all</p><p> </p>

micajblock

<p>Change the page break on the table to 0. If you are using commercial BIRT - there is an option for this.</p>