rita73

I am using multi select input paramter in a report. So users can select either 1 or all values for the paramter. I am having difficulty finding out how I can use one graph that will repeat for each of the paramter values, entered by the user, at run time? If the user selects five values, it should generate five charts/graphs. Right now I have one chart in the Title band, I 've tried to put it in the summary band, which gives the same result. And even if I select three values from the list, it produces the chart for only one of them.

It should be java.util.Collection

Hi, Does anyone know a good plugin to create heatmaps in a jasper report. May be using crosstab ? Thanks

Thanks Kristen!!

Thanks for the reppnse. I have passed the suggestion to the person responsible for the server set up. Thanks

Thanks for responding! The current timezone of database is GMT-7 (day light savign Pacific time) and when setting the data source with in jasperserver, we have the time zone as: "use database setting" so ideally it should show the same, but it shows GMT-5. thanks

The reports are not empty and gettting created in the specified format on the server. It's only not able to send the email. The exceptions list looks something like this: Quartz Job: ReportJobs.job_41 Quartz Trigger: ReportJobs.trigger_42_0 Exceptions: An error occurred while sending job error notification. org.springframework.mail.MailSendException: Mail server connection failed; nested exception is javax.mail.MessagingException: Could not connect to SMTP host: mail.localhost.com, port: 25; nested exception is: java.net.ConnectException: Connection timed out at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:419) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:342) at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:338) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.sendMailNotification(ReportExecutionJob.java:1259) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:445) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:231) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: javax.mail.MessagingException: Could not connect to SMTP host: mail.localhost.com, port: 25; nested exception is: java.net.ConnectException: Connection timed out 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:389) ... 7 more Caused by: java.net.ConnectException: Connection timed out 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) ... 10 more

There is an email notification option of Jasperserver when we are scheduling the reports. My reports seems to run fine but it never sends me any emails for notifying. Any possible reasons? I am assuming it should work with jasperserver pro. Thanks

The current time on the our server seems to be two hours ahead of pacific time. Wanted to learn how to change the time to the Pacific time zone, that is, GMT-8. I have tried changing the timezone setting at login to pacific, but whenever I create or run a report it is stamped with the time two hours ahead of us. Is there any other way to do it? Post Edited by vanbc at 03/18/2010 15:34

It works. I needed to change the row group properties though. Thanks

hi, I have successfully created a crosstab with three variables in row group and one in column group( that's date). the measure variable is some revenue calculated over the group variables. I have total revenue showing at the bottom of each date column. If I want to show the total at the top of the column for each date, how should I do it. Simply moving the 'total 'cell to the top doesn't help. The total stops showing completely in the published report then. Any suggestions will be great!