BIRT Report Ad Hoc Queries

245 Views Asked by At

When users create an Ad Hoc BIRT report and download it to an Excel spreadsheet the default is 40 rows/sheet. I want the default to be 0, which means that it will download all the rows to 1 sheet. I know that the solution is setPageBreakInterval(0), but don't know where to set it up for the users.

1

There are 1 best solutions below

2
Eloise On

If it's a table:

  1. select your table,
  2. then go in the properties
  3. avoid all (before, inside, after)
  4. set the page break interval to 0

Should do :

enter image description here