sagarnikam123

I am using Windows platform,iReport-4.7 & Jasperserver-5 my report works fine on iReport,but gets exception on Jasperserver as below to solve I added rt.jar (which contains java.text.SimpleDateFormat Class) into JasperServer directory--> /apache-tomcat/webapps/jasperserver/WEB-INF/lib/rt.jar & restarted all services ,even though below error remains same Error Messagecom.jaspersoft.jasperserver.api.JSExceptionWrapper: Error evaluating expression : Source text : ( Math.abs( new java.text.SimpleDateFormat("yyyy-MM-dd").parse($P{start_year}.toString() + "-"+$P{start_month}.toString()+"-01").getTime() - new java.text.SimpleDateFormat("yyyy-MM-dd").parse($P{end_year}.toString() + "-"+$P{end_month}.toString()+"-01" ).getTime())/(1000*60*60*24)/30 ) Error Tracecom.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :Source text : ( Math.abs( new java.text.SimpleDateFormat("yyyy-MM-dd").parse($P{start_year}.toString() + "-"+$P{start_month}.toString()+"-01").getTime() - new java.text.SimpleDateFormat("yyyy-MM-dd").parse($P{end_year}.toString() + "-"+$P{end_month}.toString()+"-01" ).getTime())/(1000*60*60*24)/30 ) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:203) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:591) at net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:559) at net.sf.jasperreports.engine.fill.JRFillDataset.setFillParameterValues(JRFillDataset.java:972) at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:629) at net.sf.jasperreports.engine.fill.JRParameterDefaultValuesEvaluator.evaluateParameterDefaultValues(JRParameterDefaultValuesEvaluator.java:87) at net.sf.jasperreports.engine.fill.JRParameterDefaultValuesEvaluator.evaluateParameterDefaultValues(JRParameterDefaultValuesEvaluator.java:59) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getReportInputControlsInformation(EngineServiceImpl.java:2382) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getReportInputControlsInformation(EngineServiceImpl.java:2340) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getReportInputControlsInformation(EngineServiceImpl.java:2230) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.getControlsInformation(ReportParametersAction.java:523) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.getReportParameterValuesFromRequest(ReportParametersAction.java:361) at com.jaspersoft.jasperserver.war.action.ViewReportAction.executeReport(ViewReportAction.java:487) at com.jaspersoft.jasperserver.war.action.ViewReportAction.runReport(ViewReportAction.java:366) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:77) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:393) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:388) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:232) at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196) at org.springframework.webflow.engine.Flow.resume(Flow.java:545) at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:261) at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:169) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at $Proxy97.resumeExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183) at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:96) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:192) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:192) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:101) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:76) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:130) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:619) Caused by: java.text.ParseException: Unparseable date: "null-null-01" at java.text.DateFormat.parse(DateFormat.java:337) at java_text_DateFormat$parse.call(Unknown Source) at outside_use_report_comp_1361539043955_612190.evaluate(calculator_outside_use_report_comp_1361539043955_612190:153) at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:190) ... 126 more

@ajinkya_c, How to send request for any bug/enhancement in Tracker for jasperserver/iReport,Can u tell me in short ? Thanks in Advance !!!

I am having two input for dates as below & want to set alert for that Alert:- If difference between StartDate & EndDate is more than 6 months,it must generate alert / prompt panel showing text "Month Period exceed than 6", & report should not proceed.further, untill & unless the user select dates between any six months.

Also,when I upload,the same over jasperserver,first table prints fine on first page,but on second page,second table splits into 3-4 next pages,having single column on one page.I tried with "columnbreak offset"=0 & =5 of crosstab,but no effect

I am using Windows Server 2008 R2 Standard,iReport-4.8, I have field which is dynamically filed with month names in crosstab,I tried with "data presorted" option in crosstab, ON as well as OFF.There is not effect on output. But months names are sorting alphabetically. see highlighted square as in figure. How can I do it by Regular months sorting ?(jan,feb,march,april,may...so on) Also I want to remore columns lines & make it single row ,without lines interfering (see 1st row with 1 number), so I removes all padding & borders of columns ,even though it shows below.(Indiacated by arrow)

Does this bug,present in iReport-4.8,where can I find that (bug list) ?

Does this bug,present in iReport-4.8

@ajinkya_c & @Sanbez,call u tell me properly how to write A customizer class & where to put it,just to show value axis tick labels.I seen some customized class samples,but they are out of my control to understand

I am using Ubuntu 12.04, iReport-4.7, MySQL database, mysql-jdbc driver I write stored procedure in MySQL DELIMITER //CREATE PROCEDURE first()BEGINselect * from person where id in (11,22,33);END //DELIMITER; which return id & name as fields & calling it from iReport select id+1,name from (call first) gives me syntax error, Caused by: com.mysql.jdbc.exceptions.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 'call first)' at line 1 but when I run call first in query executor,no error How should I get required field for further calculations ? Does this is possible in MS-SQL ?

@jbernat , Can You explain in Details,because I can run stored procedure,but can't get required field from Resultset.e.g. select FieldName from (call my_procedure)

I am using ireport4.8 windows,I want to printed whole report in summary band (I tried using another band many times,but not giving good views,so I choose summary band) I have 1) main report- with 2 table & 2 chart , 2) subreport-with 3 charts as below 1) I have put "page break" line where I indicated, but it is not working.I want to show subreport-1 in next page (also If I adds another subreport-2,want to show as separate page) 2) why second chart (right in Main report) floats in table(encircled) ? problem is when I specified it "relative to bottom",it goes in sub-report.But the left one when specified floats it stays in its position.I want to show them side by side I used "summary" band in subreport also to print the contents

@ajinkya_C,I select "Check ON",on all properties below ,1)Value axis Vertical Tick labels 2)Category Axis Vertical tick labels 3)Show Labels 4)Show Legends, but its not showing values over tip

can u tell me according to ireport 4.7

@ajinkya_c,thanks, It works for Pie charts using "Legend Label Format" as {0} {2}, but for Bar chart,there is nothing like "show value" in Properties for Ireport 4.7 Can u elaborate more on how to set property ?

I am using iReport 4.7 community edition,ubuntu 12.04,making report & viewing it in both iReport and in HTML format, in chrome browser. I put 3D bar chart in summary band and want to show value on its tip (i.e. on top).So I go by below way. 1) check on show Labels & show Legends in 3D Bar Chart Properties 2) Right click on Chart > Chart Details > Details > Category Details > by selecting category,Modify > Item Hyper link > Tool tip > Tool tip Expression > $F{dayname(ServiceDate)}.toString() , where $F{dayname(ServiceDate)} is field name even though, its not showing anything outside_use_charts. Is this facility not present in community edition ? Should I embed any other .jar file for that ?

there are 2 blank answers

I have two crosstabs & two chartsIf I put crosstabs in detail band, error comes "Error filling print... Error incrementing crosstab dataset"when I put both in summary section,along side of Charts,then charts mixes with them as belowI tried option,float,Fiexed Relative to Top & firxed relative to bottom,but no effect. & How should I format field name called "month_name" which show months in crosstab? I want it to be, when month between Jan to Apr,column should be green

I have below query in Report query wizard of iReport select docid_fname_pemid.*, MONTHNAME(b.ServicePeriodDate) as month_name,YEAR(b.ServicePeriodDate) as year_name , b.NonLTCMaximumSpecialPayment, b.NonLTCEnrolledPatientOutsideUseTotal, b.NonLTCAccessBonusfrom (select docid_pemid.PEMID, docid_pemid.DoctorID, b.$P!{transparency_check})from (select DoctorID,PEMID from DoctorPEMMap where PEMID in ($P{PEMID_input}) and StartDate >= $P{StartDate} and (EndDate <= $P{EndDate} or EndDate <= '0000-00-00') group by PEMID order by PEMID)docid_pemid left join Doctors b on docid_pemid.DoctorID=b.DoctorID) docid_fname_pemidleft join DoctorPayments b on docid_fname_pemid.DoctorID=b.DoctorID[/code]& parameters,as in order (Parameter class, Prompt Yes/NO, 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)transparency_check -->String,No prompt,($P{transparency_input}=="yes" ) ? ("FirstName") : ("AliasFirstName") 5)StartDate -->String,No prompt, $P{month_year}.split("-")[0]=="April" ? $P{month_year}.split("-")[1].concat("-04-01") : $P{month_year}.split("-")[1].concat("-10-01") 6) EndDate -->String, No prompt, $P{month_year}.split("-")[0]=="April" ? $P{month_year}.split("-")[1].concat("-09-30") : $P{month_year}.split("-")[1].concat("-03-31") when retrieving fields automatically,gives "Error:null" I ignore that & proceeds further to run. It runs when given transparency_input="yes",but when I give transparency_input="no",error occurs->Error filling print... Unknown column name : FirstName Setting up the file resolver... I want dynamic value of transparency_check to be either "FristName" or "AliasFirstName",which depends upon transparency_input("yes"/"no") parameter (look in question in parameter section) I think query not getting 'b.FirstName'. So I used concat function asconcat('b.',$P{transparency_check}), but it not works.[/code] How should I go ?

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_2at 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

I want to check current month to many condition as below. so I take TextField ,edit its pattern to MM& in expression editor edit below code new java.util.Date()>=4 && new java.util.Date() <= 7 ? "Q1" : new java.util.Date()>=8 && new java.util.Date() <=11 ? "Q2" : "Q3"[/code] but it gives error Error filling print... Error evaluating expression : Source text : new java.util.Date()>=4 && new java.util.Date() <= 7 ? "Q1" : new java.util.Date()>=8 && new java.util.Date() <=11 ? "Q2" : "Q3" Setting up the file resolver..[/code] but when I give expression like new java.util.Date()== 4 ? "Q1" : "Q2"[/code] It works fine. Does iReport not able to resolve multiple conditions ? or should I give different TextField with single condition ?

I made one cross table with optimized sql query,. I want total for each DoctorID also , when I add new row group for per total of DoctorID,gives below how should I proceed ?

I define one cross tab,with some column fields & rows fields, then added extra two measures,but while printing they are not visible what happen with them ?(I give them requied value experssion,calculation type etc also)It looks like below what to do ?

I want to customized date input contorl,which is already present in reporsitory. I want List of months and a list of years only & no date, for the previous 5 and current year also where user can select single year & month to give parameter to main report how sould I go ?

I dont want to use subreport,even i used that also,it create problem of importing parameter,some fields from main report. Any how the problem is going to same. @ajinkaya_c can u tell answers for my questions,asked in bottom ? may be logic how to proceed using any tutorials

@ajinkya_c sir,there is only one page to show,no next page