kjhuebner

Hi folks, I have a report where the first report page renders wider than all subsequent pages in a multipage report. This is occuring in a Swing JEditPane. In IE, the width appears consistent. The HTML output shows that the 1st page colspan=29 and the second page to nth page has colspan=21. Why would this occur? Is there anything I can do to have a consistent colspan used for all pages? I suspect this issue is related to the title that exists on the 1st page. I include templates, snapshot, and HTML output of page 1 and page 2. Thanks, Ken Huebner Catalyst International, Inc. [file name=IntransitInventory_1stPageWide.zip size=55453]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/IntransitInventory_1stPageWide.zip[/file]

Hi Teodor, Here's the jrxml files that were used to generate the xml and html. I also included the full xml and html output for viewing. The output is generated from a master report containing two subreports using custom data sources. (The HTML is rendered in a Swing application, so note that if you have IE render the included html, you'll see some vertical spaces between data.) But again, the HTML ordering is correct. The XML ordering is not. Thanks, Ken [file name=2006_10_2_xmlOrderingBad_withHTML.zip size=29786]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/2006_10_2_xmlOrderingBad_withHTML.zip[/file]

When I export a JasperPrint object as XML the order of data is mixed up. That is, the table "Heading" data appears AFTER the "content" data. And the Title appears AFTER a heading. Yet these things are in the proper order when the very same JasperPrint object is exported as HTML. As a result the XML data is unusable since I was planning to parse this data--separating it into column heading data followed by content. Is there any solution to this significant issue? Thanks! Ken XML Data... Code: <text textHeight="13.798828" lineSpacingFactor="1.1499023" leadingOffset="-2.3466797"> <reportElement mode="Opaque" x="29" y="203" width="135" height="20"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="5" bottomBorder="None" bottomBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000"/> <textContent><![CDATA[1010322000]]></textContent> </text> <text textHeight="13.798828" lineSpacingFactor="1.1499023" leadingOffset="-2.3466797"> <reportElement mode="Opaque" x="164" y="203" width="186" height="20"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="10" bottomBorder="None" bottomBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000"/> <textContent><![CDATA[0]]></textContent> </text> <text textHeight="13.798828" lineSpacingFactor="1.1499023" leadingOffset="-2.3466797"> <reportElement x="350" y="203" width="201" height="20"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="10" bottomBorder="None" bottomBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000"/> <textContent><![CDATA[13]]></textContent> </text> <text textAlignment="Left" verticalAlignment="Top" textHeight="15.09375" rotation="None" lineSpacing="Single" lineSpacingFactor="1.2578125" leadingOffset="-2.6367188"> <reportElement mode="Opaque" x="29" y="186" width="135" height="17" forecolor="#FFFFFF" backcolor="#3366FF"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="5" bottomBorder="None" bottomBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000"/> <font fontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="CP1252" isPdfEmbedded="false"/> <textContent><![CDATA[item Id]]></textContent> </text> <text textAlignment="Left" verticalAlignment="Top" textHeight="15.09375" rotation="None" lineSpacing="Single" lineSpacingFactor="1.2578125" leadingOffset="-2.6367188"> <reportElement mode="Opaque" x="164" y="186" width="186" height="17" forecolor="#FFFFFF" backcolor="#3366FF"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="5" bottomBorder="None" bottomBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000"/> <font fontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="CP1252" isPdfEmbedded="false"/> <textContent><![CDATA[inbound Qty]]></textContent> </text> <text textAlignment="Left" verticalAlignment="Top" textHeight="15.09375" rotation="None" lineSpacing="Single" lineSpacingFactor="1.2578125" leadingOffset="-2.6367188"> <reportElement mode="Opaque" x="350" y="186" width="201" height="17" forecolor="#FFFFFF" backcolor="#3366FF"/> <box topBorder="None" topBorderColor="#000000" leftBorder="Thin" leftBorderColor="#000000" leftPadding="5" bottomBorder="None" bottomBorderColor="#000000" rightBorder="Thin" rightBorderColor="#000000"/> <font fontName="Helvetica" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="CP1252" isPdfEmbedded="false"/> <textContent><![CDATA[OutboundQty]]></textContent> </text> HTML Data... Code:[code]<tr valign="top"> <td><img alt="" src="px" style="width: 29px; height: 17px"/></td> <td colspan="7" style="background-color: #3366FF; border-left-style: solid; border-left-width: 1px; border-left-color: #000000; padding-left: 5px; border-right-style: solid; border-right-width: 1px; border-right-color: #000000; "><span style="font-family: Helvetica; color: #FFFFFF; background-color: #3366FF; font-size: 12.0px; font-weight: bold;">Item Id</span></td> <td colspan="8" style="background-color: #3366FF; border-left-style: solid; border-left-width: 1px; border-left-color: #000000; padding-left: 5px; border-right-style: solid; border-right-width: 1px; border-right-color: #000000; "><span style="font-family: Helvetica; color: #FFFFFF; background-color: #3366FF; font-size: 12.0px; font-weight: bold;">Inbound Qty</span></td> <td colspan="12" style="background-color: #3366FF; border-left-style: solid; border-left-width: 1px; border-left-color: #000000; padding-left: 5px; border-right-style: solid; border-right-width: 1px; border-right-color: #000000; "><span style="font-family: Helvetica; color: #FFFFFF; background-color: #3366FF; font-size: 12.0px; font-weight: bold;">OutboundQty</span></td> <td><img alt="" src="px" style="width: 44px; height: 17px"/></td> </tr> <tr valign="top"> <td><img alt="" src="px" style="width: 29px; height: 20px"/></td> <td colspan="7" style="border-left-style: solid; border-left-width: 1px; border-left-color: #000000; padding-left: 5px; border-right-style: solid; border-right-width: 1px; border-right-color: #000000; "><span style="font-family: Arial; background-color: #FFFFFF; font-size: 12.0px;">1010322000</span></td> <td colspan="8" style="border-left-style: solid; border-left-width: 1px; border-left-color: #000000; padding-left: 10px; border-right-style: solid; border-right-width: 1px; border-right-color: #000000; "><span style="font-family: Arial; background-color: #FFFFFF; font-size: 12.0px;">0</span></td> <td colspan="12" style="border-left-style: solid; border-left-width: 1px; border-left-color: #000000; padding-left: 10px; border-right-style: solid; border-right-width: 1px; border-right-color: #000000; "><span style="font-family: Arial; font-size: 12.0px;">13</span></td> <td><img alt="" src="px" style="width: 44px; height: 20px"/></td> </tr>

Hi folks, I've been exporting my reports to HTML and rendering in Swing. However the rendering results are buggy--which I have not solved yet. So I thought I would get consistent results if I would export Jasper data as XML and populate a Swing TreeTable component with data. This way the data can be interactive since one can open and close a displayed tree. Nice idea, huh? :silly: But when I export data as XML the order of data in the XML is mixed up!! That is, the table "Heading" data appears AFTER the "content" data. And the Title appears AFTER a heading. Yet these things are at least in the proper order when the very same JasperPrint object is exported as HTML. The result being the XML data is unusable from a programmatic perspective. :sick: I hope someone can help me soothe my soul. Ken

Snapshot size=240]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/2006_9_6_IntransitInventory_small.jpg Post edited by: kjhuebner, at: 2006/09/07 20:28

Hi, On a master report-subreport view, the Jasper engine was putting too much vertical space between the content. So I went into both of my subreports, and set the height of all unused bands to zero. However, when I ran the report again, the content of one of the subreports disappeared. I have yet to know why? Using IReport, I experimented with 1) adjusting heights of the subreport areas designated in the master report; 2) adjusting heights of the unused bands back to 20-50; 3) adjusting margin,column widths -- but nothing solves my problem. I attached the templates with significant vertical space between rows, but show content correctly. And I attached the templates after setting unused bands to zero height, but show missing content on the Inbound (Purchase) Order subreport. Snapshot is what the report should look like when everything is working correctly. [file name=2006_9_6_TemplatesAndSnapshot.zip size=51680]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/2006_9_6_TemplatesAndSnapshot.zip[/file] Post edited by: kjhuebner, at: 2006/09/07 20:20 Post edited by: kjhuebner, at: 2006/09/07 20:23

Hi Please answer a couple questions: 1. Is a ResourceBundle required during the JasperFillManager.fillReport() operation? 2. Are thread-safe objects (ie Vector and Hashtable) required when talking to the Jasper engine? A day ago, when I ran a report that use to work, now is missing data. So I assumed a threading issue. Whereby, I switched from passing a HashMap to a Hashtable to the JasperFillManager.fillReport() method. However I now see a Jasper engine exception because its attempting to put a null value into the Hashtable. Code: java.lang.NullPointerException at java.util.Hashtable.put(Hashtable.java:393) at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:574) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:708) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:685) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at com.catalystwms.cct.web.servlets.JasperDelegate.fillReport(JasperDelegate.java:597) at com.catalystwms.cct.web.servlets.CCTViewServlet.addObjectResponse_getReportAsHTML(CCTViewServlet.java:1405) Thanks! Ken

Hi, Is the feature to set pagewidth,pageheight, margins,etc. at runtime available in latest release1.2.5? By runtime, I mean using a pre-compiled jasperreport along with perhaps some properties passed to engine. Teodor mentioned on Jan.2003 in a sourceforge forum discussion that such a feature was planned. I sure need this important feature implemented -- if its not available. :woohoo: Thanks, Ken

Ok, I'm going to have to eat crow on this one. My mistake. Mea Culpa. I now see a report title AND content using my custom datasource. I had a bug in my custom datasource's base class, in the next() method being called by Jasper. It was improperly returning false, instead of true. Duh. I also discovered the switch which turns on title/graphics when no content exists: Code: whenNoDataType="AllSectionsNoDetail" Now on to getting my subreport to work... Regards, Ken

Here's my jrxml files. Ken [file name=CCTIntransitInventory.zip size=3381]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/CCTIntransitInventory.zip[/file]

Hi, What causes the Jasper engine to return empty HTML (having no content or report title) and yet it throws no exceptions? I'm using a custom datasource that I know contains data. I call the method fill(jasperReport, map, dataSource) followed by a call to export HTML. And it returns this: Code:<html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/> <style type="text/css"> a {text-decoration: none} </style> </head> <body text="#000000" link="#000000" alink="#000000" vlink="#000000"> <table width="100%" cellpadding="0" cellspacing="0" border="0"> <tr><td width="50%"> </td><td align="center"> </td><td width="50%"> </td></tr> </table> </body> </html> So I tried some experiments to find out what might be the cause. 1. I tried the fill(jasperReport, map, dbConnection) with a test report. It successfully created html WITH content. 2. I tried the fill(jasperReport, map, dbConnection) with report missing the queryString element. It created html WITHOUT content and NO exceptions. Much like what I was seeing with my report using a custom datasource. So now I ask... Why do the Jasper products give so little information to the developer when they are run??[/ul] As a 15-year software developer, this is very frustrating and it makes the Jasper products appear primitive. My guess, the cause of my issue is that the Jasper report running my custom datasource cannot find data. But if it cannot find data, is it because of a classpath problem to my custom datasource, an empty datasource, what?? Also, if a report has no content, why does Jasper generate a blank report? Shouldn't it at least have a title? Again, I see no exceptions -- just empty HTML from Jasper. Any comments are much appreciated. Ken Java Architect Catalyst International, Inc.

Hey, I have confidence in all of you -- Giulio, Lucian, and the JasperTeam! If I wasn't so busy with my own technical work, I'd be happy to lend a hand. Ken :cheer:

Thanks Lucian for your reply. If I'm hearing you right, IReport forbids me from using a custom datasource during the fill operation. Sounds like a major bug. Also, please ignore the subreport's datasource entry you noticed (you're very observant :woohoo: ). My intention was to retrieve the subreport datasource by: <dataSourceExpression><![CDATA[((com.catalystwms.report.TestDataSource)$P{REPORT_DATA_SOURCE}).getSubDataSource("Tasks")]]></dataSourceExpression> The above code started this whole exploration. This failed due to the Class Cast exception problem. We now know this a class loader bug in IReport. I hope you guys fix this soon. Without this bug fix in IReport, its going to be difficult or impossible to incorporate Jasper into our company product. Ken

[file name=TestDataSource-3454e0948eb140276eb408b731c67e93.zip size=23342]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/TestDataSource-3454e0948eb140276eb408b731c67e93.zip[/file]

It's hard to be optimistic after 3 days of fiddling with Jasper and IReport. Nonetheless I will describe my latest issue: I get a Class Cast exception when retrieving a custom data source at the subreport level. And knowing there is no effective means to understand what's going on under the covers (since this tool is very deficient in providing such means to developers) I decided to do an experiment. I wanted to determine what was in the REPORT_DATA_SOURCE parameter at the top of the master report. So I setup a parameter to retrieve a value that I assumed to be my custom data source. (For my connection setup had already tested OK with my custom datasource "com.catalystwms.cct.web.beans.reports.TestDataSource" within IReport) But when I run this snippet of code in my report, out pops the Class cast exception. Why? Why doesn't this work? (All files are attached.) Code:<parameter name="JR_REPORT_DATA_SOURCE" isForPrompting="false" class="com.catalystwms.cct.web.beans.reports.TestDataSource"> <defaultValueExpression ><![CDATA[((com.catalystwms.cct.web.beans.reports.TestDataSource)$P{REPORT_DATA_SOURCE})]]></ defaultValueExpression> </parameter> IReport TRACE ============== Time zone: default Error filling print... ENTERED TestDataSourceFactory.getTheDatasource() ENTERED TestDataSource() CONSTRUCTOR ENTERED addRow index=0 ENTERED TestDataSource(List) CONSTRUCTOR ENTERED TestDataSource.putSubDataSourceFromRow() key=Tasks ENTERED addRow index=1 ENTERED TestDataSource(List) CONSTRUCTOR ENTERED TestDataSource.putSubDataSourceFromRow() key=Tasks java.lang.ClassCastException: com.catalystwms.cct.web.beans.reports.TestDataSource at TestDataSource_1154553627259_783159.evaluate(TestDataSource_1154553627259_783159:126) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:172) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:539) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:507) at net.sf.jasperreports.engine.fill.JRFillDataset.setFillParameterValues(JRFillDataset.java :631) at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java: 593) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:708) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:685) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:728) at java.lang.Thread.run(Unknown Source) NESTED BY : java.lang.ClassCastException: com.catalystwms.cct.web.beans.reports.TestDataSource at TestDataSource_1154553627259_783159.evaluate(TestDataSource_1154553627259_783159:126) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:172) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:539) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:507) at net.sf.jasperreports.engine.fill.JRFillDataset.setFillParameterValues(JRFillDataset.java :631) at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java: 593) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:708) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:685) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:728) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : ((com.catalystwms.cct.web.beans.reports.TestDataSource) $P{REPORT_DATA_SOURCE}) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:183) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:539) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:507) at net.sf.jasperreports.engine.fill.JRFillDataset.setFillParameterValues(JRFillDataset.java :631) at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java: 593) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:879) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:708) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:685) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:728) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.ClassCastException: com.catalystwms.cct.web.beans.reports.TestDataSource at TestDataSource_1154553627259_783159.evaluate(TestDataSource_1154553627259_783159:126) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:172) ... 11 more Print not filled. Try to use an EmptyDataSource...! Code:[code] [file name=TestDataSource-ee74ec388dcb63ad3fc8aec51997a982.zip size=23342]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/TestDataSource-ee74ec388dcb63ad3fc8aec51997a982.zip[/file] :«»sick: