jgust

You should update SQL Server to enable TLS1.2. https://stackoverflow.com/questions/69623611/how-do-i-allow-java-client-tls10-connections

If you cannot find the field on the design tab or in the Outline then your next best option is to do a text search on the source. From the screenshot, it looks like you can do a search on "Pag.".

You cannot display data twice unless it exists twice. What you can do is update your dataset and UNION the results to itself. During that process, you may want to add a hardcoded column like REC_TYPE to help you identify where the data should print. select 'top' as REC_TYPE, field1, field2 from My_Tableunionselect 'bottom', field1, field2 from My_Table [/code]

Here is a low-effort way to create a CSV-designed report 1. Create a new blank report. 2. Modify the page format to be Ledger Landscape (you want as much canvas space as possible) 3. Click on the Detail band and change the layouts to "Spreadsheet Layout" 4. Repeat step 3 for the Column Header band. 5. Repeat step 3 for the Title band 6. Drag the fields from the Outline to the Detail band 7. Move the auto-created static text fields from the Column Header band to the Title Band 8. Delete the Column Header band 9. Run and export the report as CSV 10. Profit The report canvas should look something like this on the design tab The width and depth are of no concern to the CSV export format. This is hard to read but you can use the Outline to find and select fields if modifications are needed.

You can move the title to each subreport and then suppress it if the title has already been printed. To identify if it has already been printed for each subreport pass a flag (vTitleHasPrinted) back to the main report. Then pass that flag to each subsequent subreport.

The composite elements are simply text fields with the appropriate expression. Once you put them on the canvas, you can change the attributes to meet your needs. Since you mentioned that you have many subreports will say that the $V{PAGE_NUMBER} that is used by the page number and total pages does not take the space of subreports into consideration. You will need to use $V{MASTER_CURRENT_PAGE} and $V{MASTER_TOTAL_PAGES} then set the evaluation time to "Master". Page N of M Expression: "Page " + TEXT($V{MASTER_CURRENT_PAGE}, "#,###") + " of " + TEXT($V{MASTER_TOTAL_PAGES}, "####") Evaluation Time: Master Page N Expression: "Page " + TEXT($V{MASTER_CURRENT_PAGE}, "#,###") Evaluation Time: Master 2/22/2023 Thanks for the follow-up. I see you are using code, not Jasper Studio, to create the jrxml file. The solution is the same. I will follow up by providing the jrxml of my page header and displaying the expression editor. Page Header <pageHeader> <band height="56" splitType="Stretch"> <staticText> <reportElement x="265" y="1" width="222" height="34" uuid="27d6c2b1-30b7-4704-a78a-45b5eae41c9e"/> <textElement textAlignment="Center"> <font fontName="Arial" size="18" isBold="true"/> </textElement> <text><![CDATA[Example of Summaries]]></text> </staticText> <textField evaluationTime="Master"> <reportElement x="519" y="12" width="233" height="13" uuid="b9164ec1-ad06-4dae-b0ce-3e8151779813"> <property name="com.jaspersoft.studio.unit.y" value="px"/> </reportElement> <textElement textAlignment="Right"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA["Page " + TEXT($V{MASTER_CURRENT_PAGE}, "#,###") + " of " + TEXT($V{MASTER_TOTAL_PAGES}, "####")]]></textFieldExpression> </textField> <textField evaluationTime="Auto" pattern="EEEE MM/dd/yyyy h:mm a"> <reportElement x="522" y="1" width="230" height="12" uuid="f568815e-b548-4679-baa5-91cc04c62f18"/> <textElement textAlignment="Right"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> </band> </pageHeader>[/code]Expression Editor There are 7 default variables that every report has access to (PAGE_NUMBER, MASTER_CURRENT_PAGE, MASTER_TOTAL_PAGE, COLUMN_NUMBER, REPORT_COUNT, PAGE_COUNT, and COLUMN_COUNT). You can see those in the expression editor below.

Assuming the SQL is correct you should provide an alias for each column by adding "as" followed by the alias name. select convert(varchar(10), MIN(DateBeginPeriod), 103) as StartDate , convert(varchar(10), MAX(DateEndPeriod), 103) as EndDatefrom UnmeteredConsumption[/code]

The issue is that $V{PAGE_NUMBER} does not account for sub-reports. You will need to update the page number expression and use the $V{MASTER_CURRENT_PAGE} and $V{MASTER_TOTAL_PAGES} built-in variables. Also, set the evaluation time on that expression to Master. <textField evaluationTime="Master" isBlankWhenNull="true"> <reportElement x="760" y="12" width="150" height="13" forecolor="#000000" backcolor="#FFFFFF" uuid="02a85f92-befb-40fc-b214-9099b4d17de8"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement textAlignment="Right"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression><![CDATA["Page " + TEXT($V{MASTER_CURRENT_PAGE}, "#,###") + " of " + TEXT($V{MASTER_TOTAL_PAGES}, "####")]]></textFieldExpression></textField>[/code]

No, Jasper Report 6.20.0 is not very old. It is the latest community version published on 3-Aug-2022. https://community.jaspersoft.com/community-download Moving to the server version may not meet OP needs.

Create a variable with a class type of integer and a "Distinct Count" calculation. In the expression add the field you would like a distinct count of. Finally, create a text field on the canvas to display the value of the expression.

It does support Oracle using the JDBC connectivity. You will need to download the Oracle JDBC driver and add it to your Data Adapter on the Driver Classpath tab.

Yes, according to the Package net.sf.jasperreports.compilers API documentation. https://jasperreports.sourceforge.net/api/net/sf/jasperreports/compilers/package-summary.html

It appears that Oracle dropped JDBC NLS environment support in 10g. https://stackoverflow.com/questions/36649277/nls-date-format-with-jdbc

What's the problem you are running into?

Upgrade to a more recent version that supports xlsx, create your own exporter, or export as xls then convert that to xlsx.

Bands do not have a color attribute. You would probably have to create two group headers with a print expression one for odd and the other for even pages/records. Then use a frame in each group header for your coloring. Another way to do it using the same basic logic as above is with a frame and conditional style. When it is an even record ($V{REPORT_COUNT} % 2 == 0) then the color from the style should fire else the default color should fire. <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.14.0.final using JasperReports Library version 6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f --><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_Landscape" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="14147cb5-a441-4dbf-9397-a90041afb815"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="PeimsDS"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="331"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="664"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <style name="Alt Coloring" mode="Opaque" backcolor="#FFFFFF"> <conditionalStyle> <conditionExpression><![CDATA[$V{REPORT_COUNT} % 2 == 0]]></conditionExpression> <style mode="Opaque" backcolor="#E8B8B7" markup=""/> </conditionalStyle> </style> <queryString> <![CDATA[sELECT schoolname, lastName, firstName, Address, Countryfrom ( select 'El Dorado HS' as schoolname, 'Smith' as lastname, 'Jane' as firstname, '123 Main St' as Address, 'Canada' as country from dual union all select 'El Dorado HS','Smith','Bob','321 Main St','Spain' from dual union all select 'El Dorado HS','Smith','Teri','1304 Tyhurst','Canada' from dual union all select 'El Dorado HS','Smith','Jose','423 Barbara St','Space' from dual)]]> </queryString> <field name="SCHOOLNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="SCHOOLNAME"/> <property name="com.jaspersoft.studio.field.label" value="SCHOOLNAME"/> </field> <field name="LASTNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="LASTNAME"/> <property name="com.jaspersoft.studio.field.label" value="LASTNAME"/> </field> <field name="FIRSTNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="FIRSTNAME"/> <property name="com.jaspersoft.studio.field.label" value="FIRSTNAME"/> </field> <field name="ADDRESS" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="ADDRESS"/> <property name="com.jaspersoft.studio.field.label" value="ADDRESS"/> </field> <field name="COUNTRY" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="COUNTRY"/> <property name="com.jaspersoft.studio.field.label" value="COUNTRY"/> </field> <background> <band splitType="Stretch"/> </background> <columnHeader> <band height="22" splitType="Stretch"> <staticText> <reportElement x="11" y="0" width="100" height="16" uuid="7408d444-3aac-4e47-ac60-62c0b78dc671"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="86cce99b-447a-4214-8124-fa26731175e6"/> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <text><![CDATA[sCHOOLNAME]]></text> </staticText> <staticText> <reportElement x="126" y="0" width="100" height="16" uuid="7b5ce5b9-5274-43b2-89cd-7cb6ba739a0d"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6b932a47-b9e1-4889-9dde-535afe55587f"/> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <text><![CDATA[LASTNAME]]></text> </staticText> <staticText> <reportElement x="241" y="0" width="100" height="16" uuid="f6016038-8138-4229-a1bc-53446d6f6ddc"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e6550816-63e6-4953-a5b0-447de08c127d"/> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <text><![CDATA[FIRSTNAME]]></text> </staticText> <staticText> <reportElement x="351" y="0" width="100" height="16" uuid="b78a9d07-a664-4cd2-ad87-829266b37810"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6d926e78-a369-4a6a-b67b-c770cf20e691"/> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <text><![CDATA[ADDRESS]]></text> </staticText> <staticText> <reportElement x="467" y="0" width="100" height="16" uuid="04737ffa-ad85-4cc8-a786-f5daf1db9755"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a855fdd6-b977-4173-83a8-af303e6d3dbf"/> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <text><![CDATA[COUNTRY]]></text> </staticText> <staticText> <reportElement x="600" y="2" width="189" height="16" uuid="2ab7cacd-012c-4160-8f18-f4d373889dbb"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a855fdd6-b977-4173-83a8-af303e6d3dbf"/> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <text><![CDATA[bold First, Last (HTML Markup)]]></text> </staticText> </band> </columnHeader> <detail> <band height="23" splitType="Stretch"> <frame> <reportElement style="Alt Coloring" mode="Opaque" x="4" y="0" width="788" height="23" uuid="aa8c37e8-9f2a-490f-baa7-b4e24ac96168"/> <textField> <reportElement x="7" y="6" width="100" height="14" uuid="ca4e0843-b327-4442-a262-cc18d0fd772a"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="86cce99b-447a-4214-8124-fa26731175e6"/> </reportElement> <textFieldExpression><![CDATA[$F{SCHOOLNAME}]]></textFieldExpression> </textField> <textField> <reportElement x="122" y="6" width="100" height="14" uuid="643a7d95-58d8-4a0b-a7d3-355c0766e820"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6b932a47-b9e1-4889-9dde-535afe55587f"/> </reportElement> <textFieldExpression><![CDATA[$F{LASTNAME}]]></textFieldExpression> </textField> <textField> <reportElement x="237" y="6" width="100" height="14" uuid="05a882e2-8e40-43bc-aa8c-b3f2da01d7ee"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e6550816-63e6-4953-a5b0-447de08c127d"/> </reportElement> <textFieldExpression><![CDATA[$F{FIRSTNAME}]]></textFieldExpression> </textField> <textField> <reportElement x="347" y="6" width="100" height="14" uuid="f905aa8c-2baa-4ee8-aa4f-fd0ed2bdfe8a"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6d926e78-a369-4a6a-b67b-c770cf20e691"/> </reportElement> <textFieldExpression><![CDATA[$F{ADDRESS}]]></textFieldExpression> </textField> <textField> <reportElement x="463" y="6" width="100" height="14" uuid="4d931cc1-73cf-4402-a3be-62d4f91110e6"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a855fdd6-b977-4173-83a8-af303e6d3dbf"/> </reportElement> <textFieldExpression><![CDATA[$F{COUNTRY}]]></textFieldExpression> </textField> <textField> <reportElement x="596" y="3" width="189" height="16" uuid="3a7acd60-54fa-4951-b23c-f6bcb845b637"/> <textElement verticalAlignment="Middle" markup="html"/> <textFieldExpression><![CDATA["<b>" + $F{LASTNAME} + "</b>," + $F{FIRSTNAME} + " ^®"]]></textFieldExpression> </textField> </frame> </band> </detail></jasperReport>[/code]

You could have the stored procedure populate the temp table and return a cursor.

Could you provide an example? I don't understand how SQL is involved in the expression. Based on your screenshot you have your expression language set to Java. In case you are not familiar expression in Jasper is the formula language.

You can use a data adapter with a JDBC connection to connect to an Oracle db.

The answer comes from https://stackoverflow.com/questions/6189121/how-to-show-superscript-for-registered-symbol You will need to set the markup on the textbox to HTML then add ^® for the symbol Expression: "<b>" + $F{LASTNAME} + "</b>," + $F{FIRSTNAME} + " ^®"

>> I need this variable to appear in bold in the exported file. Based on this requirement, you have to set the textbox Markup property. Markup can be styled, HTML, rft, or NONE. HTML is probably your best bet. Conditional style is a good approach but might be overkill for your needs. That said you can follow this link for how-to screenshots https://community.jaspersoft.com/questions/1199566/how-do-i-bold-cell-table-based-value Here is a sample report with both conditional style and markup text: <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.14.0.final using JasperReports Library version 6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f --><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_Landscape" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="14147cb5-a441-4dbf-9397-a90041afb815"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="PeimsDS"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="331"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="664"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <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> <conditionalStyle> <conditionExpression><![CDATA[$F{FIRSTNAME}.equals( "Bob" )]]></conditionExpression> <style isBold="true"/> </conditionalStyle> </style> <subDataset name="Dataset1" uuid="3c8b22a6-915e-4ee7-b6e8-e579c7269adc"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="PeimsDS"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <queryString> <![CDATA[sELECT schoolname, lastName, firstName, Address, Countryfrom ( select 'El Dorado HS' as schoolname, 'Smith' as lastname, 'Jane' as firstname, '123 Main St' as Address, 'Canada' as country from dual union all select 'El Dorado HS','Smith','Bob','321 Main St','Spain' from dual)]]> </queryString> <field name="SCHOOLNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="SCHOOLNAME"/> <property name="com.jaspersoft.studio.field.label" value="SCHOOLNAME"/> </field> <field name="LASTNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="LASTNAME"/> <property name="com.jaspersoft.studio.field.label" value="LASTNAME"/> </field> <field name="FIRSTNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="FIRSTNAME"/> <property name="com.jaspersoft.studio.field.label" value="FIRSTNAME"/> </field> <field name="ADDRESS" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="ADDRESS"/> <property name="com.jaspersoft.studio.field.label" value="ADDRESS"/> </field> <field name="COUNTRY" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="COUNTRY"/> <property name="com.jaspersoft.studio.field.label" value="COUNTRY"/> </field> </subDataset> <queryString> <![CDATA[sELECT schoolname, lastName, firstName, Address, Countryfrom ( select 'El Dorado HS' as schoolname, 'Smith' as lastname, 'Jane' as firstname, '123 Main St' as Address, 'Canada' as country from dual union all select 'El Dorado HS','Smith','Bob','321 Main St','Spain' from dual)]]> </queryString> <field name="SCHOOLNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="SCHOOLNAME"/> <property name="com.jaspersoft.studio.field.label" value="SCHOOLNAME"/> </field> <field name="LASTNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="LASTNAME"/> <property name="com.jaspersoft.studio.field.label" value="LASTNAME"/> </field> <field name="FIRSTNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="FIRSTNAME"/> <property name="com.jaspersoft.studio.field.label" value="FIRSTNAME"/> </field> <field name="ADDRESS" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="ADDRESS"/> <property name="com.jaspersoft.studio.field.label" value="ADDRESS"/> </field> <field name="COUNTRY" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="COUNTRY"/> <property name="com.jaspersoft.studio.field.label" value="COUNTRY"/> </field> <background> <band splitType="Stretch"/> </background> <columnHeader> <band height="22" splitType="Stretch"> <staticText> <reportElement x="11" y="0" width="100" height="16" uuid="7408d444-3aac-4e47-ac60-62c0b78dc671"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="86cce99b-447a-4214-8124-fa26731175e6"/> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <text><![CDATA[sCHOOLNAME]]></text> </staticText> <staticText> <reportElement x="126" y="0" width="100" height="16" uuid="7b5ce5b9-5274-43b2-89cd-7cb6ba739a0d"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6b932a47-b9e1-4889-9dde-535afe55587f"/> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <text><![CDATA[LASTNAME]]></text> </staticText> <staticText> <reportElement x="241" y="0" width="100" height="16" uuid="f6016038-8138-4229-a1bc-53446d6f6ddc"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e6550816-63e6-4953-a5b0-447de08c127d"/> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <text><![CDATA[FIRSTNAME]]></text> </staticText> <staticText> <reportElement x="351" y="0" width="100" height="16" uuid="b78a9d07-a664-4cd2-ad87-829266b37810"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6d926e78-a369-4a6a-b67b-c770cf20e691"/> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <text><![CDATA[ADDRESS]]></text> </staticText> <staticText> <reportElement x="467" y="0" width="100" height="16" uuid="04737ffa-ad85-4cc8-a786-f5daf1db9755"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a855fdd6-b977-4173-83a8-af303e6d3dbf"/> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <text><![CDATA[COUNTRY]]></text> </staticText> <staticText> <reportElement x="600" y="2" width="189" height="16" uuid="2ab7cacd-012c-4160-8f18-f4d373889dbb"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a855fdd6-b977-4173-83a8-af303e6d3dbf"/> </reportElement> <box> <bottomPen lineWidth="1.0"/> </box> <text><![CDATA[bold First, Last (HTML Markup)]]></text> </staticText> </band> </columnHeader> <detail> <band height="19" splitType="Stretch"> <textField> <reportElement x="11" y="5" width="100" height="14" uuid="ca4e0843-b327-4442-a262-cc18d0fd772a"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="86cce99b-447a-4214-8124-fa26731175e6"/> </reportElement> <textFieldExpression><![CDATA[$F{SCHOOLNAME}]]></textFieldExpression> </textField> <textField> <reportElement x="126" y="5" width="100" height="14" uuid="643a7d95-58d8-4a0b-a7d3-355c0766e820"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6b932a47-b9e1-4889-9dde-535afe55587f"/> </reportElement> <textFieldExpression><![CDATA[$F{LASTNAME}]]></textFieldExpression> </textField> <textField> <reportElement style="Table_TD" x="241" y="5" width="100" height="14" uuid="05a882e2-8e40-43bc-aa8c-b3f2da01d7ee"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e6550816-63e6-4953-a5b0-447de08c127d"/> </reportElement> <textFieldExpression><![CDATA[$F{FIRSTNAME}]]></textFieldExpression> </textField> <textField> <reportElement x="351" y="5" width="100" height="14" uuid="f905aa8c-2baa-4ee8-aa4f-fd0ed2bdfe8a"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6d926e78-a369-4a6a-b67b-c770cf20e691"/> </reportElement> <textFieldExpression><![CDATA[$F{ADDRESS}]]></textFieldExpression> </textField> <textField> <reportElement x="467" y="5" width="100" height="14" uuid="4d931cc1-73cf-4402-a3be-62d4f91110e6"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a855fdd6-b977-4173-83a8-af303e6d3dbf"/> </reportElement> <textFieldExpression><![CDATA[$F{COUNTRY}]]></textFieldExpression> </textField> <textField> <reportElement x="600" y="2" width="189" height="16" uuid="3a7acd60-54fa-4951-b23c-f6bcb845b637"/> <textElement markup="html"/> <textFieldExpression><![CDATA["<b>" + $F{LASTNAME} + "</b>," + $F{FIRSTNAME}]]></textFieldExpression> </textField> </band> </detail> <summary> <band height="50"> <componentElement> <reportElement x="19" y="16" width="684" height="31" uuid="8300bf26-d8d7-43b5-9043-ee3efe8b4cb5"> <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="96e376b3-295a-4727-88ca-12531566b1e5"> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="163" uuid="7432c5d7-5669-416a-b631-9ad82a37bf75"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <jr:columnHeader style="Table_CH" height="20" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="163" height="20" uuid="355fb50d-27fb-4aaa-8942-27db4173ea61"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="86cce99b-447a-4214-8124-fa26731175e6"/> </reportElement> <text><![CDATA[sCHOOLNAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="163" height="30" uuid="93a04327-81c1-4f50-912c-fbe7c292767f"/> <textFieldExpression><![CDATA[$F{SCHOOLNAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="160" uuid="f198c408-e346-4d86-b412-76ca0a420584"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> <jr:columnHeader style="Table_CH" height="20" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="160" height="20" uuid="fd9e324e-6bc5-459c-ac57-5c9d1a865d4b"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6b932a47-b9e1-4889-9dde-535afe55587f"/> </reportElement> <text><![CDATA[LASTNAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="160" height="30" uuid="ce9003e5-93d4-410e-99fa-772b46126c61"/> <textFieldExpression><![CDATA[$F{LASTNAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="106" uuid="1a7e311c-d8e1-403a-a987-f1f8956b9dfe"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> <jr:columnHeader style="Table_CH" height="20" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="106" height="20" uuid="636eb699-2fd9-4b71-9d39-613bace04181"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e6550816-63e6-4953-a5b0-447de08c127d"/> </reportElement> <text><![CDATA[FIRSTNAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement style="Table_TD" x="0" y="0" width="106" height="30" uuid="ab9c0eec-9885-4329-ab49-3d9354ee03dc"/> <textFieldExpression><![CDATA[$F{FIRSTNAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="123" uuid="6ae57f18-13de-45c9-b621-39669ec707ae"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/> <jr:columnHeader style="Table_CH" height="20" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="123" height="20" uuid="1b65d902-656d-40a2-bac4-073d4592098b"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6d926e78-a369-4a6a-b67b-c770cf20e691"/> </reportElement> <text><![CDATA[ADDRESS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="123" height="30" uuid="da80131d-f4d9-413d-b458-9c447f61147d"/> <textFieldExpression><![CDATA[$F{ADDRESS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="132" uuid="6ad8095f-9a5c-4c65-be8d-0f3766872f1a"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/> <jr:columnHeader style="Table_CH" height="20" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="132" height="20" uuid="343a1c0f-e5c1-4de9-999f-cbe92ef061a4"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a855fdd6-b977-4173-83a8-af303e6d3dbf"/> </reportElement> <text><![CDATA[COUNTRY]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="132" height="30" uuid="294e9ae7-ffaa-4e5a-ab61-d9dd7476eac7"/> <textFieldExpression><![CDATA[$F{COUNTRY}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </band> </summary></jasperReport>[/code]

Everything @ecanaveras said above is correct. Here is a link to the editions comparison: https://www.jaspersoft.com/editions I will also like to add what my site does is use the Jasper Studio to build the report and then JasperReports Library behind a web interface to run the report. We don't have a need for the end user to view the report online only to receive the PDF or CSV output. My setup is we have a front-end on JBOSS where the user can find and schedule a report. That report is executed using JasperReports Library and then exported for the user to consume. Here are the libraries we use to compile the reports using Ant during the build process: Arial.jarcommons-beanutils-1.9.4.jarcommons-collections4-4.2.jarcommons-digester-2.1.jarcommons-logging-1.1.1.jarecj-3.21.0.jarjasperreports-6.20.0.jarjasperreports-fonts-6.20.0.jarjasperreports-functions-6.20.0.jarjasperreports-javaflow-6.20.0.jarlog4j-api-2.17.1.jarlog4j-core-2.17.1.jarlog4j-jcl-2.17.1.jar<customScriptlet>.jar[/code]I am not the developer for the front-end or report execution so I cannot speak to that code or what libraries are used.

Here is a link to the JFreeChart Sample: http://jasperreports.sourceforge.net/sample.reference/jfreechart/index.html

Jaspersoft created the github repo https://github.com/Jaspersoft/jasperreports-pdf-lib7 for this.

You can do that using a conditional style, page 51 of https://community.jaspersoft.com/documentation/jasperreports-library-ultimate-guide 1. Create a style 2. Righ-click on the style and create a conditional style 3. Select the new conditional style then navigate to the properties tab. 4. On the properties tab of the conditional style add your conditional expression(s) and set the style attributes 5. Apply the style to the field by selecting the field and setting the style Here is an example of applying the style to an ordinary field object and to a table object. <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.14.0.final using JasperReports Library version 6.14.0-2ab0d8625be255bf609c78e1181801213e51db8f --><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_Landscape" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="14147cb5-a441-4dbf-9397-a90041afb815"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="PeimsDS"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="331"/> <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="664"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <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> <conditionalStyle> <conditionExpression><![CDATA[$F{FIRSTNAME}.equals( "Bob" )]]></conditionExpression> <style isBold="true"/> </conditionalStyle> </style> <subDataset name="Dataset1" uuid="3c8b22a6-915e-4ee7-b6e8-e579c7269adc"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="PeimsDS"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <queryString> <![CDATA[sELECT schoolname, lastName, firstName, Address, Countryfrom ( select 'El Dorado HS' as schoolname, 'Smith' as lastname, 'Jane' as firstname, '123 Main St' as Address, 'Canada' as country from dual union all select 'El Dorado HS','Smith','Bob','321 Main St','Spain' from dual)]]> </queryString> <field name="SCHOOLNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="SCHOOLNAME"/> <property name="com.jaspersoft.studio.field.label" value="SCHOOLNAME"/> </field> <field name="LASTNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="LASTNAME"/> <property name="com.jaspersoft.studio.field.label" value="LASTNAME"/> </field> <field name="FIRSTNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="FIRSTNAME"/> <property name="com.jaspersoft.studio.field.label" value="FIRSTNAME"/> </field> <field name="ADDRESS" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="ADDRESS"/> <property name="com.jaspersoft.studio.field.label" value="ADDRESS"/> </field> <field name="COUNTRY" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="COUNTRY"/> <property name="com.jaspersoft.studio.field.label" value="COUNTRY"/> </field> </subDataset> <queryString> <![CDATA[sELECT schoolname, lastName, firstName, Address, Countryfrom ( select 'El Dorado HS' as schoolname, 'Smith' as lastname, 'Jane' as firstname, '123 Main St' as Address, 'Canada' as country from dual union all select 'El Dorado HS','Smith','Bob','321 Main St','Spain' from dual)]]> </queryString> <field name="SCHOOLNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="SCHOOLNAME"/> <property name="com.jaspersoft.studio.field.label" value="SCHOOLNAME"/> </field> <field name="LASTNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="LASTNAME"/> <property name="com.jaspersoft.studio.field.label" value="LASTNAME"/> </field> <field name="FIRSTNAME" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="FIRSTNAME"/> <property name="com.jaspersoft.studio.field.label" value="FIRSTNAME"/> </field> <field name="ADDRESS" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="ADDRESS"/> <property name="com.jaspersoft.studio.field.label" value="ADDRESS"/> </field> <field name="COUNTRY" class="java.lang.String"> <property name="com.jaspersoft.studio.field.name" value="COUNTRY"/> <property name="com.jaspersoft.studio.field.label" value="COUNTRY"/> </field> <background> <band splitType="Stretch"/> </background> <columnHeader> <band height="16" splitType="Stretch"> <staticText> <reportElement x="11" y="0" width="100" height="16" uuid="7408d444-3aac-4e47-ac60-62c0b78dc671"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="86cce99b-447a-4214-8124-fa26731175e6"/> </reportElement> <text><![CDATA[sCHOOLNAME]]></text> </staticText> <staticText> <reportElement x="126" y="0" width="100" height="16" uuid="7b5ce5b9-5274-43b2-89cd-7cb6ba739a0d"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6b932a47-b9e1-4889-9dde-535afe55587f"/> </reportElement> <text><![CDATA[LASTNAME]]></text> </staticText> <staticText> <reportElement x="241" y="0" width="100" height="16" uuid="f6016038-8138-4229-a1bc-53446d6f6ddc"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e6550816-63e6-4953-a5b0-447de08c127d"/> </reportElement> <text><![CDATA[FIRSTNAME]]></text> </staticText> <staticText> <reportElement x="351" y="0" width="100" height="16" uuid="b78a9d07-a664-4cd2-ad87-829266b37810"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6d926e78-a369-4a6a-b67b-c770cf20e691"/> </reportElement> <text><![CDATA[ADDRESS]]></text> </staticText> <staticText> <reportElement x="467" y="0" width="100" height="16" uuid="04737ffa-ad85-4cc8-a786-f5daf1db9755"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a855fdd6-b977-4173-83a8-af303e6d3dbf"/> </reportElement> <text><![CDATA[COUNTRY]]></text> </staticText> </band> </columnHeader> <detail> <band height="19" splitType="Stretch"> <textField> <reportElement x="11" y="5" width="100" height="14" uuid="ca4e0843-b327-4442-a262-cc18d0fd772a"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="86cce99b-447a-4214-8124-fa26731175e6"/> </reportElement> <textFieldExpression><![CDATA[$F{SCHOOLNAME}]]></textFieldExpression> </textField> <textField> <reportElement x="126" y="5" width="100" height="14" uuid="643a7d95-58d8-4a0b-a7d3-355c0766e820"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6b932a47-b9e1-4889-9dde-535afe55587f"/> </reportElement> <textFieldExpression><![CDATA[$F{LASTNAME}]]></textFieldExpression> </textField> <textField> <reportElement style="Table_TD" x="241" y="5" width="100" height="14" uuid="05a882e2-8e40-43bc-aa8c-b3f2da01d7ee"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e6550816-63e6-4953-a5b0-447de08c127d"/> </reportElement> <textFieldExpression><![CDATA[$F{FIRSTNAME}]]></textFieldExpression> </textField> <textField> <reportElement x="351" y="5" width="100" height="14" uuid="f905aa8c-2baa-4ee8-aa4f-fd0ed2bdfe8a"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6d926e78-a369-4a6a-b67b-c770cf20e691"/> </reportElement> <textFieldExpression><![CDATA[$F{ADDRESS}]]></textFieldExpression> </textField> <textField> <reportElement x="467" y="5" width="100" height="14" uuid="4d931cc1-73cf-4402-a3be-62d4f91110e6"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a855fdd6-b977-4173-83a8-af303e6d3dbf"/> </reportElement> <textFieldExpression><![CDATA[$F{COUNTRY}]]></textFieldExpression> </textField> </band> </detail> <summary> <band height="50"> <componentElement> <reportElement x="19" y="16" width="684" height="31" uuid="8300bf26-d8d7-43b5-9043-ee3efe8b4cb5"> <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="96e376b3-295a-4727-88ca-12531566b1e5"> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="163" uuid="7432c5d7-5669-416a-b631-9ad82a37bf75"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <jr:columnHeader style="Table_CH" height="20" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="163" height="20" uuid="355fb50d-27fb-4aaa-8942-27db4173ea61"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="86cce99b-447a-4214-8124-fa26731175e6"/> </reportElement> <text><![CDATA[sCHOOLNAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="163" height="30" uuid="93a04327-81c1-4f50-912c-fbe7c292767f"/> <textFieldExpression><![CDATA[$F{SCHOOLNAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="160" uuid="f198c408-e346-4d86-b412-76ca0a420584"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> <jr:columnHeader style="Table_CH" height="20" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="160" height="20" uuid="fd9e324e-6bc5-459c-ac57-5c9d1a865d4b"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6b932a47-b9e1-4889-9dde-535afe55587f"/> </reportElement> <text><![CDATA[LASTNAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="160" height="30" uuid="ce9003e5-93d4-410e-99fa-772b46126c61"/> <textFieldExpression><![CDATA[$F{LASTNAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="106" uuid="1a7e311c-d8e1-403a-a987-f1f8956b9dfe"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> <jr:columnHeader style="Table_CH" height="20" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="106" height="20" uuid="636eb699-2fd9-4b71-9d39-613bace04181"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e6550816-63e6-4953-a5b0-447de08c127d"/> </reportElement> <text><![CDATA[FIRSTNAME]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement style="Table_TD" x="0" y="0" width="106" height="30" uuid="ab9c0eec-9885-4329-ab49-3d9354ee03dc"/> <textFieldExpression><![CDATA[$F{FIRSTNAME}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="123" uuid="6ae57f18-13de-45c9-b621-39669ec707ae"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/> <jr:columnHeader style="Table_CH" height="20" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="123" height="20" uuid="1b65d902-656d-40a2-bac4-073d4592098b"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6d926e78-a369-4a6a-b67b-c770cf20e691"/> </reportElement> <text><![CDATA[ADDRESS]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="123" height="30" uuid="da80131d-f4d9-413d-b458-9c447f61147d"/> <textFieldExpression><![CDATA[$F{ADDRESS}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="132" uuid="6ad8095f-9a5c-4c65-be8d-0f3766872f1a"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/> <jr:columnHeader style="Table_CH" height="20" rowSpan="1"> <staticText> <reportElement x="0" y="0" width="132" height="20" uuid="343a1c0f-e5c1-4de9-999f-cbe92ef061a4"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a855fdd6-b977-4173-83a8-af303e6d3dbf"/> </reportElement> <text><![CDATA[COUNTRY]]></text> </staticText> </jr:columnHeader> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="132" height="30" uuid="294e9ae7-ffaa-4e5a-ab61-d9dd7476eac7"/> <textFieldExpression><![CDATA[$F{COUNTRY}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </band> </summary></jasperReport>[/code]