[jasperreports-questions] How about loop a sub report?

2009-06-03 Thread Peter Jin
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

Re: [jasperreports-questions] How about loop a sub report?

2009-06-03 Thread chr15athome
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

Re: [jasperreports-questions] How about loop a sub report?

2009-06-03 Thread chr15athome
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

Re: [jasperreports-questions] How about loop a sub report?

2009-06-03 Thread Peter Jin
Hi Chris, Thanks for your reply. Grouping can not solve my issue because it works on one data source only. In my case, data for a user scattered in 5 tables. UNION might be a way to combine all tables to a data source, but I can not use it either (explained in the first post). any thoughts? --

Re: [jasperreports-questions] How about loop a sub report?

2009-06-03 Thread David Bolen
Peter Jin jinyup...@gmail.com writes: Grouping can not solve my issue because it works on one data source only. In my case, data for a user scattered in 5 tables. UNION might be a way to combine all tables to a data source, but I can not use it either (explained in the first post). any