StevenCrawford

When my dataset returns no data, I'm getting a null pointer exception: 2017-09-07 08:09:13,807 ERROR AsyncJasperPrintAccessor,pool-6-thread-67:321 - Error during report executionjava.lang.NullPointerException at com.jaspersoft.jasperreports.customvisualization.fill.CVFillComponent.evaluateComponent(CVFillComponent.java:171) at com.jaspersoft.jasperreports.customvisualization.fill.CVFillComponent.evaluate(CVFillComponent.java:144) at net.sf.jasperreports.engine.fill.JRFillComponentElement.evaluate(JRFillComponentElement.java:110) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:381) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:500) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2022) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:748) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:115) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:580) at net.sf.jasperreports.parts.subreport.SubreportFillPart.fill(SubreportFillPart.java:177) at net.sf.jasperreports.engine.part.FillPart.fill(FillPart.java:77) at net.sf.jasperreports.engine.fill.PartReportFiller.fillPart(PartReportFiller.java:400) at net.sf.jasperreports.engine.fill.PartReportFiller.fillParts(PartReportFiller.java:385) at net.sf.jasperreports.engine.fill.PartReportFiller.fillDetail(PartReportFiller.java:337) at net.sf.jasperreports.engine.fill.PartReportFiller.fillReport(PartReportFiller.java:280) at net.sf.jasperreports.engine.fill.PartReportFiller.fill(PartReportFiller.java:214) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:924) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:169) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:880) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1829) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1169) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1051) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:946) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Side note: Can anyone point me to the source code for the CVC Components?

Another way of getting this to work (at least in version 6.3.0) is to use a ternary expression which returns Boolean.TRUE or Boolean.FALSE. For example if your existing expression was: $F{SHOULD_SHOW_HYPERLINK}[/code]You could replace it with this. $F{SHOULD_SHOW_HYPERLINK} ? Boolean.TRUE : Boolean.FALSE[/code]

Changed Resolution from Fixed to Open Re-opening for visibility to last comment.

Thanks! So far I've seen similar behavior when right clicking on a chart/table and loading the dataset menu.

This is how I'm using multi-select input controls. Create a Parameter, giving it a name and assigning the class java.Util.Collection. You can assign default values by using an expression like java.util.Arrays.asList(new String[]{"value1","value2"}) In your query, in the where statement place 'WHERE $X{IN, DB_FIELD, PARAM_NAME}' You could also use this syntax elsewhere in the report. So my query may end up looking like: SELECT id, metric FROM ex_table WHERE $X{IN, id, id_list}

http://community.jaspersoft.com/wiki/advanced-formatting-new-html5-charts

Awesome! Thanks Thomas! Haven't tried to implement yet but based of the property description this will save me tons of time.

Is it possible to detect the export format that is currently being used? I'm wanting to dynamically detect what export format is being used and show or hide report elements based on this. For example, if the user exports to PDF I wish to show a particular data table but if the instead export to CSV I do not.

Can you use a table instead? Using a table with the Print When statements will cause the table to reflow. Using your example if I hide C but leave a,b,d,e, a table will cause d to appear next to b.

I'm not sure how to solve this. So far I haven't had the need to do this. Sorry!

Make sure all of your fields are lined up correctly. If a field is out of line, many times items will disappear. I've found using Tables takes out a lot of the issues we were having with excel exports. Ever since we switched from just using fields in the detail band to tabels we have had much fewer problems!

Check the server logs for any errors. They hould be in {INSTALL_DIR}/apache-tomcat/logs if my memory serves me correctly.

Not to hijack your post but we've seen strange behavior with the back button as well. In our case we can return to the original report from the Drilldown report, but the HTML5 chart no longer appears. (All other content does)

Chances are this is because you're report has two components that aren't propary aligned, or that overlap. Check to see if AJ5 is merged with AL45. If so you can probably assume the overlap is outside of the crosstab and is as a result of one of the other items in the report. Hope this helps.

*EDIT 2* As of Jasper 5.1, I believe Jaspersoft fixed this issue by adding a 'none' sort type. I have not tried this due to time constraints but it's worth a shot if you're on 5.1 or later. *EDIT 1* My orginal solution worked fine for data sets that only had one measure per category. Basically any data set that didn't have the category repeated more than once. However when the category value was repeated it viewed everything as larger than the value before it. The solution wasn't as obvious as it should have been but I simply added a check in the Comparator to detect if the two objects were equal. If they were then I return 0, otherwise return 1 as usual. The Soltuion: Create a comparator which always returns a value of 1 (greater than). iReport sees that the data is already in order and doesn't change anything. This allows you to define ordering at the query level! See the attached java file for more info. I've also attached a jar if you just want the fix. To use: Add jar to classpath. Instantiate the custom comparator in the Comparator Expr box for the desired series or category. Enjoy query level sorting!