aaston

Good idea! Thank you! I was probably just spoilt by other programming softwares who are more forgiving of NULLs...)

Hi there, You must have had experience in trying to get your input controls work in both iReport and JS. I have jrxml with SQL query embedded...I can run a report fine in iReport with input parameter prompted (although the input control itself is not a nice multi-select checkbox) But in JasperSever, after I select multi-select checkbox input choices...I get the following error: java.lang.ClassCastException: java.lang.String cannot be cast to java.util.Set Any idea in what cases that happens? Thanks a lot guys, Aston Update 1: It turns out it works fine with various forms of single-select input controls...but if it's multi-select, I get the error like this above! Why does JS hate multi-select then? Update 2 Problem solved. Should have changed the parameter from java.lan.string to java.util.Collection and in the SQL query set $X{IN, field name, parameter name). Thanks for the forum's old posts. Fancy telling someone to learn C++ programming without guide books/documentation! :(( Post edited by: aaston, at: 2008/06/20 13:24

When I was trying to get input parameters work and trawled this forum, I have noticed some people using =P{...} and others using =P!{...} in MySQL queries...and now I'm curious what the difference is.

Nail on the head! Indeed the root seems to be that pie-chart hates NULL things... and I had a NULL country with 346 calls! Phew.

Nail on the head! Indeed the root seems to be that pie-chart hates NULL things... and I had a NULL country with 346 calls! Phew.

Post edited by: aaston, at: 2008/06/17 12:52

Every time I try to create a chart in iReport 2.0.4 , I get the following error message after executing: Error filling print... Null 'key' argument. java.lang.IllegalArgumentException: Null 'key' argument. at org.jfree.data.DefaultKeyedValues.setValue(DefaultKeyedValues.java:225) at org.jfree.data.general.DefaultPieDataset.setValue(DefaultPieDataset.java:187) at net.sf.jasperreports.charts.fill.JRFillPieDataset.customIncrement(JRFillPieDataset.java:159) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:152) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:682) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:255) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:891) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:795) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:944) at java.lang.Thread.run(Unknown Source) Print was not filled. Try using an EmptyDataSource... Does it mean my configurations were wrong (even though the chart needed is very simple) or links with JFreeChart/java something is not working? {New to iReport...attempting to create a pie-chart with $F{number_of_calls} for each $F{country} ). Without the chart, the iReport is working fine. Any idea/suggestions would be really fab. Post edited by: aaston, at: 2008/06/16 22:38