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