hussainkali

Can anyone help with this? I have a report with a sub report, the sub report appears in the detail band and represents a section of the report (this can be from 1.. many sections). For whatever reason, I can't tell, when a sub report (i.e. section) has only a single row I get an additional gap between subreports in my main report. I've attached two files so you can see what I mean. I've also attached my jrxml files. Any help would be much appreciated, I've spent most of today messing about with margins and spacing to no avail, I suspect it's something I'll never think of but maybe one of the experts on here will know? Thanks in advance, Hussain Please see my original post in the iReport forum for attachements: http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=91699#91752

Can anyone help with this? I still haven't managed to solve the problem.

Can anyone help with this? I have a report with a sub report, the sub report appears in the detail band and represents a section of the report (this can be from 1.. many sections). For whatever reason, I can't tell, when a sub report (i.e. section) has only a single row I get an additional gap between subreports in my main report. I've attached two files so you can see what I mean. I've also attached my jrxml files. Any help would be much appreciated, I've spent most of today messing about with margins and spacing to no avail, I suspect it's something I'll never think of but maybe one of the experts on here will know? Thanks in advance, Hussain

Hi folks, Hopefully someone can help me out here, this should be REALLY simple to do but I've been looking at the problem all afternoon and can't see a reason why this is happening. I've created a class to use in a crosstab report (to allow me to order headings the way I want - not alphabetically) and I'm trying to use this class in my BucketExpressions for the crosstab. However, I get the error shown in the code snippet below. I have added the path to the directory containing the compiled .class file and verified that the file is definately there. Am I missing something? This is the bucket expression I'm using: <bucket> <bucketExpression class="com.amor.app.service.reporting.dto.ColumnWrapper"><![CDATA[new com.amor.app.service.reporting.dto.ColumnWrapper($F{h1Order}, $F{h1})]]></bucketExpression> </bucket> Hopefully someone can help me out here, I'm really desperate! Code: Compiling to file... C:\Projects\my-application\src\main\webapp\reportTemplates\DailyReport.jasper net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : 1. java.lang.ClassNotFoundException: com.amor.app.service.reporting.dto.ColumnWrapper 2. java.lang.ClassNotFoundException: com.amor.app.service.reporting.dto.ColumnWrapper 3. java.lang.ClassNotFoundException: com.amor.app.service.reporting.dto.ColumnWrapper 4. java.lang.ClassNotFoundException: com.amor.app.service.reporting.dto.ColumnWrapper 5. java.lang.ClassNotFoundException: com.amor.app.service.reporting.dto.ColumnWrapper 6. java.lang.ClassNotFoundException: com.amor.app.service.reporting.dto.ColumnWrapper 7. java.lang.ClassNotFoundException: com.amor.app.service.reporting.dto.ColumnWrapper 8. java.lang.ClassNotFoundException: com.amor.app.service.reporting.dto.ColumnWrapper 9. java.lang.ClassNotFoundException: com.amor.app.service.reporting.dto.ColumnWrapper 10. java.lang.ClassNotFoundException: com.amor.app.service.reporting.dto.ColumnWrapper at net.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:258) at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:140) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:499) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)Compilation running time: 60!

Yes this can be done. I generate reports for Excel and PDF and use the following to enable/disable pagination. if (report format is xls) { params.put(JRParameter.IS_IGNORE_PAGINATION, Boolean.TRUE); } else if (report format is pdf) { params.put(JRParameter.IS_IGNORE_PAGINATION, Boolean.FALSE); } then pass the parameter map (params) to the fill manager when creating the JasperPrint object. Hope this helps?

Hi, hopefully someone can shed some light on a problem I'm having. I have a master report with four different subreports. One of the subreports contains a crosstab that will pretty much always be wider than the page width. I will be exporting this report to Excel or PDF format and have been doing the following: if (reportFormat.equals(ReportFormat.XLS)) { params.put(JRParameter.IS_IGNORE_PAGINATION, Boolean.TRUE); jasperReport.setProperty(JRCrosstab.PROPERTY_IGNORE_WIDTH, "true"); } else if (reportFormat.equals(ReportFormat.PDF)) { jasperReport.setProperty(JRCrosstab.PROPERTY_IGNORE_WIDTH, "false"); } This has worked fine for all other reports I've been creating (where I have crosstab in main report). However, with this one, because the crosstab is in a subreport the report isn't being formatted the way I'd like. I have tried setting the IS_IGNORE_PAGINATION property to True within iReport for the subreport in question, and have also tried setting the property True in both master and all subreport but have had no success. I have also added the following to each subreport and to the crosstab: <parametersMapExpression>new HashMap($P{REPORT_PARAMETERS_MAP})</parametersMapExpression> but still not working as I'd like. I have attached the report output so that you can see exactly what I mean (I've highlighted the section that isn't right). If someone in the know could have a look I'd really appreciate it. Regards, Hussain Ali p.s. I've just noticed this through a google search but what's the difference between these two addresses? http://stage.jasperforge.org/plugins/espforum/browse.php?group_id=102&forumid=103 http://jasperforge.org/plugins/espforum/browse.php?group_id=102&forumid=103

Although I didn't get any feedback, just incase anyone else has the same issue, I've managed to get it working: Using the conditional property set in my last post didn't work because the crosstab in the report template had the property set to false. I didn't realise that by setting this property in the report template that it could not be changed at runtime (the property being specified in the crosstab overrides any global report property setting). By removing ignoreWidth="false" altogether from the crosstab definition allowed me to set the property globally before filling the report. Hope this helps someone else, Hussain Ali

I've tried the following code, and although the property does seem to be getting set, it doesn't seem to have any effect on the report output. If anyone knows how to do this I'd really appreciate the help! Code:if (getSelectedReportFormatName(outputFormatId).equals("Excel 2007")) { jasperReport.setProperty(JRCrosstab.PROPERTY_IGNORE_WIDTH, "true");}else { jasperReport.setProperty(JRCrosstab.PROPERTY_IGNORE_WIDTH, "false");}

ok, I've just found that if I set the Crosstab property PROPERTY_IGNORE_WIDTH then it doesn't wrap around to a new 'page'. However, it looks like I can only set this property globally, which isn't much good to me as I've have to export the report as PDF as well (user can select either PDF, XLS or XLSX). Anyone got any ideas?

I have created a report using a Crosstab which I intend to use for reporting XLS and XLSX reports. I have placed the crosstab in the summary band and it all seems to work well. However, when the number of columns is too high the columns wrap around onto the 'next page' (i.e. under the first lot of data). Is there anyway that I can just get a continuous report going from left to right without the report wrapping round? I have tried setting the JasperPrint ignore pagination property, but this hasn't solved the problem (it does make a difference but it's not how I'd like it). I've attached example reports, one with and one without pagination. Can someone please help :( Post Edited by hussainkali at 06/09/2010 14:21

Hi Folks, I've been using JasperReports for a little while now and everything seems to work great, however, today I tried to export my report in the XLSX format and noticed that the formatting of my number cells was not quite right. I have a few cells that all contain doubles, I have tried using the following to get the cells to format correctly: - reportExporter.setParameter(JExcelApiExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE); - set the property (net.sf.jasperreports.export.xls.detect.cell.type) to TRUE in the report template; - set the cell pattern to #####0.00. I have tried each of these things individually and all combinations, but no matter what my numeric values (Doubles) are formatted as currency in my XLSX report. Quite strangely I might add, although formatted as currency, the currency 'unit' is not displayed in the cell, and I get Excel warnings that I have numbers stored as text. I don't have any of these problems when I change the JRExporter from an XLSX exporter to an XLS exporter. I have attached a copy of both files to show you what I mean exactly. They are both attached in XLS format, but I have checked using a copy of Excel 2007 and the cells are definately formatted as currency before conversion. Can anyone help or advise me on what else I could try? Thank you, H Ali

Hi, I'm totally new to iReports and JasperReports and have been trying to get iReports working with an existing project. I have added the directory containing the Spring configuration to the class path (this directory also contains datasource.properties). I try to create a new Spring Loaded Hibernate Connection by providing the application-config.xml filename and the sessionFactory beanID, however, I get the following error message: "Could not load properties; nested exception is java.io.FileNotFoundException: class path resource [com/..../datasource.properties] cannot be opened because it does not exist." The file clearly does exist and I have no problems accessing my data in my application. Is anyone able to help? Thanks in advance, Hussain Ali