"Error null" when Automatically Retriev Fields from "Report Query" wizard

0

I have few parameters,as (Parameter class, Prompt ?, Default value Expression)

1)PEMID_input--> string, prompt yes, no

2)month_year--> .String,prompt yes, no

3)transparency_input--> String,prompt yes, no

4)month--> String, NO, $P{month_year}.split("-" )[0]

5)year-->String ,NO, $P{month_year}.split("-")[1]

6)StartDate-->String,No, $P{month_year}.split("-")[0]=="April" ? $P{month_year}.split("-")[1].concat("-04-01") :   $P{month_year}.split("-")[1].concat("-10-01")

7) EndDate-->String, No, $P{month_year}.split("-")[0]=="April" ? $P{month_year}.split("-")[1].concat("-09-30") : $P{month_year}.split("-")[1].concat("-03-31")

8)month_selector-->String, No, ($P{month_year}.split("-")[0]=="April") ? ($P{month_year}.split("-")[0].concat(",May,June,July,August,September")) : ($P{month_year}.split("-")[0].concat(",November,December,January,February,March"))

all parameters giving values in report when running with no queries(I tested them).

when I am running query by replacing  parametera to values, it also works fine

but when running with paramete gives,    Error:null. while retrieving fields in Report Query wizard 

even though I run report,& give specified parameters it give below error

=====================================================================================================================
Error filling print... Error executing SQL statement for : access_2 
Setting up the file resolver... net.sf.jasperreports.engine.JRException: Error executing SQL statement for : access_2
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:246)     
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1073)     
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:667)     
at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1253)     
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877)     
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822)     
at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61)     
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: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''FirstName'     
from (     select DoctorID,PEMID from DoctorPEMMap where PEMID in ('21' at line 3     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)     
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)     at java.lang.reflect.Constructor.newInstance(Constructor.java:532)     at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)     at com.mysql.jdbc.Util.getInstance(Util.java:381)     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)     at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1885)     at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:239)     ... 12 more 

Print not filled. Try to use an EmptyDataSource...

==================================================================================================================================================================

I have below .jrxml file attached

Attachments: 
sagarnikam123's picture
Joined: Nov 1 2012 - 10:33pm
Last seen: 1 year 3 months ago

0 Answers:

No answers yet
Feedback
randomness