But what if I need to put tables and charts into the detail band? My main top level report has multiple pages for each record in the main report query.
Device id 1 - 6 pages of multiple charts, sub-reports, and tables in multiple detail bands
Device id 2 - 6 pages of charts, sub-reports, and tables ...
... for a hundred or more devices with total page counts of over 600 pages. Once the first device pages are done, there is no need to go back and process the data again for its components before doing device 2/record two.
As I said, my report is working great and looks great. However, it is slow and has a Processed Records Count of well over 100,000,000 when this number should be in the range of maybe 100,000. When I say slow, I mean five minutes in Jasper Studio to generate the report.
Is there a better way of structuring my report to reduce the records count?