av-mihailov Posted July 24, 2020 Share Posted July 24, 2020 If I use jasper reports functions with dataset I have an error: "net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression for source text: LEN($F{Field_1})".If I don't use dataset report works.Why reports don't work with functionts & dataset and how I can fix it?<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.13.0.final using JasperReports Library version 6.13.0-46ada4d1be8f3c5985fd0b6146f3ed44caed6f05 --><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="Blank_A4" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="51f620da-6991-46a6-ad13-631cb8b5ee83"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="TestDA"/> <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="Dataset1" uuid="c632fcbe-adff-4ac5-9aa2-7c30b90be897"> <queryString language="jsonql"> <![CDATA[]]> </queryString> <field name="Field_1" class="java.lang.String"> <property name="net.sf.jasperreports.jsonql.field.expression" value="..code.coding.code"/> </field> <field name="Field_2" class="java.lang.String"> <property name="net.sf.jasperreports.jsonql.field.expression" value="..code.coding.display"/> </field> </subDataset> <queryString language="jsonql"> <![CDATA[]]> </queryString> <field name="Field_1" class="java.lang.String"> <property name="net.sf.jasperreports.jsonql.field.expression" value="..authoredOn"/> </field> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"> <textField> <reportElement x="60" y="30" width="100" height="30" uuid="4f4d100b-fcbf-4807-8f9f-44a1caf1539b"/> <textFieldExpression><![CDATA[LEN($F{Field_1})]]></textFieldExpression> </textField> </band> </title> <detail> <band height="245" splitType="Stretch"> <componentElement> <reportElement x="30" y="20" width="200" height="200" uuid="a24a68c6-6662-4c9b-bf20-0a0782410e21"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/> </reportElement> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <datasetRun subDataset="Dataset1" uuid="3e7dd961-ede0-4307-af01-196291a64630"> <dataSourceExpression><![CDATA[((net.sf.jasperreports.engine.data.JsonQLDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("entry.resource(resourceType=="Observation")")]]></dataSourceExpression> </datasetRun> <jr:column width="50" uuid="95181416-82fd-495b-a885-70a3b2f7f414"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <jr:tableHeader style="Table_TH" height="30" rowSpan="1"/> <jr:tableFooter style="Table_TH" height="30" rowSpan="1"/> <jr:columnHeader style="Table_CH" height="30" rowSpan="1"/> <jr:columnFooter style="Table_CH" height="30" rowSpan="1"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="50" height="30" uuid="0ecc44f6-4e70-4d00-b7be-b89868702dca"/> <textFieldExpression><![CDATA[$F{Field_1}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="110" uuid="c764879f-21d7-4f51-ac1c-a7bef8a64ec0"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> <jr:tableHeader style="Table_TH" height="30" rowSpan="1"/> <jr:tableFooter style="Table_TH" height="30" rowSpan="1"/> <jr:columnHeader style="Table_CH" height="30" rowSpan="1"/> <jr:columnFooter style="Table_CH" height="30" rowSpan="1"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="110" height="30" uuid="fdaa056f-b062-432d-8ea6-24277757a64a"/> <textFieldExpression><![CDATA[$F{Field_2}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </band> </detail></jasperReport> Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now