dirk.wouters

Running my report on the server causes shifting text in the preview screen (see print screen below). As a result the column layout is lost. Exporting to pdf gives a perfect result. Are there some suggestions?

Changing the visible columns does not have any effect. I 've used the "$P{}" before without problems and in this case '$X{}' is not applicable.

I use a cascading input query: SELECT account_analytic_account.code, account_analytic_account.namefrom project_projectLEFT JOIN account_analytic_account ON account_analytic_account.id = project_project.analytic_account_idwhere account_analytic_account.company_id = $P{company} and substr(account_analytic_account.code,1,2) = 'P-'order by account_analytic_account.code[/code]In the input control appears only one row. If I run the query against the database it gives hundreds of rows. What is happening here?

Is it possible to use a default locale at login? We use jasperserver 7.1.

Problem found with extendend logging log4j.logger.org.springframework.security=DEBUG, stdout, fileout[/code]

External Database Authentication was working on version 6.3 but after upgrade to 7.1 the user logins are refused without logging. What can be wrong or how I can see more logs for External Database Authentication?

The configuration as described in https://community.jaspersoft.com/wiki/installing-webservice-datasource causes the application not starting for Jasper Server 7.1.

I am using Jasperserver 6.4 and configured the applicationContext-externalAuth-db-mt.xml file with: <bean id="passwordValidator" class="com.jaspersoft.jasperserver.api.metadata.common.service.impl.PasswordValidator" lazy-init="false"> <property name="keyInPlainText"><value>false</value></property> <property name="secretKey"><value>0xC8 0x43 0x29 0x49 0xAE 0x25 0x2F 0xA1 0xC1 0xF2 0xC8 0xD9 0x31 0x01 0x2C 0x52 0x54 0x0B 0x5E 0xEA 0x9E 0x37 0xA8 0x61</value></property> <property name="secretKeyAlgorithm"><value>DESede</value></property> <property name="cipherTransformation"><value>DESede/CBC/PKCS5Padding</value></property> </bean>[/code]In the logging I get the next messages: 2017-10-30 11:51:50,084 DEBUG JSDriverManagerDataSource,http-nio-8080-exec-6:162 - Creating new JDBC DriverManager Connection to [jdbc:postgresql://192.168.1.218:5432/database]2017-10-30 11:51:50,112 DEBUG JSDaoAuthenticationProvider,http-nio-8080-exec-6:86 - Authentication failed: password does not match stored value[/code]The database where I connect to contains a MD5 hashed password. How can I get it working?

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.1.1.final using JasperReports Library version 6.1.1 --><!-- 2016-11-04T09:09:05 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="sub percelen in erkende perimeters" printOrder="Horizontal" pageWidth="200" pageHeight="100" columnWidth="200" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isIgnorePagination="true" uuid="7b45ae02-0d94-4d6d-81f9-6534db6f51f6"> <property name="com.jaspersoft.studio.unit." value="pixel"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Reservatendatabank"/> <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/> <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/> <parameter name="polygoon" class="java.lang.Object"/> <queryString language="SQL"> <![CDATA[select percentage,resnr,resnaam,beheerder from planning.in_erkende_perimeter($P{polygoon})]]> </queryString> <field name="percentage" class="java.lang.Double"/> <field name="resnr" class="java.lang.String"/> <field name="resnaam" class="java.lang.String"/> <field name="beheerder" class="java.lang.String"/> <variable name="samen" class="java.lang.String"> <variableExpression><![CDATA[LEN($V{samen}) == 0 ? new java.text.DecimalFormat("##0").format($F{percentage}) + "% " + $F{resnr} + " " + $F{resnaam} + " " + $F{beheerder} + "n" : $V{samen} + new java.text.DecimalFormat("##0").format($F{percentage}) + "% " + $F{resnr} + " " + $F{resnaam} + " " + $F{beheerder}]]></variableExpression> <initialValueExpression><![CDATA[""]]></initialValueExpression> </variable> <detail> <band height="15" splitType="Stretch"> <property name="local_mesure_unitheight" value="pixel"/> <printWhenExpression><![CDATA[false]]></printWhenExpression> <textField> <reportElement x="30" y="0" width="30" height="15" uuid="a9023381-4f87-405a-b9ed-69e779e5423a"/> <textFieldExpression><![CDATA[$F{resnr}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement stretchType="RelativeToBandHeight" x="60" y="0" width="100" height="15" uuid="f3028648-9a69-49c3-894f-18e563471a6d"/> <textFieldExpression><![CDATA[$F{resnaam}]]></textFieldExpression> </textField> <textField> <reportElement x="160" y="0" width="40" height="15" uuid="9068c1bc-6e0a-4a62-b118-fa1b8c35a60c"/> <textFieldExpression><![CDATA[$F{beheerder}]]></textFieldExpression> </textField> <textField pattern="#,##0.00#"> <reportElement x="0" y="0" width="30" height="15" uuid="908e7cf6-197f-4b96-8c36-1f0368b3c67a"/> <textFieldExpression><![CDATA[$F{percentage}]]></textFieldExpression> </textField> </band> </detail> <summary> <band height="14"> <textField isStretchWithOverflow="true"> <reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="200" height="14" uuid="2042104c-6864-419d-a8ab-5a57608c8dea"/> <textFieldExpression><![CDATA[$V{samen}]]></textFieldExpression> </textField> </band> </summary></jasperReport>[/code]This is the code from the subreport which causes the error. Using the $P!{} syntax doesn't work at all. I have maybe a special parameter because it is a Postgis geometry format which I have defined as a java.lang.object class.

I have a main report with some subreports. If the result set is not so big it works fine. When the result set increases I get the next message: net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query: select percentage,resnr,resnaam,beheerder from planning.in_erkende_perimeter(?) The query mentioned in this error message is used in one of the subreports. Is there somewhere a limitation involved?

In the jrxml $V{Projectgebieden} is above $V{provincie}.

If I use in a text field it displays fine. When I do the same in a variable it displays always null. How to get this variable working?

I have changed the overrides_custom.css with the following lines ._jrHyperLink { text-decoration: underline; color: #0000EE; } /* unvisited link */ ._jrHyperLink:link { color: #0000FF; } /* visited link */ ._jrHyperLink:visited { color: #800080; } /* mouse over link */ ._jrHyperLink:hover { color: #FF00FF; } /* selected link */ ._jrHyperLink:active { color: #FF0000; } but nothing happens.

With code inspection in the web browser for jasperserver 5.6 there is a html anchor to a hyperlink. At jasperserver 6.1 I see a class="-jrHyperlink Reference". How does that work?

I have a report with hyperlinks and it is presented fine at a jasperserver 5.6 (text turns blue and becomes underlined when hoovered). When I put the same report at a jasperserver 6.1 the hyperlink is not formatted at all, the text stays black and no reaction when hoovered). What is changed in the jasperserver version?

I have a master report with in each record line a subreport which uses another datasource. If there are more then 100 records I get an error message for too many connections (= datasource of the subreport). Here is the code: Is there a way to explicitly close the collection after each time the subreport is called?

I have a report with a group section with some calcultations in the footer of this group. At het end of the report I want to present a kind of overview of all these calculated results in a table. What is the best technique to implement this? I use Jaspersoft Studio 6.0 Thanks for the advice.