MikeM19

Hi hozawa, I do understand that, maybe my mistake by not explaining myself in a better way, there is any way i can solve that from a jasper server or BD perspective? any clean up option from jasper? any script i can run? Regards!

Hello experts, I'm having an issue while trying to run a report from my jasper reports server with Postgresql DB, when i try to execute it the error below appear: I understand this can be a database problem, can you please put me on the right direction about how to solve this since my database knowledge is not that awesome? Best regards!

Hello, Here is the message, the weird thing here is that sometimes the email notification is sended and some other not, any idea about it before trying to troubleshoot the connection to email server?

Hi experts, I'm having an issue with the report scheduler on Jasperserver, is a strange behavior specifically with the email functionality, i have configured a Job to create and send a very simple report, the file is being created all the times but the email notifications sometimes is being send and some other not, there is no configuration changes on the job, same destination address, same time, same file etc, does anyone had experienced this issue before? any idea why this can be happening? Regards!

Thanks both for your responses, it seems to be an issue with a OS or IE security update, i noted that Windows update ran after the issue appears so i executed a system restore and the jasper login page is normally showing once again, i'll try to find out exactly which KB is causing the issue and will post it here for reference. Thanks!

Hi experts, We are having an issue, last week everything was working fine with our Jasperreports server but today suddenly we are not able to see the login page, we get a "this page cannot be displayed" error on IE, if i run the network diagnostics tool say that the web server may not be availbale and it cannot establish a secure connection, the thing is that if i use google chrome everything is working fine with our server, any ideas about this will be very appreciated. Regards!

Any other idea about this?

Hi, Thanks both for your responses, our jasperserver is running under a linux server, i just turn off the firewall but still getting the same error, i tried to using the port 25 but still no success, any other ideas about this? Regards!

Hi experts, I'm dealing with an issue while trying to schedule a report with email notification with jasper server 5.1, i already had configured the js.quartz.properties file and applicationContext-report-scheduling as the guide says but i'm getting the error shown below: The mentioned files are configured as shown: Any help will be appreciated. Regards!

Thanks for your answer, i've been trying with 5.1 but no success at all, do you know if the 6.2.1 community version is able to do it? if thats true i can start planning the upgrade. regards!

Hi experts, I just want to know if JasperServer 5.1 have the capability to send automatically reports over Email, i was doing some research on this and i found the configuration on the js.quartz.properties file but i just want to be sure that the 5.1 version is able to do that, can you help me here? i'll appreciate any comment. Regards!

Thanks again hosawa, i will review the information about it. Regards!

Thanks for your answer but i cannot find that propertie on the file, any othe idea? regards!

Hello Guys, I need to know if there is a way to schedule a report to run and export it to a shared folder on another computer not the one where jasperserver is installed, i can succesfully schedule the report to run but i'm stuck in the export part, somebody can help me here? i'm using Ireports 5.6 and jasper reports server 5.1. Regards!

Thanks again hozawa, i just did that and it works. Regards!

Hello, I just created a new report, includes 3 table elements with a different dataset with different querys, the 3 tables fields are totally aligned so when i make the excel exportation appers fine, each field on one column for the 3 tables, the problem i'm facing now is that there are some duplicated rows because the 3 database tables have some repeated values and i understand is natural to happen this, but there is anyway to avoid that? i mean how can i be sure that the report does not print duplicated values? any validation? i already tried with the print repeated values but is not working, i hope any of you guys can give a hand here. Regards!

Yes i'm working with Ireports 5.6 and JR Server 5.1, i'll check the logs and look for the error, thank you hosawa for the clue about this issue. Regards!

Hello guys, I'm dealing with an issue with my jasper server, i'm trying to upload a new jrxml file, but when i'm creating the new input control the server is giving me this message: "The server has encountered an error. Please excuse the inconvenience. An error has occurred. Please contact your system administrator. (5321)" The input control i'm trying to create is a multiple selection check box, the error appear when i try to add the first value for the list, the values have no special characters is just text and the parameter in Ireports is a Java.util.collection, i just tried with another report but the issue remains, just a few days ago i was able to do that without a problem but now i'm dealing with this, i will appreciate any idea about this. Regards!

Thanks you both, What i did to make this work was to use the expression "new Date($F{my_field}.getTime() - 5 * 3600*1000)" on the text field expression propertie and it totally works, thanks to asimkin and hozawa for putting me on the right way on this one. Best regards!

Thank you both for your answers, Asimkin, I tried with your expression but there is no change, i use it on the Text field expression, is that ok? any additional thing i must do? Hozawa, I'm pretty new with Ireports, i really don't know where to implement your suggestion, can you give more details about it? Best regards!

Hello guys, I'm running a report where i'm extracting from my db a java.sql.timestamp field, is there any way to decrease the hour part? i mean if i have a "04/09/15 07:24 PM" how can i convert it to "04/09/15 02:24 PM", i hope someone around can help me with this. Regards!

You're welcome dimdimitrako, i'm glad to know i was useful on this one. Regards!

Hello dimdimitrako, A few days ago i was working on a report that allow me write some coma separated values in jasperserver, what i did was create a new string input control in jasperserver, this one is where you wiill write you separated values, then i had to create a couple of parameters in ireports, lets say parameter1 as java.util.List with the default value expression defined like Arrays.asList($P{Parameter2}.split(",")), the parameter2 is a java.lang.String type. The created input control on jasperserver have to be linked to parameter2 where you will receive the string with the coma separated values, now with the Arrays.asList($P{Parameter2}.split(",")) you will separate your original string where the "," is found and fill the list parameter that you can use within your query. I hope this can be useful to you. Regards!

Hi community, I have a question, i need to extract some attributes from multiple XML files, the attributes are the same on everyone of them and the position within the files is also the same, is there any way to do this in Ireports? i can extract the information from one file in a very easy way but i don't know if it's possible to do it from multiple files at the same time, i hope someone around have a clue about this. Regards!

Hello kmg, I was dealing with this issue and i just did what you suggest but there is no success, i'm getting this error on Ireports preview option, i'm entering a couple of coma separated values and just getting this error, any advice? Error filling print... Error executing SQL statement for : PruebaError net.sf.jasperreports.engine.JRException: Error executing SQL statement for : PruebaError at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1114) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1314) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:931) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:873) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:287) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:760) 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.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'BR'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233) Best regards!