Re: [jasperreports-questions] How about loop a sub report?
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
Re: [jasperreports-questions] How about loop a sub report?
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
[jasperreports-questions] Problem with chart created from beanCollection data source
Hi I have a report that includes a 3D bar chart which worked fine with SQL data source. Now I have changed it to use a list of Beans. The chart display with the correct bar heights but the x and y labels are missing. I have tried turning all fields into variables and changing the evaluate At properties and shortening the names, none of which seem to make a difference. The bar heights correspond to the Variable PERCENTAGE so I know the values are being populated it just the fields used for the category names don't show and the scale with the numbers on. The only thing I can see that may be causing this problem is that I group the data in the report and I also have some print when expressions. Can anyone help, I am about to throw the towel in on this one, this project is well overdue and I have been stuck at this point for the last 3 days. I will try and upload the files in a new post. Thanks Chris http://www.nabble.com/file/p23173901/ProcessingResultsTemplate.jrxml ProcessingResultsTemplate.jrxml -- View this message in context: http://www.nabble.com/Problem-with-chart-created-from-beanCollection-data-source-tp23173901p23173901.html Sent from the jasperreports-questions mailing list archive at Nabble.com. -- Register Now Save for Velocity, the Web Performance Operations Conference from O'Reilly Media. Velocity features a full day of expert-led, hands-on workshops and two days of sessions from industry leaders in dedicated Performance Operations tracks. Use code vel09scf and Save an extra 15% before 5/3. http://p.sf.net/sfu/velocityconf ___ jasperreports-questions mailing list jasperreports-questions@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jasperreports-questions