Sorry I forgot to mention that the info I gave is based on using iReport/jasperReports, not sure what you are using now but I definately recommend iReport.
Chris chr15athome wrote: > > 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--tp23847733p23848170.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