Hi Peter, If I understand your requirements correctly I think grouping would be better than having multiple subreports.
Grouping the data on users allows you to create a seperate table for each user, you can also have a header and footer for each user and you can also perform calculations and have totals at the bottom of each group. Hope this helps. Chris Peter Jin wrote: > > Hi, > I may need to put several sub reports in the detail section in the master > report. So the sub reports will get loaded many times. Will this cause > significant performance issues? Does jasper cache data source for report > in this case? > > My case: > User's data are scattered in 5 tables and I need to put those data > together under a particular user. I don't want to use UNION because HQL > doesn't support it. In addition, Union 5 tables may result in a huge SQL. > I have to use one sub report for each table and iterate users in master > report and for each user iterate all sub reports to display data relevant > to that user. > > Is this viable or any other solution? > > Any comment is appreciated. > -- View this message in context: http://www.nabble.com/How-about-loop-a-sub-report--tp23847733p23848126.html Sent from the jasperreports-questions mailing list archive at Nabble.com. ------------------------------------------------------------------------------ OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get _______________________________________________ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions