max_max_mir

I have a dataset, and I'd like to pass the IN and NOTIN as a parameter to $X{IN, a.col, SomeCollection} When I try $X{$P!{In_NotIn}, a.col, SomeCollection} I get an error. Any other way of accomplishing this? Basically, I have a dataset with a comnplicated query, and I am creating two tables from this dataset. One where values are in a set of values, the other, where values are not in the set of values.

Hello, I would like to reuse a dataset across reports. Currently, I find myself copying and pasting the same dataset in multiple reports, but everytime I make a chance on one, I have to change it on all the reports. Needless to say, this seems inefficient and error prone. Are there any guidelines as to how to address this? Can one create a dataset independent of a report, and then use that in multiple reports? Regards,

I have JasperServer CE 5.6 installed on a server (Ubuntu 14.04) and have created a bunch of artifacts (reports, input data types, data connections, resources, etc.). I have another JasperServer installed on a whole new server machine. I'd like to basically move all of the artifacts over to the new JasperServer - don't want to recreate (I have new settings etc. on the JasperServer, so migrating Tomcat is out of the question). What's the best way of accomplishing this?

The only workaround for this so far seems to be to try different browsers and stick with the one that works. It definitely doesn't work on FF.

6.0.1 CE on Ubuntu 14 Server

Did you try with different browsers?

When I right click on the folder in the server, and select Add Resource -> Data Source I get an empty blue screen! Does anyone else have this problem? It is debilitating! I am trying to create this using JasperStudio connected to the Server, but I can't figure out how to register the MySQL JDBC driver! Update: This happens only in Firefox. With Chrome, after a second or two, the page loads. So Whew!

Changed Assigned User from @User_306070 to @anonymous Not sure what that is. Are there any guides that can help me understand how to do such an installation?

Thanks hozawa, but this doesn't help. There are way too many steps I'll need to automate if I have to install the war file. What I need is a way to use the jasper server default install, but passing parameters so I don't have to type in a "Y" for license agreement and a "N" for installing the sample reports. Is there another way out?

Hello, Can anyone point me to documentation on unattended installation of JasperReprots Server CE v 5.6? Regards, Max

I think the question is too generic. Are you asking for best practices?

Hello - I am not sure what you are trying to do. Do you want the output to be 101, 102 and 103 for John, James and Jack? Also, are they three separate rows in the report?

Searched a ton, but this fixed it!

Changes I had to make to get this working report.scheduler.mail.sender.host=smtp.gmail.com report.scheduler.mail.sender.protocol=smtps report.scheduler.mail.sender.port=465 <prop key="mail.smtps.auth">true</prop> <prop key="mail.smtps.starttls.enable">true</prop>

I had to make multiple changes (highlighted below) /home/ubuntu/JasperServer/apache-tomcat/webapps/jasperserver/WEB-INF/js.quartz.properties report.scheduler.mail.sender.host=smtp.gmail.com report.scheduler.mail.sender.protocol=smtps report.scheduler.mail.sender.port=465 /home/ubuntu/JasperServer/apache-tomcat/webapps/jasperserver/WEB-INF/applicationContext-report-scheduling.xml true true

Now I get this The job error notification was not completed. An error occurred while sending it. org.springframework.mail.MailSendException: Failed messages: com.sun.mail.smtp.SMTPSendFailedException: 530-5.5.1 Authentication Required. Learn more at 530 5.5.1 http://support.google.com/mail/bin/answer.py?answer=14257 My credentials are okay and I followed the steps in the link. Oh - and I had to change smtp.google.com to smtp.gmail.com

for some reason, ArrayList was adding values twice, so I ended up using TreeSet

I am trying to send scheduled reports as email attachments from JasperServer 5.6. Here's what I have configured /home/ubuntu/JasperServer/apache-tomcat/webapps/jasperserver/WEB-INF/js.quartz.properties # This file is now just a pass-through for stuff in the# file referenced by the Maven js.quartz.properties file.quartz.delegateClass=org.quartz.impl.jdbcjobstore.PostgreSQLDelegatequartz.tablePrefix=QRTZ_quartz.extraSettings=report.scheduler.mail.sender.host=smtp.google.comreport.scheduler.mail.sender.username=xxx@gmail.comreport.scheduler.mail.sender.password=xxxreport.scheduler.mail.sender.from=xxx@gmail.comreport.scheduler.mail.sender.protocol=smtpreport.scheduler.mail.sender.port=587report.scheduler.web.deployment.uri=http://ubuntu.xxx.com:8080/jasperserver[/code]/home/ubuntu/JasperServer/apache-tomcat/webapps/jasperserver/WEB-INF/applicationContext-report-scheduling.xml <property name="javaMailProperties"> <props> <prop key="mail.smtp.auth">true</prop> <prop key="mail.smtp.starttls.enable">true</prop> </props></property>[/code]But I get the following error Could not connect to SMTP host: smtp.google.com, port: 587[/code]My JasperServer is on a VirtualBox VM which can access the internet. I cannot telnet smtp.google.com on port 587 either on the VM or the Host Machine (and I am able to connect to the internet on both). Any hints as to what I may be doing wrong?

Did this resolve your question? I am having the same issues and would like to know what you did to resolve this. I followed the steps in this article http://mdahlman.wordpress.com/2011/09/28/emailing-reports-from-jasperreports-server/

AFAIK, JS doesn't support this. There are several workarounds, but none simple.

I have scanned the forums and haven't yet found an easy way to do expand/collapse in JS. I am looking for a solution too.

I have a simple report with the following SQL SELECT id FROM table[/code]Results: 1, 2, 3, 4 I have a variable "AList" of type ArrayList (Value Class Name), Calculation is System, Initial Value Expression is "new ArrayList()", Increment Type is None and Reset Type is Report. The Expression for this is $V{AList}.add($F{id}) All I want this ArrayList to do is keep adding new ids with each row. So when I have the $F{id} and $V{AList} in the detail band, I expect to see something like this id AList1 [1]2 [1,2]3 [1,2,3]4 [1,2,3,4]But what I see is this id AList1 [1]2 [1,2]3 [1,2,3,3]4 [1,2,3,3,4,4] Why, after the second row, does the value repeat itself twice?

Here are a few things you can do Use java.util.ArrayList (instead of java.util.Collection). While it's advisable to use the latter in programming, in reports, using a concrete class lets you use the classes specific methods (if you use a Collection, you can only use the functions it has, and not the ones specific to a concrete class like Array List)use $V{yourArrayListVariableName}.add($F{FieldToAdd}) to add to your collection.

Your problem is that you are trying to assign a string to a Collection resulting in the error. Here's what will solve it 1. use class="java.util.ArrayList" (instead of Collection, which is an interface) 2. use $V{variable1}.add($F{Programs}) in your variable Expression. What this does is adds the value of INB etc. to the list, instead of trying to assign the string INB to the collection (or ArrayList). That should take care of the class cast error.

Hello, I believe there are three sets of log files for Jasperserver 5.6 1. The tomcat log files in <installation-root>/apache-tomcat/logs/ 2. The jasperserver logs in <installation-root>/apache-tomcat/webapps/jasperserver/WEB-INF/logs/ 3. PostgreSQL log file in <installation-root>/postgresql/postgresql.log Question: Has anyone set up logrotation to rotate these logs? I am assuming these log files will eventually get big and unweildy. Is there anything in Jasperserver to manage the log rotation. Basically, I want to keep 4 weeks worth of log and delete the rest, without having to resort to cron jobs and such. I am using Ubuntu and it has a good logrotate utility, but I am not sure how to use it with jasperserver. Any thoughts on how you've managed your log files would be helpful.