mpolo91 Posted January 17, 2023 Share Posted January 17, 2023 Hello,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. Link to comment Share on other sites More sharing options...
Solution mahadiosb Posted January 17, 2023 Solution Share Posted January 17, 2023 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 Link to comment Share on other sites More sharing options...
mpolo91 Posted January 19, 2023 Author Share Posted January 19, 2023 @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. Link to comment Share on other sites More sharing options...
mahadiosb Posted January 22, 2023 Share Posted January 22, 2023 Glad to know it works in summary section. :) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now