kelly

Hi everyone, I'm happily using jasperserver, but I have a problem. I created couple reports and they are working fine, but In my report, i have Japanese description, abut after i convert it to PDF, the Japanese description disappeared and if i convert it to CSV, the japanese become garbage. Must be somewhere i can change to uft-8, then everything magically working fine, right? Please help. Thanks a lot. Kelly

kelly Wrote: 2004 IR Help Wrote: By: syncat - syncat Convert to PDF,HTML ..etc. with russian chars 2004-06-19 07:24 When printing through iReport with russian chars, it prints corrent but when converting the same file to PDF or HTML etc., it converts only latin chars but not russian. I have the same problem. In my report, i have Japanese description, abut after i convert it to PDF, the Japanese description disappeared. Must be somewhere i can change to uft-8, then i would convert for me correctly, right? Please help. Thanks.

2004 IR Help Wrote: By: syncat - syncat Convert to PDF,HTML ..etc. with russian chars 2004-06-19 07:24 When printing through iReport with russian chars, it prints corrent but when converting the same file to PDF or HTML etc., it converts only latin chars but not russian. I have the same problem. In my report, i have Japanese description, abut after i convert it to PDF and excell, the Japanese description disappeared. Must be somewhere i can change to uft-8, then i would convert for me correctly, right? Please help. Thanks.

Hi Lucian, I see. It must be Community Edition. I download it from http://jasperforge.org/plugins/project/project_home.php?group_id=112 the jasperserver-3.0- linux-installer.bin. Could you please let me know where i can download the Professional feature? Thanks. Kelly

Gabriel and Sherman, thank both of you. In the iReport, how to set up the default, now i understand. thanks. I'm still don't know how to save the current values which Sherman was talking about. When i run the report, the control window will pop out, the title is: Report Options, but i don't see a button i can hit to save it. Since i have 7 controls, i really don't want to select them every time. Could you please explain it for me one more time? Thanks a lot. Kelly

Hi Everyone, I have a question about jasperserver. I'm trying to make a report which can let the user to choose a parameter control created by a query. in this query i want to use other parameters which i set up, is that possible? if it is then how? ok, let me explain again. in on report I make 3 parameters. 1. start_date 2. end_date 3. Location_Name the 3rd one, i'm using a query, and i also want to limited the period by 1(start_date) and 2(end_date) for 3(Location_Name). Is that possible? Or is there anyway i can let the user select from a selection? Many thanks in advance. Kelly

Thanks for your kind reply. I cannot find Parameters. the "View" you are talking about is the "Home" "View" "Manage" "Log Out", that "View"? Thanks.

kelly xia Wrote: Hi Everyone, For jasperserver report, i set up couple controls. I used single-select list of values. Is there anyway i can set one value as default value? so the user doesn't have to choose everytime. Is there is, could you please let me know? Thanks a lot. Kelly btw, i'm using jasperserver 3.0

Hi Everyone, For jasperserver report, i set up couple controls. I used single-select list of values. Is there anyway i can set one value as default value? so the user doesn't have to choose everytime. Is there is, could you please let me know? Thanks a lot. Kelly

Hi Eveyone, I also have a question about single select query input control. What I want to do is: create 3 input controls, the second query of input control will depends on the first result. The second one is like first control's sub control. And the Third one is depends on the second one's result. Is there any way can make it in JasperServer? Thanks in advance! Kelly

Hi Everyone, I also have a jasperserver scheduling question. Is there any way to disable the scheduling function? In jasperserver, there is a scheduling icon. seems like any kind of user (even read only) can make a schedule. I don't want to everyone can make the schedule themselves, is there any way i can disable the scheduling? Thanks in advance. Kelly

Hi Everyone, I'm trying to put a $V{} in a query to make a conditional query like this: select * from table1 where $V{con} <> 1 but it gave me the SQL executing error (syntax error). so i made a $P{} and let the default value = $V{con}, now there is no compile error, but there is no value in $P{}, it always null. Anybody has idea about this? Thanks in advance. Kelly

I have sending email problem too. it always gave me the error says: Code:Job: test (ID: 11) Report unit: /reports/samples/SalesByMonth Quartz Job: ReportJobs.job_11 Quartz Trigger: ReportJobs.trigger_11_0 Mail server connection failed; nested exception is javax.mail.MessagingException: Could not connect to SMTP host: localhost, port: 25; nested exception is: java.net.ConnectException: Connection refused: connect org.springframework.mail.MailSendException; nested exceptions (0) are: Caused by: javax.mail.MessagingException: Could not connect to SMTP host: localhost, port: 25; nested exception is: java.net.ConnectException: Connection refused: connect at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1282) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370) at javax.mail.Service.connect(Service.java:275) at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:382) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:335) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:331) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:595) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendToDestinations(ReportExecutionJob.java:357) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:278) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:148) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: java.net.ConnectException: Connection refused: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:516) at java.net.Socket.connect(Socket.java:466) at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:232) at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:189) at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1250) ... 11 more i tried to change the js.mail.properties and add the property too. but still the same error message. is there anybody know how to fix it? thanks in advance. Best regards. Kelly

I have sending email problem too. it always gave me the error says: Code:Job: test (ID: 11) Report unit: /reports/samples/SalesByMonth Quartz Job: ReportJobs.job_11 Quartz Trigger: ReportJobs.trigger_11_0 Mail server connection failed; nested exception is javax.mail.MessagingException: Could not connect to SMTP host: localhost, port: 25; nested exception is: java.net.ConnectException: Connection refused: connect org.springframework.mail.MailSendException; nested exceptions (0) are: Caused by: javax.mail.MessagingException: Could not connect to SMTP host: localhost, port: 25; nested exception is: java.net.ConnectException: Connection refused: connect at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1282) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370) at javax.mail.Service.connect(Service.java:275) at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:382) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:335) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:331) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:595) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendToDestinations(ReportExecutionJob.java:357) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:278) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:148) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: java.net.ConnectException: Connection refused: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:516) at java.net.Socket.connect(Socket.java:466) at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:232) at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:189) at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1250) ... 11 more i tried to change the js.mail.properties and add the property too. but still the same error message. is there anybody know how to fix it? thanks in advance. Best regards. Kelly

I have sending email problem too. it always gave me the error says: Code:Job: test (ID: 11) Report unit: /reports/samples/SalesByMonth Quartz Job: ReportJobs.job_11 Quartz Trigger: ReportJobs.trigger_11_0 Mail server connection failed; nested exception is javax.mail.MessagingException: Could not connect to SMTP host: localhost, port: 25; nested exception is: java.net.ConnectException: Connection refused: connect org.springframework.mail.MailSendException; nested exceptions (0) are: Caused by: javax.mail.MessagingException: Could not connect to SMTP host: localhost, port: 25; nested exception is: java.net.ConnectException: Connection refused: connect at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1282) at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:370) at javax.mail.Service.connect(Service.java:275) at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:382) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:335) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:331) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:595) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendToDestinations(ReportExecutionJob.java:357) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:278) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:148) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: java.net.ConnectException: Connection refused: connect at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:516) at java.net.Socket.connect(Socket.java:466) at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:232) at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:189) at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:1250) ... 11 more i tried to change the js.mail.properties and add the property too. but still the same error message. is there anybody know how to fix it? thanks in advance. Best regards. Kelly

You are RIGHT. THANKS A LOT. :laugh:

hi, i have the same problem, and i followed the shija03 changed the code, but it gave me error message: Incompatible conditional operand types String and Date. any idea what i sould do now? i've been working on this for couple days alread.... thanks. Post edited by: kelly, at: 2007/07/13 22:16

I also have a parameter date type question too. i was trying to read iReport from JasperServer. everything was fine, but when i tried to do "add control" on JasperServer, it gave me error messages said the date type are not compatible, so i changed the parameter's date type in ireport to java.until.date. but still gave me the error message said: sql error. anybody knows how to solve this problem? thanks a lot.

you are right. thanks a lot. i'm very new about ireport, i have no idea about your problem....sorry...but i'll try... thanks again.

Hi, now i have a problem with crosstab. i'm using iReport. i can make a crosstab no problem, but it only show the result when there is only one record. if there are more than one record, it will show: "Error filling print... Error incrementing crosstab dataset" "Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.corsstabs.fill.calculation.BucketingService.addData(BucketingService.java:295).....Print was not filled." do you why this happened? thanks a lot.

Hi, now i have a problem with crosstab. i'm using iReport. i can make a crosstab no problem, but it only show the result when there is only one record. if there are more than one record, it will show: Error filling print... Error incrementing crosstab dataset net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:671) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:152) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:652) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:252) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:763) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:669) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:942) at java.lang.Thread.run(Unknown Source) Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:295) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:667) ... 12 more Print was not filled. Try using an EmptyDataSource... do you why this happened? thanks a lot. Post edited by: kelly, at: 2007/07/09 19:06

Hi, i also have a problem with crosstab. i'm using iReport. i can make a crosstab no problem, but it only show the result when there is only one record. if there are more than one record, it will show: Error filling print... Error incrementing crosstab dataset net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:671) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:152) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:652) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:252) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:763) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:669) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:942) at java.lang.Thread.run(Unknown Source) Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:295) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:667) ... 12 more Print was not filled. Try using an EmptyDataSource... anybody knows why this happened? thanks in advance. Post edited by: kelly, at: 2007/07/09 19:08

jmurray, thank you very much! it looks very nice now. thanks a lot. Post edited by: kelly, at: 2007/07/02 19:18

hi Marcelo and Kevin, i have the same problem. do you have the answer now? if you do please let know. thanks a lot a lot. Kelly

hi Marcelo and Kevin, i have the same problem. do you have the answer now? if you do please let know. thanks a lot a lot. Kelly