tomsimmons

Hmm Must have got confused when I tried this last time... The answer is: jasperDesign.getProperty(String propertyName) Tom

Afternoon All I'm wondering if someone can enlighten me as to how I can read the values of the custom report properties from code? I know having loaded the report as a JasperDesign object I can reach the parameters and their properties, but I would like to check the custom properties of the entire report. Thanks Tom

Thank you for your help, I have now been able to complete this report. A note to others: I found info here... http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=35245 The point that I initially missed in the second post is that you only need to include the information in one place. Also, for those using iReport, under the Edit Menu, you'll find Custom Properties, when you click New here, you'll find this setting in the Special Meaning Properties list, double click and add true as the property value, amke sure you've turned off all the over flow stuff and when you excel sheet loads you'll find if you expand the column all your text is present. Tom

Thanks for your reply. I'm looking now for information on the net.sf.jasperreports.print.keep.full.text option. I don't suppose you have a link to a handy explantion/example of how to use it? Tom

Hi Thanks for your reply. I know it's not easy to follow, wasn't easy to explain either :) I've attached another screen shot showing the report in iReport. The prroblem is that the long description field can be pretty big, to handle it overflow is enabled which causes where necessary to becomes 2+ lines deep. On a PDF or similar output this is not a problem, but I need Excel and that results in the problem you see in the first posts attachment. The subreport I can guarantee will always only be one row high, it is a column report actually. The band is currently the same height as the subreport, but grows when the description fields grows. I can't see another way that the data could be gathered other than with a sub report, sadly. Tom

I think people will need the .jrxml files to understand what's going on. I'll have a look when you've posted them, this sounds like an problem I had some time back and managed to solve. Tom

Hmmm, I'm quite surprised there has been no answer to this topic. Surely there must be someway of making a subreport stretch to the tallest object or band height? Tom

Hi Folks I have written a report that consists of top report with only a subreport which is in the detail band. The subreport has some fields and a subreport in its detail band and column labels in it's Column Header band. The final subreport has columns, and two fields only in the detail band - it has a group for the columns. I have a couple if fields in the middle subreport that can be large, so they have stretch on overflow, consequently I have set all fields to strech to band height, and the subreport. I have also set the fields in the subreport to strech to band height (clutching at straws?). Long and short, everything in all reports is set to strech to band height. When I run the report as PDF or JR Viewer, all is fine, but I need to run as Excel. When I run as Excel, on rows where the two fields need to stretch, but there is nothing from the subreport, all is fine. However if they stretch and there is info fromt he subreport, then the subreport isn't stretched, so I end up with a line of blank cells under the subreport data. I've tried both Excel export API's. How can I make the subreport stretch to band height? I have attached a screen sippet, the blue being the fields (including the cause of the stretch, the yellow being the subreport, and the green being the bit I don't want. Tom Post Edited by tomsimmons at 05/07/2009 08:18

I think you've lost me?! Are you saying that POI does (now) support images? Tom

I realise this, what I coudn't understand is that all the information point to needing to use the JExcel(JExcelApiExporter) if you want to have graphics in the excel sheet and POI(JXlsExporter) if you don't need graphics. However when I tested my report, using both of these in iReport they both included the graphics. Tom

If you need to use JExcelAPIExporter to get graphics in the export, how does iReport (3.0.0) achieve it regardless of which Excel option you choose under the Build menu? Tom

Don't seem to be able to edit a message - well you can, just can't submit the edit?! The line that it fails on is.... JExcelApiExporter e = new JExcelApiExporter(); Tom

OK, not sure of the very first time, but it seems it was in the from about 1.2.7, certainly earlier than I need to worry about. So my next question is...which jar files do I need for JExcelApiExporter? I see people talking about jxl.jar, which I assume is jxl-2.6.jar in recent releases of iReports lib directory? However including this doesn't improve matters. The error I'm getting is...below? Hopefully. Thanks Tom Code:14:04:27,006 ERROR [[jsp]] Servlet.service() for servlet jsp threw exceptionjava.lang.ClassNotFoundException: No ClassLoaders found for: jxl.JXLException at org.jboss.mx.loading.LoadMgr3.beginLoadTask(LoadMgr3.java:212) at org.jboss.mx.loading.RepositoryClassLoader.loadClassImpl(RepositoryClassLoader.java:514) at org.jboss.mx.loading.RepositoryClassLoader.loadClass(RepositoryClassLoader.java:408)...14:04:27,006 ERROR [ReportServlet] doGet(): org.apache.jasper.JasperException: javax.servlet.ServletException: java.lang.NoClassDefFoundError: jxl/JXLException

Can anyone tell me that from which version of JasperReports is JExcelApiExporter included? Tom

I guess there is no reason for it to be HTML, it could just as easily be RTF, just as long as it is the body of the email and and rich formatted. Tom