yama818

I was having the same problem. It used to work correctly in the past (at least up to 6.2.0) because it included information about the data source to determine whether to use the cache or not. However, from some version, the decision was made based on SQL only. A patch has been released for the current commercial version 7.5.1, so applying the latest patch should solve the problem. It may also be resolved by upgrading to 7.8.0 or higher. I hope this is helpful.

I thought there might be some useful information in the ServerLog. Try searching for UID '3d4b20ee-b458-4b62-902b-7984ee105eeq'. JasperReports Server Log Files For your reference.

I thought that perhaps this might be useful to you. Timeouts in JasperReports Server For your reference

I changed the input to a json file. - Preview image - Sample source <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 7.5.0.final using JasperReports Library version 6.11.0-0c4056ccaa4d25a5a8c45672d2f764ea3498bebb --><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="W20210727_crosstab" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="df1676c4-d142-482a-87c3-ec841361a022"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="test_json3"/> <property name="com.jaspersoft.studio.unit." value="pixel"/> <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"/> <style name="Crosstab_CH" 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="Crosstab_CG" 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="Crosstab_CT" mode="Opaque" backcolor="#005FB3"> <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="Crosstab_CD" 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> <queryString language="JSON"> <![CDATA[anomalyList]]> </queryString> <field name="GruppiAnomalie" class="java.lang.Integer"> <property name="net.sf.jasperreports.json.field.expression" value="GruppiAnomalie"/> <fieldDescription><![CDATA[GruppiAnomalie]]></fieldDescription> </field> <field name="Code" class="java.lang.String"> <property name="net.sf.jasperreports.json.field.expression" value="Code"/> <fieldDescription><![CDATA[Code]]></fieldDescription> </field> <field name="Name" class="java.lang.String"> <property name="net.sf.jasperreports.json.field.expression" value="Name"/> <fieldDescription><![CDATA[Name]]></fieldDescription> </field> <field name="Class" class="java.lang.Integer"> <property name="net.sf.jasperreports.json.field.expression" value="Class"/> <property name="com.jaspersoft.studio.field.label" value="Class"/> <property name="com.jaspersoft.studio.field.tree.path" value="t6"/> <fieldDescription><![CDATA[Class]]></fieldDescription> </field> <field name="Severity" class="java.lang.String"> <property name="net.sf.jasperreports.json.field.expression" value="Severity"/> <fieldDescription><![CDATA[severity]]></fieldDescription> </field> <field name="Value" class="java.math.BigDecimal"> <property name="net.sf.jasperreports.json.field.expression" value="Value"/> <fieldDescription><![CDATA[Value]]></fieldDescription> </field> <background> <band splitType="Stretch"/> </background> <summary> <band height="283" splitType="Stretch"> <staticText> <reportElement x="0" y="50" width="100" height="21" uuid="8c281303-39bd-456a-bf6b-511bcc71fb3d"/> <box leftPadding="2"/> <textElement verticalAlignment="Middle"/> <text><![CDATA[Class]]></text> </staticText> <staticText> <reportElement x="0" y="70" width="100" height="21" uuid="3a67121c-326b-43ba-bb90-d8c8f04cc9be"/> <box leftPadding="2"/> <textElement verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[Codice Anomalia]]></text> </staticText> <staticText> <reportElement x="0" y="10" width="180" height="30" uuid="1f0196ba-f401-4809-8409-d9ab752f11da"/> <textElement verticalAlignment="Middle"> <font size="16" isBold="true"/> </textElement> <text><![CDATA[Gruppo Anomalie .....]]></text> </staticText> <crosstab> <reportElement x="2" y="50" width="798" height="130" uuid="d529e7c9-8838-4ff3-a819-783a70e85f5d"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.crosstab.style.header" value="Crosstab_CH"/> <property name="com.jaspersoft.studio.crosstab.style.group" value="Crosstab_CG"/> <property name="com.jaspersoft.studio.crosstab.style.total" value="Crosstab_CT"/> <property name="com.jaspersoft.studio.crosstab.style.detail" value="Crosstab_CD"/> </reportElement> <crosstabDataset> <dataset resetType="Report"/> </crosstabDataset> <rowGroup name="Severity" width="100"> <bucket class="java.lang.String"> <bucketExpression><![CDATA[$F{Severity}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents mode="Opaque" style="Crosstab_CH"> <textField> <reportElement x="0" y="0" width="100" height="20" uuid="e56deaa8-0432-4ea8-ae0c-44476ef2e450"/> <box leftPadding="4"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Severity}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents mode="Opaque" style="Crosstab_CT"> <staticText> <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="a9422fc4-9fd4-4af2-bf13-183cf7f50247"/> <text><![CDATA[Total Severity]]></text> </staticText> </cellContents> </crosstabTotalRowHeader> </rowGroup> <columnGroup name="Class" height="20" totalPosition="End"> <bucket class="java.lang.Integer"> <bucketExpression><![CDATA[$F{Class}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents mode="Opaque" style="Crosstab_CH"> <textField> <reportElement x="0" y="0" width="60" height="20" uuid="4998cf69-a4eb-46ea-9571-1252ed35dc1b"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Class}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents mode="Opaque" style="Crosstab_CT"> <staticText> <reportElement x="0" y="0" width="60" height="40" forecolor="#FFFFFF" uuid="e9cd7912-54c5-4822-90aa-d42d46c8ddb4"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <text><![CDATA[%]]></text> </staticText> </cellContents> </crosstabTotalColumnHeader> </columnGroup> <columnGroup name="Code" height="20"> <bucket class="java.lang.String"> <bucketExpression><![CDATA[$F{Code}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents mode="Opaque" style="Crosstab_CH"> <textField> <reportElement x="0" y="0" width="60" height="20" uuid="2d368a8a-100b-4ece-b242-7f7100c8ea41"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Code}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents mode="Opaque" style="Crosstab_CG"> <staticText> <reportElement x="0" y="0" width="60" height="20" uuid="3b9b5b72-0f96-45fd-acfd-df0c708cc295"/> <text><![CDATA[Total Code]]></text> </staticText> </cellContents> </crosstabTotalColumnHeader> </columnGroup> <measure name="Value_MEASURE" class="java.math.BigDecimal" calculation="Sum"> <measureExpression><![CDATA[$F{Value}]]></measureExpression> </measure> <crosstabCell width="60" height="20"> <cellContents mode="Opaque" style="Crosstab_CD"> <textField pattern="0.00"> <reportElement x="0" y="0" width="60" height="20" uuid="945a8120-7e38-474b-9e2a-b90b9e62e0e4"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Value_MEASURE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="60" height="20" columnTotalGroup="Class"> <cellContents mode="Opaque" style="Crosstab_CT"> <textField pattern="0.00"> <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="b0400007-1abd-44c9-9106-f124b32062b4"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Value_MEASURE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="60" height="20" columnTotalGroup="Code"> <cellContents mode="Opaque" style="Crosstab_CG"> <textField> <reportElement x="0" y="0" width="60" height="20" uuid="10cb4cfe-19a4-4a7f-a474-0379b739a9b7"/> <textFieldExpression><![CDATA[$V{Value_MEASURE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="60" height="20" rowTotalGroup="Severity"> <cellContents mode="Opaque" style="Crosstab_CT"> <textField> <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="a46eba72-7a92-4e20-9c0a-9b9437bc93f2"/> <textFieldExpression><![CDATA[$V{Value_MEASURE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="60" height="20" rowTotalGroup="Severity" columnTotalGroup="Class"> <cellContents mode="Opaque" style="Crosstab_CT"> <textField> <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="5345354d-89e0-4d00-b6bd-70f1d5c64343"/> <textFieldExpression><![CDATA[$V{Value_MEASURE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="60" height="20" rowTotalGroup="Severity" columnTotalGroup="Code"> <cellContents mode="Opaque" style="Crosstab_CT"> <textField> <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="5d54a4af-9196-4f78-9732-65eb07429fd9"/> <textFieldExpression><![CDATA[$V{Value_MEASURE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> </crosstab> </band> </summary></jasperReport>I hope this is helpful.

Oh, I was so dumb. I misread MSSQL as MySQL all along. I'm sorry for the confusion. Perhaps the documentation for MSSQL is here. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-source-build-guide/v780/source-build-setup-other-databases --> SQL Server But unfortunately, the Community Edition of 7.8.0 does not have 'sqlserver_master.properties', so this procedure does not seem to work. If I could somehow get '.../buildomatic/sample_conf/sqlserver_master.properties'. Sorry I can't help you.

I also found another document. https://community.jaspersoft.com/project/jasperreports-server/releases --> JasperReports-Server-CP-Install-Guide.pdf --> CHAPTER 3 INSTALLING THE WAR FILE DISTRIBUTION --> 3.2 Applications Supported by the WAR File Distribution --> 3.2.1 Database and Application Server Support --> Database = PostgreSQL,MySQL --> 3.3 Installing the WAR File Using js-install Scripts --> Table 3-1 Sample Values for the default_master.properties File --> Database = MySQL In other words, I thought I could make MySQL the repository DB by editing the 'default_master.properties File' appropriately and installing it. For your reference

The extra code seems to be the default value where the Chart component is placed. I've tried all sorts of nasty manipulations, but I couldn't reproduce it in my Studio (7.5.0). Hmmm. It might be a software glitch, but I couldn't tell.

It's not perfect, but I got this far. - Preview image Here are some additional points that need to be considered - Adding a % column - The order of the rows Also, I tentatively assumed the following way of holding the data. - Sample table - Part of the sample data - Sample source <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 7.5.0.final using JasperReports Library version 6.11.0-0c4056ccaa4d25a5a8c45672d2f764ea3498bebb --><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="W20210727_crosstab" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="df1676c4-d142-482a-87c3-ec841361a022"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="MySQL_44_test"/> <style name="Crosstab_CH" 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="Crosstab_CG" 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="Crosstab_CT" mode="Opaque" backcolor="#005FB3"> <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="Crosstab_CD" 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> <queryString language="SQL"> <![CDATA[select * from t6]]> </queryString> <field name="seq" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.label" value="seq"/> <property name="com.jaspersoft.studio.field.tree.path" value="t6"/> </field> <field name="Class" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="Class"/> <property name="com.jaspersoft.studio.field.tree.path" value="t6"/> </field> <field name="CodiceAnomalia" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="CodiceAnomalia"/> <property name="com.jaspersoft.studio.field.tree.path" value="t6"/> </field> <field name="Grave" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="Grave"/> <property name="com.jaspersoft.studio.field.tree.path" value="t6"/> </field> <background> <band splitType="Stretch"/> </background> <summary> <band height="257" splitType="Stretch"> <crosstab> <reportElement x="0" y="51" width="550" height="180" uuid="08b339f3-c517-477b-8cd4-58b6199e7f7e"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/> <property name="com.jaspersoft.studio.crosstab.style.header" value="Crosstab_CH"/> <property name="com.jaspersoft.studio.crosstab.style.group" value="Crosstab_CG"/> <property name="com.jaspersoft.studio.crosstab.style.total" value="Crosstab_CT"/> <property name="com.jaspersoft.studio.crosstab.style.detail" value="Crosstab_CD"/> </reportElement> <crosstabDataset> <dataset resetType="Report"/> </crosstabDataset> <rowGroup name="Grave" width="100"> <bucket class="java.lang.String"> <bucketExpression><![CDATA[$F{Grave}]]></bucketExpression> </bucket> <crosstabRowHeader> <cellContents mode="Opaque" style="Crosstab_CH"> <textField> <reportElement x="0" y="0" width="100" height="20" uuid="38444ceb-2b49-45be-85cc-53eae5beeefd"/> <box leftPadding="2"/> <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Grave}]]></textFieldExpression> </textField> </cellContents> </crosstabRowHeader> <crosstabTotalRowHeader> <cellContents mode="Opaque" style="Crosstab_CT"> <staticText> <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="d017997e-a0fb-419f-9483-ecdd92484c94"/> <text><![CDATA[Total Grave]]></text> </staticText> </cellContents> </crosstabTotalRowHeader> </rowGroup> <columnGroup name="Class" height="20"> <bucket class="java.lang.String"> <bucketExpression><![CDATA[$F{Class}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents mode="Opaque" style="Crosstab_CH"> <textField> <reportElement x="0" y="0" width="60" height="20" uuid="83e0f1d7-3e3c-4a5a-a044-c563a5d72415"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{Class}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents mode="Opaque" style="Crosstab_CT"> <staticText> <reportElement x="0" y="0" width="60" height="40" forecolor="#FFFFFF" uuid="9501c233-5bfc-4cdf-8842-b9c15ec36ae6"/> <text><![CDATA[Total Class]]></text> </staticText> </cellContents> </crosstabTotalColumnHeader> </columnGroup> <columnGroup name="CodiceAnomalia" height="20"> <bucket class="java.lang.String"> <bucketExpression><![CDATA[$F{CodiceAnomalia}]]></bucketExpression> </bucket> <crosstabColumnHeader> <cellContents mode="Opaque" style="Crosstab_CH"> <textField> <reportElement x="0" y="0" width="60" height="20" uuid="291850ad-65f3-407a-9c94-3922d70ca358"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{CodiceAnomalia}]]></textFieldExpression> </textField> </cellContents> </crosstabColumnHeader> <crosstabTotalColumnHeader> <cellContents mode="Opaque" style="Crosstab_CG"> <staticText> <reportElement x="0" y="0" width="60" height="20" uuid="518b1fea-7104-48a7-b501-4649842e1b1a"/> <text><![CDATA[Total CodiceAnomalia]]></text> </staticText> </cellContents> </crosstabTotalColumnHeader> </columnGroup> <measure name="seq_MEASURE" class="java.lang.Integer" calculation="Count"> <measureExpression><![CDATA[$F{seq}]]></measureExpression> </measure> <crosstabCell width="60" height="20"> <cellContents mode="Opaque" style="Crosstab_CD"> <textField> <reportElement x="0" y="0" width="60" height="20" uuid="732ac6d1-1422-48e0-8fa8-31b1f6364392"/> <textElement textAlignment="Center" verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{seq_MEASURE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="60" height="20" columnTotalGroup="Class"> <cellContents mode="Opaque" style="Crosstab_CT"> <textField> <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="eb7fe51e-c2d9-444b-9e80-573a88053a06"/> <textFieldExpression><![CDATA[$V{seq_MEASURE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="60" height="20" columnTotalGroup="CodiceAnomalia"> <cellContents mode="Opaque" style="Crosstab_CG"> <textField> <reportElement x="0" y="0" width="60" height="20" uuid="a716aa6c-39ae-47c9-8e68-49c5c6223eac"/> <textFieldExpression><![CDATA[$V{seq_MEASURE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="60" height="20" rowTotalGroup="Grave"> <cellContents mode="Opaque" style="Crosstab_CT"> <textField> <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="7127fc87-7037-44fc-894e-b4d758585da5"/> <textFieldExpression><![CDATA[$V{seq_MEASURE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="60" height="20" rowTotalGroup="Grave" columnTotalGroup="Class"> <cellContents mode="Opaque" style="Crosstab_CT"> <textField> <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="d2db2e47-8734-4f30-bb36-776a961abef5"/> <textFieldExpression><![CDATA[$V{seq_MEASURE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> <crosstabCell width="60" height="20" rowTotalGroup="Grave" columnTotalGroup="CodiceAnomalia"> <cellContents mode="Opaque" style="Crosstab_CT"> <textField> <reportElement x="0" y="0" width="60" height="20" forecolor="#FFFFFF" uuid="7c873d7b-79dc-4c74-9636-c721156e7b72"/> <textFieldExpression><![CDATA[$V{seq_MEASURE}]]></textFieldExpression> </textField> </cellContents> </crosstabCell> </crosstab> <staticText> <reportElement x="0" y="50" width="100" height="21" uuid="8c281303-39bd-456a-bf6b-511bcc71fb3d"/> <box leftPadding="2"/> <textElement verticalAlignment="Middle"/> <text><![CDATA[Class]]></text> </staticText> <staticText> <reportElement x="0" y="70" width="100" height="21" uuid="3a67121c-326b-43ba-bb90-d8c8f04cc9be"/> <box leftPadding="2"/> <textElement verticalAlignment="Middle"> <font isBold="true"/> </textElement> <text><![CDATA[Codice Anomalia]]></text> </staticText> <staticText> <reportElement x="0" y="10" width="180" height="30" uuid="1f0196ba-f401-4809-8409-d9ab752f11da"/> <textElement verticalAlignment="Middle"> <font size="16" isBold="true"/> </textElement> <text><![CDATA[Gruppo Anomalie .....]]></text> </staticText> </band> </summary></jasperReport> I hope this is helpful.

I have not tried this, but the following document may be helpful. Building JasperReports Server Source Code --> Configuring the Buildomatic Properties --> MySQL For your reference

I know this is a little different from your requirement, but you can make the value of promptA the display condition for promptB. Cascading Input Controls For your reference

I thought there might be some useful information in the ServerLog. You may want to search by UID of ErrorMessage. JasperReports Server Log Files For your reference.

Check if the checkbox to skip the first line is checked in the data adapter settings of the csv file. If it is not checked, check it. However, even if you overcome this error, an error will occur at the next "CollectedTime". Net.sf.jasperreports.engine.JRException: Unable to get value for CSV field "CollectedTime" of class java.sql. The problem seems to be caused by the classType of "CollectedTime" being 'java.sql.Time'. I tried to solve the problem as follows, but I'm not sure if it's the right way. 1. Change the classType of "CollectedTime" in the data source to 'java.lang.String'. 2. Create a new variable with a classType of 'java.lang.String'java.util.Date'. 3. Write "new SimpleDateFormat("MMM d, yyyy hh:mm:ss a").parse($F{CollectedTime})" in the expression of the new variable. 4. Replace "CollectedTime" with a new variable for the chart X axis. I hope this is helpful.

I don't think I can fully meet your requirements, but the first idea I came up with is a way to arrange the List components. - Preview image - Layout design image - List component properties - Parameter setting image - Dataset SQL image select * from t1 where prod = $P{P_prod} I think it can also be achieved by using Table component or arranging sub-reports. I hope this is helpful.

I will tell you that I may not understand your requirements. In the following SQL case, if a value is entered for the single value parameter 'P_City', the data will be retrieved with the entered condition. If no value is entered for the single value parameter 'P_City', all data will be retrieved. Select * from sales where (City=$P{P_City}) or ($P{P_City} is null)[/code] If 'P_City' is a multi-valued parameter (Class=java.util.Collection) instead of a single-valued parameter (Class=java.lang.String), then the SQL will look like this Select * from sales where $X{IN, City, P_City}[/code] I hope this is helpful.

If you want to know the basic way to use parameters in Studio's SQL, the following wiki may help you understand. https://community.jaspersoft.com/wiki/using-report-parameters-jaspersoft-studio You will need to see the manual for more detailed information. https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v790/using-parameters-queries I hope this is helpful.

If I were to investigate, I would first look at the SQL issued by the AdHoc View. https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v790/configuring-ad-hoc#Query_Settings --> Ad Hoc Query Settings > Configure View Query After that, check if this SQL is Teiid compliant. https://docs.jboss.org/teiid/7.7.0.Final/reference/en-US/html/index.html I hope this is helpful.

I thought there might be some useful information in the ServerLog. JasperReports Server Log Files For your reference.

Let me tell you that I may not have understood your requirement. I have solved this before by auto-pressing the standard reload button from javascript embedded in the report. Note that it is not picked up by the 'click' event, but by the 'mouseup'. var mouseupEvent = new Event('mouseup');document.getElementById('dataRefreshButton').dispatchEvent(mouseupEvent);[/code]Also, depending on the version of JRS, it may not work. The JRS I had success with was JRS 6.4.2. I hope this helps.

---------- BUILD FAILED C:jasperjasperreports-6.17.0demohsqldbbuild.xml:6: Problem: failed to create task or type antlib:org.apache.ivy.ant:configure Cause: The name is undefined. Action: Check the spelling. Action: Check that any custom tasks/types have been declared. Action: Check that any <presetdef>/<macrodef> declarations have taken place. No types or tasks have been defined in this namespace yet This appears to be an antlib declaration. Action: Check that the implementing library exists in one of: -C:apache-antapache-ant-1.10.10lib -C:Usersxxxxxxxxxx.antlib -a directory added on the command line with the -lib argument Total time: 0 seconds ---------- It was resolved when I downloaded apache-ivy-2.5.0-bin.zip from http://ant.apache.org/ivy/, unzipped it, and copied ivy-2.5.0.jar to <ANT_HOME>lib. I don't know if this is the correct solution.

This may not be the best way to do it, but I was able to achieve this by using the table component. Tie a new dataset to the table component and write SQL to return only one item in this dataset. ex) select email from email_table where id = $P{xxxx} preview image Design image I hope this is helpful.

It seems to be possible by setting the following in the text field properties. This may not be available in all versions of Studio. My Studio version is 7.5.0. preview image

If you can, can you attach the jrxml file? I might notice something else in it.

This is just a guess. The three numeric items that exist in the table item, in your screenshot it looks like they are set to Bold. If you set them here, they would take precedence over Style, so I guess all the rows are set to Bold. If your guess is correct, then remove the setting from the 'Inheritance' tab. Hover your mouse over the item and click on the red mark. ↓

It seems I did not understand your requirements. Here is what I tried for your reference. - Preview Image - style design - table degign * Changed seqno2 to Integer type, so some of the expressions have been changed. * I have added a modifier in red to make the style change easier to understand. I hope this is helpful.

The test source for me is as follows. The first text field is an example of String type. The second text field is an example of Integer type. I hope it helps. <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 7.5.0.final using JasperReports Library version 6.11.0-0c4056ccaa4d25a5a8c45672d2f764ea3498bebb --><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="W20210612_table" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="6fda6c7f-be6e-44f5-9943-ed910d06adb9"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="MySQL_44_test"/> <queryString language="SQL"> <![CDATA[select 2020 year_str ,2020 year_int from dual]]> </queryString> <field name="year_str" class="java.lang.String"> <property name="com.jaspersoft.studio.field.label" value="year_str"/> </field> <field name="year_int" class="java.lang.Integer"> <property name="com.jaspersoft.studio.field.label" value="year_int"/> </field> <summary> <band height="148" splitType="Stretch"> <textField> <reportElement x="0" y="20" width="550" height="30" uuid="d8fba6e4-bc55-4bfc-ba49-f2d9a61282d8"/> <textElement> <font size="19"/> </textElement> <textFieldExpression><![CDATA[$F{year_str} + "/"+(Integer.parseInt($F{year_str})+1)]]></textFieldExpression> </textField> <textField> <reportElement x="0" y="80" width="550" height="30" uuid="6a14145e-955c-4c1f-b84e-b7224d7b3b11"/> <textElement> <font size="19"/> </textElement> <textFieldExpression><![CDATA[$F{year_int} + "/"+($F{year_int}+1)]]></textFieldExpression> </textField> </band> </summary></jasperReport>