mizan_1

Class Cast Exception while trying to peform decsending order on table column with double data type in the report. Report table column contains double data type. Clicked on the "down" arrow to see data descending or der and getting below error. It appers this descding order function is looking for integer type. But my field type is double. How to get around to this issue. Error Messagejava.lang.ClassCastException: java.lang.Double cannot be cast to java.lang.Integer Error Tracejava.lang.ClassCastException: java.lang.Double cannot be cast to java.lang.Integer at java.lang.Integer.compareTo(Integer.java:52) at net.sf.jasperreports.engine.fill.DataSourceComparator.compare(DatasetSortUtil.java:271) at net.sf.jasperreports.engine.fill.DataSourceComparator.compare(DatasetSortUtil.java:225) at java.util.TimSort.countRunAndMakeAscending(TimSort.java:324) at java.util.TimSort.sort(TimSort.java:203) at java.util.TimSort.sort(TimSort.java:173) at java.util.Arrays.sort(Arrays.java:659) at net.sf.jasperreports.engine.fill.DatasetSortUtil.getSortedDataSource(DatasetSortUtil.java:121) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:900) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:651) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:203) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724)

Below is the error I am getting. Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; MS-RTC LM 8) Timestamp: Tue, 8 Apr 2014 19:52:07 UTC Message: Object doesn't support property or method 'querySelectorAll' Line: 5 Char: 4964 Code: 0 URI: http://192.168.5.3:8080/jasperserver/scripts/lib/amd-jquery-1.10.2.js

My Jasper reports created through i-report and deployed in Jasper server working fine in Firefox, Chrome and IE 8 fine. But its not working with IE 9. Reports keep on spinning and showing loading pop-up and never ends. I can see report loaded in the back ground but still the loading pop-up keeps spnning indifinitely. Need help in resolving this issue in IE 9.

Thanks. That worked.

ok, thanks. One issue is, this created variables not showing up in the chart details->expression editor. So I am unable to add that variable as x-axis. How do I make that variable visible/ available in the expression editor to add that as x-axis in my chart?

Thanks. But I am bit confused. where should I put that SimpleDateFormat("dd/MM/yy").parse("01/01/01") expression, and fields calculation type and reset type value? when I go to chart data -> details, it opens up window to select field and few transformation condition (like, toString, valuOf etc). But I don't see any place to set calculation type, reset type and also where should I place "SimpleDateFormat("dd/MM/yy").parse("01/01/01")"?

Error filling print... Error evaluating expression : Source text : $F{_id} Setting up the file resolver... net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $F{_id} at net.sf.jasperreports.engine.fill.JREvaluator.evaluateEstimated(JREvaluator.java:308) at net.sf.jasperreports.engine.fill.JRCalculator.evaluateEstimated(JRCalculator.java:582) at net.sf.jasperreports.engine.fill.JRCalculator.estimateVariables(JRCalculator.java:181) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1259) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1233) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1577) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:149) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:932) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object '2014/01/01' with class 'java.lang.String' to class 'java.util.Date' at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.castToType(DefaultTypeTransformation.java:360) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.castToType(ScriptBytecodeAdapter.java:599) at report645growth45chart_1394143189167_342593.evaluateEstimated(calculator_report645growth45chart_1394143189167_342593:268) at net.sf.jasperreports.engine.fill.JREvaluator.evaluateEstimated(JREvaluator.java:295) ... 15 more Print not filled. Try to use an EmptyDataSource...

How to convert string to date to display in the chart. Dataset is returning string format date and string format number fields coming out of mongodb. I need to plot chart with date and number but both are in string format. How dow I convert those string format date to java util date and string format number to regular number so that chart can be desplayed properly. Currently I am getting error as both date and numbers are string format.

Hi, I am having converting string to date and integer. In mongodb both date and numbers stored as string. During chart creation, I put date string as X axis and number string as y axis. But ireport is complaining that it can't convert string to date. Anyone know how to convert date string to java.util.Date so that chart can display date as x-axis. Similary how to convert string to integer so taht chart can display y axis with integer value.

I am having issue converting String date to Date format to display in my chart in jasper ireport. I am getting date as "yyyy/mm/dd" string format from mongodb. But to display in the chart looks like ireport requires time to be date format. How do I convert. I am getting below error: Error filling print... Error evaluating expression : Source text : new SimpleDateFormat("MM/dd/yyyy").format($F{_id}) Setting up the file resolver... net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : new SimpleDateFormat("MM/dd/yyyy").format($F{_id}) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:244) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:591) at net.sf.jasperreports.charts.fill.JRFillTimeSeries.evaluate(JRFillTimeSeries.java:146) at net.sf.jasperreports.charts.fill.JRFillTimeSeriesDataset.customEvaluate(JRFillTimeSeriesDataset.java:104) at net.sf.jasperreports.engine.fill.JRFillElementDataset.evaluate(JRFillElementDataset.java:155) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:160) at net.sf.jasperreports.engine.fill.JRFillDatasetRun.detail(JRFillDatasetRun.java:306) at net.sf.jasperreports.engine.fill.JRFillDatasetRun.iterate(JRFillDatasetRun.java:261) at net.sf.jasperreports.engine.fill.JRFillDatasetRun.evaluate(JRFillDatasetRun.java:208) at net.sf.jasperreports.engine.fill.JRFillElementDataset.evaluateDatasetRun(JRFillElementDataset.java:231) at net.sf.jasperreports.engine.fill.JRFillChart.evaluateDatasetRun(JRFillChart.java:1406) at net.sf.jasperreports.engine.fill.JRFillChart.evaluateChart(JRFillChart.java:832) at net.sf.jasperreports.engine.fill.JRFillChart.evaluateRenderer(JRFillChart.java:808) at net.sf.jasperreports.engine.fill.JRFillChart.evaluate(JRFillChart.java:797) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:456) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummaryNoLastFooterSamePage(JRVerticalFiller.java:1090) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:1055) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:319) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:158) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:932) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:276) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:745) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: java.lang.IllegalArgumentException: Cannot format given Object as a Date at java.text.DateFormat.format(Unknown Source) at java.text.Format.format(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSite.invoke(PojoMetaMethodSite.java:189) at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:53) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116) at report645growth45chart_Dataset321_1394085272694_841544.evaluate(calculator_report645growth45chart_Dataset321_1394085272694_841544:162) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:231) ... 28 more Print not filled. Try to use an EmptyDataSource...