Error: net.sf.jasperreports.engine.JRException: java.lang.ClassCastException: java.lang.Boolean cannot be cast to java.util.Map

[mayuri.kadam]

Hello All,

I am new to Jaspersoft studio. I am trying to create a report and I have followed the following steps:

1) Defined new data source 'SampleDataSource1'- Test connection successful!

2) Created new report - SampleReport1 usingdata adapter 'SampleDataSource1'

3) Added query and selected all fields:

SELECT "SAMPLEVIEWS"."SVIEW"."COLUMNRID",

"SAMPLEVIEWS"."SVIEW"."DATATYPE_DEFINED"

FROM "SAMPLEVIEWS"."SVIEW"

Note COLUMNRID is of type string and DATATYPE_DEFINED is Integer

4) Added a parameter 'dbdef' as java.lang.Integer and checked "IsForPrompting"

 

5) Modified the query to add the line:

 

SELECT "SAMPLEVIEWS"."SVIEW"."COLUMNRID",

"SAMPLEVIEWS"."SVIEW"."DATATYPE_DEFINED"

FROM "SAMPLEVIEWS"."SVIEW"

WHERE "IAVIEWS"."SVIEW"."DATATYPE_DEFINED" =  $P{dbdef} 

 

6) Added table to the report with query as:

 

SELECT "SAMPLEVIEWS"."SVIEW"."COLUMNRID",

"SAMPLEVIEWS"."SVIEW"."DATATYPE_DEFINED"

FROM "SAMPLEVIEWS"."SVIEW"

 

7) For the table, in 'parameters map' section I added "$F{DATATYPE_DEFINED}.equals( $P{dbdef} )"

 

Now I am trying to run and filter on DATATYPE_DEFINED column but I am getting an error: 

et.sf.jasperreports.engine.JRException: java.lang.ClassCastException: java.lang.Boolean cannot be cast to java.util.Map

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:537)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:512)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:393)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Caused by: java.lang.ClassCastException: java.lang.Boolean cannot be cast to java.util.Map

at net.sf.jasperreports.engine.fill.JRFillSubreport.getParameterValues(JRFillSubreport.java:623)

at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateParameterValues(JRFillSubreport.java:474)

at net.sf.jasperreports.components.table.fill.FillTableSubreport.evaluateParameterValues(FillTableSubreport.java:108)

at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:454)

at net.sf.jasperreports.components.table.fill.FillTableSubreport.evaluateSubreport(FillTableSubreport.java:102)

at net.sf.jasperreports.components.table.fill.FillTable.evaluate(FillTable.java:133)

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.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123)

at java.lang.Thread.run(Thread.java:745)

 

Any help is appreciated.

Thankyou!