Jump to content
We've recently updated our Privacy Statement, available here ×

sagarnikam123

Members
  • Posts

    39
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by sagarnikam123

  1. 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 Message

    com.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 Trace

    com.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

  2. I am having two input for dates as below & want to set alert for that

    input_shot.png.eb44afc9e23b861e3315c1d4d9154437.png

    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.

  3. 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
  4. 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)

    something-access.jpg.9aa3400c4e72c6f15182a5a6537eda50.jpg

  5.  

    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 ?

     

  6. 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

    outside.png.c37f7a0d7fbf814de573180d4888b98a.png

     

     

  7. 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 ?

     

  8.  

    I have two crosstabs & two charts
    If 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 below
    I tried option,float,Fiexed Relative to Top & firxed relative to bottom,but no effect.
     
    testing.png.e26d47d511acac2774cf3d849122dcab.png
     
    & 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

    testing.png.67593816a74b7f6b022596a64fc63819.png

  9.  

    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 ?

     

  10. 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

  11.  

    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 ?

     

     

×
×
  • Create New...