I'am using a table in JasperSoft that is placed in the detail band. The table is filled with data queried from a database. If I start the preview so in JasperSoft I get a report with more than 20.000 pages. Normally the report should have not more than 80 pages. I have read that a table should not placed in the detail band. If this is fact, what is the correct band for a table? As I can see all header and footer bands a restricted by the height. So it is not possible to place the table there. Also the summary band produces a report with to much pages.
Put that table in the summary section or add it in the Title or page header section.
Basically, the detail section shows data as many times as you have rows. For example, if you have data with 3 rows then, the Details section calls 3 times. If you add the table in the detail section which shows 5-row data then 3 tables will show. Cause details have 3-row data. means it will multiply with details section data, which means 5 x 3 = 15 row
@mahadiosb As I described above setting the table into the page or column header did not work because JasperSoft restricts the height of the band. But putting the table to the summary band works now.
Glad to know it works in summary section. :)