danielobs

Unfortunately I not found a solution :(

Unfortunately no :(

Hi, I have problem with install Jasperserver 5.2.0 CE on Debian. Screen of installation: Installing 0% ______________ 50% ______________ 100% ######################################### Warning: Problem running post-install step. Installation may not complete correctly Error running /opt/jasperreports-server-cp-5.2.0/postgresql/bin/createuser -U postgres -p 5432 -h 127.0.0.1 -D -R -S jasperdb : createuser.bin: could not connect to database postgres: could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? Press [Enter] to continue : Warning: Problem running post-install step. Installation may not complete correctly Error running /opt/jasperreports-server-cp-5.2.0/apache-ant/bin/ant import-minimal-ce : BUILD FAILED /opt/jasperreports-server-cp-5.2.0/buildomatic/bin/import-export.xml:270: The following error occurred while executing this line: /opt/jasperreports-server-cp-5.2.0/buildomatic/bin/import-export.xml:144: The following error occurred while executing this line: /opt/jasperreports-server-cp-5.2.0/buildomatic/bin/validation.xml:370: The following error occurred while executing this line: /opt/jasperreports-server-cp-5.2.0/buildomatic/conf_source/db/postgresql/db.xml:5 8: The following error occurred while executing this line: /opt/jasperreports-server-cp-5.2.0/buildomatic/bin/validation.xml:428: The following error occurred while executing this line: /opt/jasperreports-server-cp-5.2.0/buildomatic/bin/validation.xml:464: Database doesn't exist. Treating problem with JDBC connection as unrecoverable Total time: 1 second Press [Enter] to continue : ---------------------------------------------------------------------------- Setup has finished installing JasperReports Server CP 5.2.0 on your computer. Afrer running ctlscript.sh is error: root@debian:/tmp# /opt/jasperreports-server-cp-5.2.0/ctlscript.sh start LOG: database system was shut down at 2013-08-16 11:55:46 CEST LOG: database system is ready to accept connections LOG: autovacuum launcher started /opt/jasperreports-server-cp-5.2.0/postgresql/scripts/ctl.sh : postgresql started at port 5432 Using CATALINA_BASE: /opt/jasperreports-server-cp-5.2.0/apache-tomcat Using CATALINA_HOME: /opt/jasperreports-server-cp-5.2.0/apache-tomcat Using CATALINA_TMPDIR: /opt/jasperreports-server-cp-5.2.0/apache-tomcat/temp Using JRE_HOME: /opt/jasperreports-server-cp-5.2.0/java Using CLASSPATH: /opt/jasperreports-server-cp-5.2.0/apache-tomcat/bin/bootstrap.jar /opt/jasperreports-server-cp-5.2.0/apache-tomcat/scripts/ctl.sh : tomcat started root@debian:/tmp# FATAL: password authentication failed for user "jasperdb" FATAL: password authentication failed for user "jasperdb" FATAL: password authentication failed for user "jasperdb" How to solve this problem? Kind regards, Daniel

Hi, I have problem with Multi-select List of Values with dynamic sql: SQL is: SELECT distinct a.KONTRAHENT, k.NAZWA, k.NAZWA2, k.ULICA, k.MIASTO, k.KODP, k.NIP from nrlog as a left join kontra as k on a.kontrahent=k.kontrahent where a.kontrahent>0 and a.data_log>=$P!{DATE_FROM} and a.data_log<=$P!{DATE_TO} Parameters are: $P!{DATE_FROM} and $P!{DATE_TO} These Imput Control are located above the dynamic list. Unfortunately, the SQL does not generate me a list. Static SQL working properly: SELECT distinct a.KONTRAHENT, k.NAZWA, k.NAZWA2, k.ULICA, k.MIASTO, k.KODP, k.NIP from nrlog as a left join kontra as k on a.kontrahent=k.kontrahent where a.kontrahent>0 and a.data_log>='20130101' and a.data_log<='20130116' I use MySQL database and JasperServer 5. How to display content in JasperServer 5 SQL query for the Multi-select List of Values Best regards, Daniel

Thank you for your help. This is a good solution for me. Maybe someone knows even better. :)

Landscape format is not the solution of this problem. This is only a temporary solution.

Parameter names are matching. The problem is with the format of the date. But I do not know why.

In iReport all is ok. After set pattern the date is wrong when report is generating in Jasperserver. . In addition, the data generated by the SQL they are wrong. Out of this period we need.

Hi, I have problem with sent data parameter to report. Parameter is data format: on input control is: 04-03-2012 but on the raport is: 12-01-04 00:03 See the attached picture Best regards, Daniel

Hi, Is there any way to display the report on the full width of the screen in JasperServer 5? Best regards, Daniel

Hi, In JasperServer 5 I have an interface in my native language. Unfortunately, I have a calendar in English. Which file is responsible for the interface language calendar? Best regards, Daniel

Hi, In report I havv parameter java.util.Collection I use it with Input Control "Multi-select List of Values" and all is OK. Now I'd like to read from a variable of type java.util.Collection to its last value and use in : "Print When Expression". How to read the value of the last position in parameter in type java.util.Collection ? Best regards, Daniel

Hi, It is possible to made in Ireport the "dynamic" SQL. In JasperServer I have parameter "fields" (java.util.Collection), which contains a numbers of fields which are to be use in the SQL to aggregation of data. When in filds parameter is : "1","2","3" the SQL should look like: SELECT P1 as NAME1, P2 as NAME2, P3 as NAME3, SUM(PRICE) FROM TABLE_1 GROUP BY P1, P2, P3 and when in filds parameter is : "1","2" the SQL should look like: SELECT P1 as NAME1, P2 as NAME2, SUM(PRICE) FROM TABLE_1 GROUP BY P1, P2 and next examples : "1","4" = SELECT P1 as NAME1, P4 as NAME2, SUM(PRICE) FROM TABLE_1 GROUP BY P1, P4 and next examples : "4","1","3" = SELECT P4 as NAME1, P1 as NAME2, P3 as NAME3, SUM(PRICE) FROM TABLE_1 GROUP BY P4, P1, P3 Dynamic text is needed after SELECT and after GROUP BY. It is posible made text of SQL dynamically according input parameters? Best regards, Daniel

Hi, Thank you for the information but maybe someone knows a better solution because it is good but a temporary solution. Best regards, Daniel

Hi, The screen of the report after the generation looks like this: jasper-sample.jpg Is it possible that after generating the report is biger ? This size is not comfortable to read. Best regards, Daniel